Visual DB is the fastest way to create data entry forms for your database: Starting with an Excel spreadsheet, you can import your data into the database and create a great-looking form in under 10 minutes. Watch this video: https://youtu.be/6rVD5rmrjN8
Visual DB is a comprehensive SaaS frontend for your database. In addition to data entry forms, Visual DB also has a spreadsheet-like interface for inserting and updating data in your database. You can also build interactive reports using Visual DB. Finally, although not intended as a replacement for your database's admin tool, Visual DB can browse schema, create tables, set up relationships, and import and export data.
Visual DB began as a drag-and-drop form builder for databases. Forms created with Visual DB are practically indistinguishable from those hand-coded using React. You can add client-side validation, set available values (displayed in dropdowns), define default values, and even add logic to dynamically hide or disable fields—all without writing a single line of code! With Visual DB Forms, you’ll never have to write another CRUD app again.
If you have been using Excel to manage data and running into its limits because the volume of data has grown, Visual DB Sheets may be of interest to you. With its spreadsheet-like interface, Visual DB Sheets allows users to interact with data as they would in Excel, while securely storing that data in a robust relational database. Spreadsheet-database hybrids have been around for a while now, but we believe we have one of the best implementations, with features such as advanced grouping, support for foreign keys and lookup tables, query parameters, full-text as-you-type filtering, and so on.
The newest feature of Visual DB is interactive reporting. Traditional reporting tools offer limited interactivity. For example, while most reporting tools support time series charts, they do not allow users to zoom or pan along the time axis. In contrast, Visual DB supports this capability thanks to its innovative approach: it downloads the dataset to the client and processes and visualizes data directly in the browser. This allows it to handle user interactions without a server round trip. Visual DB has excellent support for query parameters, which allows you to bring only the subset of data that's of interest (up to 100K rows), to the client.
Visual DB supports PostgreSQL (including Neon), MySQL, SQL Server and Oracle. Give it a whirl, and we look forward to getting your feedback: https://visualdb.com
Beside this, the tool looks great, congrats for the job, well done!
If you are looking for free open source version try
https://github.com/nocodb/nocodb
It's fairly simple to setup. Please refer to our readme/docs
Disclaimer: founder here.
We are building a couple of small internal applications using React and deployed on AWS.
For enabling users with UI for managing the master data tables we want to use a ready to use component - i guess somewhat like nocodb.
Could you by any chance point to some examples of how one might integrate this solution into another app within its branding and navigation.
If there ate other similar tools that might also allow power users to define the schema of new tables and constraints / pk-fk references on them etc using a similar web UI -- that would be great too.
Thanks
1) Granular user roles/permissions. Nocodb has this but it’s a little awkward with different bases. For example it’s hard to see which tables that user is limited to as you create new bases.
2) Forms. The form needs to have flexibility in required fields which nocodb (and not just based on schema) does but it’s missing a key feature. That would be “created by” field which doesn’t work on external database with different bases for different permissions. As in if you have a different base per user group (to have different permission on table access) adding a new record does not populate created by correctly.
3) relational data. The goal of these products is for non-technical people to use these and none have the option of clicking into the relation to bring up that record on its table. As in all you see is the description/id of the relational record.
4) at some point you want to possibly use the database for user management. Because you may want to write an internal tooling that scans a qr code or something or the form is client based. But then you have users that may live on a different database interacting with your main database. And then you would need to match the users with what they view and what they can create.
Essentially what I found is that with nocodb is that it is good for viewing data but to add data I need to create forms. But then nocodb lacks in “dashboard” statistics and graphs
Sorry if this is not clearly explained. I’m on holiday and tired rn.
https://baserow.io/
https://github.com/nocodb/nocodb
https://github.com/rowyio/rowy
https://undb.io/
https://teable.io/
I'll happily pay a one-time fee for anything, than ever fall into the SAAS-hostage trap like Adobe or similar vendors.
I'll appreciate any references.
Product feedback: looks super useful.
Landing page feedback: clear and to the point. I love seeing lots of product screenshots. I’d like to see a section about privacy, especially when the product involves db access and AI. Please consider replacing the carousel. https://shouldiuseacarousel.com/
Something to look at how airbnb uses carousels when showing a listings. There are many listings and you're not necessarily interested enough to click yet, and there's a cognitive cost to leaving and re-entering the search experience, so you can either have a modal or allow a carousel. The carousel is the halfway point between interested enough to investigate further but not interested enough to step into a new visual scene and step back out into the search experience.
With the nice addition of forms.
But I can see an all in one database/mini application tool making custom business applications where Lotus Notes and FileMaker used to be.
Edit: as other commenters have mentioned, an on-prem version would certainly ease concerns a bit.