Simpler alternatives to SQL-like databases

Thread starter DaveC426913
Start date Mar 3, 2023

AI Thread Summary

The discussion centers on finding a simpler alternative to SQL-like databases for a web app that uses a small data store of JSON objects. The current setup requires manual updates, and the goal is to allow clients to edit data dynamically without the complexity of a full SQL database. Suggestions include using local storage, CSV files, or lightweight databases like SQLite, which can be easily deployed without extensive server configuration. Concerns about data integrity and simultaneous edits by multiple users are also raised, emphasizing the need for a straightforward solution that balances simplicity and functionality. Ultimately, SQLite is highlighted as a promising option for its ease of use and minimal setup requirements.

Jul 19, 2023

sophiecentaur

Science Advisor

Homework Helper

Are we risking cracking a small nut with a sledgehammer here? With so little data, why not use Google Sheetsl (or equivalent)? It's usable by a novice or several novices. It also makes sense and you can read the data on the sheet without knowing how to drive a particular language.