SQLite

Great Reads

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Database Initialiser for SQLite and NPoco

by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

A Developer-Centric Approach to Modern Edge Data Management

by Desmond_Tan, Lewis_Carr

Zen is to SQLite what SQLite was to flat file management systems. It provides the full set of capabilities needed to meet the needs of modern edge data management.

A propertymapping Extension for DataReaders

by Jörgen Andersson

A propertymapping extension for DataReaders

Latest Articles

4db: A Dynamic File-based NoSQL Database for C++

by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Database Initialiser for SQLite and NPoco

by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

A Developer-Centric Approach to Modern Edge Data Management

by Desmond_Tan, Lewis_Carr

Zen is to SQLite what SQLite was to flat file management systems. It provides the full set of capabilities needed to meet the needs of modern edge data management.

A propertymapping Extension for DataReaders

by Jörgen Andersson

A propertymapping extension for DataReaders

All Articles

top

SQLite

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

Android - To Do\Shopping List [Tip/Trick] - Part 2

by Deepali Dhingra

This tip explains how to create a to do or Shopping List app with listview, sqlite, dialog and customadapter.

Android Database Example Project (Thread Safe Version)

by Right Handed Monkey

This is a tutorial for accessing sqlite databases in Android in a thread safe manner. If you download the library code, please bookmark, comment on, or rate the article - it helps out tremendously.

Auto Increment Column Options in Different Databases

by DiponRoy

How to auto increment column options in databases

Building a Simple Typescript ORM around sqlite

by Alen Toma

This is a very easy way to build your ORM and have full control over how the database and query is setup.

Business Logic Server as Windows Service (Architectural Prototype)

by Igor_A

An architectural prototype of a business logic server as Windows Service. Sample service implementation and test utility.

Create Table SQLite and MariaDB (Mysql) from JSON Object using PHP PDO.

by Member 4206974

A PHP class that uses PDO for creating a table from JSON Objects

Database Driven Properties

by Christopher Crain

Create a dynamic class driven by your database.

Easy Database Table Change History

by Johnny L Washington

Capture data changes in history table

Executing SQL Code within EntityFrameworkCore Migration in Correct Order (SQLite)

by Master DJon

New MigrationSqlGenerator to generate SQL from MigrationOperations having attribute "ExecuteAfter" or "ExecuteBefore"

Full Service SQLite for WPF (Including File Handling)

by ergohack

System.Data.SQLite is great, but was missing some BLOB support. Switching to the native source project was easier than expected and provided significant functionality benefits.

Generator for SQLite Use in Android

by A.Ebrahimi

Tools introduction for Android developers who use SQlite in coding

How To Select Rows by Row Number in Sqlite

by Member 2007625

It took few days for me to find this solution and I think it worth sharing it.

How to Split Microsoft SQL Server Table Row Data

by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

How to View SQLite Data from Droidio

by B. Clay Shannon

Step-by-step instructions on how to view SQLite data from Android Studio and SQLite Data Browser

Java & JDBC & SQLite: Read Data from User-selected db Table and Show in JTable

by Emiliarge

A JavaFX/Swing NetBeans 8.0 Project with JFrame created by NetBeans's GUI Builder

Load JSON File with Array of Objects to SQLite3 On Python

by Emrah Koçak

How to load a JSON file with array of objects without any information about the attributes into SQLite 3 database

Logtext with Parameters using sqlite3

by Anthony Lansbergen

Using sqlite3 for a multi language log where logdata can contain parameters.

Microsoft SQL: Increase Existing Value In Row Or Add New Row If None Exists

by furytrader

Yes, Virginia, You Can Do This All With One Simple SQL Statement

Overloaded Server: Quick Fix

by Igor_A

Review of an approach of increase clustered server performance. Library sample and test utility.

Quick-and-Dirty Deployment of Apps

by B. Clay Shannon

Simply, quickly, and freely make your apps available to the public

Quick-and-Dirty Way to Get All Records from Any SQLite Table (Using Java from Android)

by B. Clay Shannon

Learn how to get all records from any SQLite table, passing the Table Name as String and receiving a StringBuilder

Run Database and GUI Clients in Docker

by DiponRoy

Quick start example to run DB and clients in docker

Save your Data from LDAP Injection Attack

by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

by Niemand25

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

Streamlined [Data Model-less] Record Editing with a SQLite Data Object Window Base Class

by ergohack

This SQLite Data Object Window base class automates the data updates and the data bindings between the XAML presentation and the SQLite database allowing the minimum of code needed to present and edit SQLite database records.

UniDAC - database's direct connection

by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Updating an SQLite database

by Mike Hankey

Updating an SQLite database to a new version and copying the contents of the old one into the updated database.

Use of Realm Object in Realm Event Handler

by Biswal Tanmaya

Use of Realm object in Realm event handler

Useful SQL Snippets & Own Functions for SQL Server, SQL Server CE, MySQL, SQLite, PostgreSQL

by IAndreev93

Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...