SQLite

From DreamFactory
Jump to: navigation, search
(Created page with "SQLite is great for a simple and easy setup and usage, but it may not be a good fit for all applications. See why [http://www.sqlite.org/sessions/whentouse.html here]. ==Comm...")
 
Line 2: Line 2:
  
 
==Common Feature Exceptions==
 
==Common Feature Exceptions==
* No support for stored procedures or functions.
+
* No support for stored procedures or functions, therefore no access to '''_proc''' or '''_func''' resources.
* No support for database field expressions.
+
* SQLite has limited ALTER capabilities, therefore, changing table schema can not currently delete or change fields, only add new ones.
 +
* No support for database field expressions. If used, errors will occur from the database as unsupported syntax.
  
 
==Configuration==
 
==Configuration==
 
+
Unlike other SQL databases, SQLite requires no database hostname or credentials, just a file location that is writable by the web server hosting the DreamFactory instance.
* '''database''' - Database filename or full path. If a simple filename is used, the file, if not created already, will be created under the '''''/storage/databases/''''' directory from the root of the installation.
+
* '''database''' - Database filename or full path. If a simple filename (no path) is used, the file will be created under the '''''/storage/databases/''''' directory from the root of the installation if it doesn't already exist.

Revision as of 15:00, 28 July 2016

SQLite is great for a simple and easy setup and usage, but it may not be a good fit for all applications. See why here.

Common Feature Exceptions

  • No support for stored procedures or functions, therefore no access to _proc or _func resources.
  • SQLite has limited ALTER capabilities, therefore, changing table schema can not currently delete or change fields, only add new ones.
  • No support for database field expressions. If used, errors will occur from the database as unsupported syntax.

Configuration

Unlike other SQL databases, SQLite requires no database hostname or credentials, just a file location that is writable by the web server hosting the DreamFactory instance.

  • database - Database filename or full path. If a simple filename (no path) is used, the file will be created under the /storage/databases/ directory from the root of the installation if it doesn't already exist.