Creating SQLite Databases
Kevin Languedoc · Apress eBooks · 2016
SQLite is very flexible in regards to creating databases. You can include a file extension, or not, as all you really need is to pass a file name and path to the sqlite3_open function and the database will be created and opened—although it won’t contain any structure. Unlike other relational databases like MSSQL, SQLite databases are self-contained and portable. A SQLite database file can run without any changes on all supported platforms, including, of course, iOS. SQLite databases are not designed to run a server.