Coder Social home page Coder Social logo

webdb-app / app Goto Github PK

View Code? Open in Web Editor NEW
112.0 112.0 2.0 23 MB

Efficient Database IDE

Home Page: https://webdb.app

License: GNU Affero General Public License v3.0

JavaScript 48.86% Dockerfile 0.07% Shell 0.08% TypeScript 31.64% HTML 16.42% SCSS 2.93%
ai autocomplete cockroachdb database ide mariadb mongodb mysql nosql percona postgresql sql versioning

app's People

Contributors

aleluff avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

app's Issues

Can't open MariaDB database

All databases get stuck "loading".
Error in docker container logs:
select routine_name as name, routine_type as type, routine_schema as 'database' from information_schema.routines where routine_schema != 'sys' order by routine_name This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason: TypeError: routines is not iterable at MySQL.getComplexes (file:///usr/src/app/src/wrapper/mysql.js:230:25) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async Controller.getStructure (file:///usr/src/app/src/endpoint/server/controller.js:65:24)

Collation converter

To be transparent, the feature of converting the entire database, tables, and columns to a certain collation is only available on MySQL due the complexity to implement on other server

Please tell me if you need it

MongoDB translation

Since now, the app call "table" the collection

It's not a big deal if you come from SQL world but Mongo user will certainly complain about it

Tell me if it's a priority

Cloud DB compatibility

With GCP, Aurora and RDS as first goal,

I also thought about Digital Ocean, Atlas and Azure implementation

Tell me if you need this

Unable to 'forget' or update db connection

Using latest safari v17.1.2

I changed the hostname for my mongo db in my docker compose solution.

In the WebDB interface, when I try to update an existing connection, it fails.

When I try to add a new connection, it fails.

Here is a video showing the behavior.

issue.mov

Note: I checked the console and there are lots of errors... is Safari an issue?

Screenshot 2024-02-12 at 1 11 08 PM

Binaries

So

Apple dev ask me 100$ per year for submitting WebDB to their store or allow auto updater which is crucial or this kind of app
I managed to make app work through electron and starting to start preparing gitlab CI to run packaging job in different machines which cost quite a lot in term of time and money

Then I just realized that maybe docker is good enough for every backend dev

Tell me if you REALLY need this because it's very time consuming and Docker fit so well for this App

User Managment

Initially, WebDB was designed for developers, so the need of user managment for each databases system was limited

Upvote if you need this

Row export on query result

Right now, the export feature on query result, export the entire data set

Tell me if you need an option to export specific row, once results are shown

Full MongoDB autocomplete

It's quite difficult to add autocomplete on top of an existing one so I didn't implement it

But tell me if you think it would be a important thing to have collection/column/type name autocomplete

All PostgreSQL comparator

Right now, the are just a few single-char comparator implemented into autocomplete

I thought of implement all of them (there a plenty for PostgreSQL) so let me know if you want this

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.