I consider using a database a SQLitebig data warehouse (two hundred thousand records per year). I will make many requests, a small number of updates and inserts. I see that it SQLiteworks very fast. Is it SQLitesuitable and safe for this purpose?
SQLite
SQLite is usually not suitable for multiple simultaneous users; It is ideal for use as a single-process embedded storage.
, - , .
, , , PostgreSQL Oracle .
, SQLite, , ( ); , GRANT REVOKE .
GRANT
REVOKE