SheetDB
Sheety
SheetBest
Sheetsu
Sheet2api
Sheet 2 Site
Api Spreadsheets
Stein
DrawSQL
DBDiagram.io
Azimutt
MySQL Workbench
PopSQL
DbSchema
LucidChart
DbVisualizer
Transform google spreadsheet into a JSON API and use it as a data store in a matter of seconds. Create google spreadsheet, fill first row with column names, and the rest of data.
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
SheetDB
DrawSQLDrawSQL might be a bit more popular than SheetDB. We know about 12 links to it since March 2021 and only 9 links to SheetDB. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Can you tell me how an app like https://sheetdb.io/? An app like that must send thousands of requests every minute. Source: over 4 years ago
What I would do is to use 'no code' methods here and some services like this https://sheetdb.io/ that connects me to google sheet. Source: about 5 years ago
Good for you! I've actually read :) And for the future, you may get rid of the OAuth problems by using a third-party API. I recommend sheetdb.io. Here's a piece I wrote on this, you might find interesting: https://blog.sheetdb.io/google-spreadsheet-api-without-oauth-2-0-ffd572a06757. Source: about 5 years ago
Try using sheetdb.io - this app will handle your credentials in the background whereas you'll only need to disclose an endpoint in your script with an API key, but it's only to the particular spreadsheet to which you can set permission READ only, if you don't want to let others make any changes there. Source: about 5 years ago
There are many ways to do this these days. One way being uploading said file into google sheet, then use a service like https://sheetdb.io/ or https://sheety.co/ to turn it into an API. Boom, consumable REST API in seconds. Source: about 5 years ago
With this, I went for designing the db. I went to http://drawsql.app/ and created my first draft. Then exported the DDL and did a bit of back and forth with AI. This is the final draft of the database:. - Source: dev.to / 8 months ago
So I started designing the DB using this cool tool. The project has 2 tables, users and categories . The user can create many categories as he wants so the first approach I took was creating a third table, a union table to store user_id and category_id. With this solution the users are able to create x numbers of categories and we can see assign the category to the user. - Source: dev.to / over 1 year ago
Once you have generated the SQL code, you can convert it into a relational schema (the graphical table model) using DrawSQL. This tool offers:. - Source: dev.to / over 1 year ago
DrawSQL makes it easy for teams to collaborate on creating and maintaining schema diagrams. With a single source of truth, there's no need for manually syncing diagram files between different developers and offline tools anymore. Source: about 3 years ago
To be honest, since you are just getting started, I think you should reconsider simplifying this app to begin with. Built something easier and get some more experience before jumping in the ocean. Maybe start by focusing only on the parent company and sub-companies. However, I strongly recommend you to try and make a diagram of your database with relations and columns as it can you a lot of time. I personally use... Source: about 3 years ago
Sheety - Turn any Google sheet into an API instantly, for free. Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime. Neat
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
SheetBest - Turn a Google SpreadSheet into a JSON Database API
Azimutt - Next-Gen ERD to Design, Explore and Document real world databases (big and messy ones ^^)
Sheetsu - Turn Google Spreadsheet into API
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.