Show HN: Visual DB – Web front end for your database
visualdb.com
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