|
Post by tjvrdev on Mar 26, 2020 13:45:52 GMT
Is it possible to generate a database through a script? Im creating an enterprise application in Unity and the app will need to be able to allow the user to create multiple databases based on different locations. I can add a field to the data and just store all data in one data base, but basically data is being stored in the database every minute. Would I encounter any performance issues if I stored a massive amount of entries in a single database?
|
|
|
Post by echo17 on Mar 27, 2020 13:04:21 GMT
Typically, sqlite can handle millions of rows of data just fine. This is part of the strength of a database over something like json or xml for data storage. I hesitate to say you won't have performance issues without knowing what your schema or data look like, however. If you need to change the database dynamically at runtime, please see this FAQ: linkIf you want to create the database structure entirely with code, you can use the sqlite syntax commands of CREATE TABLE, ALTER TABLE, DROP TABLE, RENAME COLUMN, etc. See this link for more information: link You'll still need a blank database template to copy in first, but once that is connected, you can alter the database using sqlite commands.
|
|