Community driven content discussing all aspects of software development from DevOps to design patterns. SQLite is an incredibly lightweight and remarkably popular SQL-compliant database. In fact, it’s ...
SQLite has an incredibly small footprint. The database itself, its DLLs and the complimentary diff and analyzer tools are less than 15 MB in size. It's perfect for small mobile devices, advanced ...
Lift the hood on most business applications, and you’ll find they have some way to store and use structured data. Whether it’s a client-side app, an app with a web front end, or an edge-device app, ...
You should now have a file HOME\public_html\phpliteadmin.php Open phpliteadmin.php with a text editor, change the following: //password to gain access (change this to ...
The SQLite database is a wildly successful and ubiquitous software package that is mostly unknown to the larger IT community. Designed and coded by Dr. Richard Hipp, the third major revision of SQLite ...
For each entity in my data model, I'm reaching into my DbContext.Model to discover the data model for that entity. (I use this in a controller that renders the entity's data model as JSON for ...
SQLite tables have a hidden "ROW ID" column. When a table has an "INTEGER PRIMARY KEY" then that column might become an alias for ROW ID. These columns act differently to a regular INTEGER column, or ...
When they need a relational database, software developers and system administrators often choose MySQL or PostgreSQL. For a lighter and simpler solution, however, developers should consider SQLite. It ...