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

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

A Simple Android SQLite Example

by Azim Zahir

This is a simple demonstration of using SQLite database in Android.

Accessing Backed Up iPhone SMS Messages

by Dominick Marciano

When iPhone SMS messages are backed up to your computer using iTunes, the messages are stored in a SQLite database. This article will show the layout of this database file and how to access all saved message information.

Advanced WPF TreeViews in C#/VB.Net Part 4 of n

by Dirk Bahle

Tips & Tricks on loading and saving WPF Tree View based content.

An Introduction to Embedded Databases for IoT Developers

by Wayne Applebaum

Actian Zen provides the embedded systems developer with an ACID compliant database that is capable of seamlessly networking across a wide variety of environments, speeding up development, and decreasing maintenance costs.

Anatomy of the Android operating System

by henry sentio kauta

The Android operating System in action

Android - Stock Market Watch (COINS) in C# using Visual Studio 2010

by Sandip.Nascar

Describes the power of C# in building professional application - Stock Market Watch with Charts on Android platform using Mono C#.

Android Data Storage

by Varavut

Lean about how to manage the data

Android dynamic Sqlite database management v.2

by Pavel Durov

Article about dynamic Sqlite database management on Android platform using Java class reflection.

Angular2 + CData API Server: Data-Driven Dynamic Web Apps

by Jerod Johnson

Use the CData Software API Server to create an OData service for your databases and build a dynamic Web app based on the database data.

Antivirus Part--2

by VISWESWARAN1998

An opensource antivirus engine which uses Yara, Locality Sensitive Hashing to detect malware

Article 8 - Handling Input and Storage on Android

by Ahmed Alaa El-Din

This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, Internal Storage, External Storage, SQLite DB, and Web Services

ASP.NET MVC Documents sample Part 2

by Eric Goedhart

Part two of the ASP.NET MVC Documents Sample

Automatic Compilation and Distribution of Reports and Analyses

by JBartlau

This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.

Automation Testing Dogma and Exploration

by Vlad Neculai Vizitiu

Automation testing dogma and exploration

Beginning Hybrid Mobile App Development with Corona SDK

by Anele 'Mashy' Mbanga

Benchmarking the Performance of Embedded DB for .NET: SQL CE 4.0 vs SQLite

by Alexander Galkin

Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.

Build a website with Kaliko CMS using ASP.NET MVC

by Fredrik Schultz

Introduction to Kaliko CMS - an open source content management system for ASP.NET MVC

Building a Questionnaire Site with Node.js

by Afzaal Ahmad Zeeshan, Iqra Ali

Develop questionnaire site with Node.js, SQLite and Pug

Building Dynamic React Apps with Database Data

by Jerod Johnson

This article walks through setting up the CData API Server to create a REST API for a SQLite database and creating a simple React Web application that has live access to the database data.

C# & SQLite - Storing Images

by kribo

How to insert images / binary data into a database.

C#: Avoiding Performance Issues with Inserts in SQLite

by John Atten

If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of inserts or updates. What you will discover is that unless properly implemented, inserting or updating multiple records

C++ Object Relational Mapping (ORM)- Eating the Bun - Part 1 of N

by BrainlessLabs.com, sibani.p

Creating a simple ORM for C++ on-top of SQL database

Calendar - calendar with notes using the Qt framework

by alexey_t

A simple calendar with notes support

Case Insensitive Search Filter in OData ASP.NET Core 2.0 Web API as an OWIN Middleware

by Pawel idzikowski

How to replace the web API request query string to provide case insensitive OData search

Code Sharing in Windows Universal App

by Sumit Samediya

In this article we will learn how to share code between Windows store app and Windows phone app using Windows Universal App development.

Collaborative Todo List with Emitter, SQLite, and Vue.js

by Florimond

Explains how to use Emitter with a database to store the content of collaborative todo list

Create a CRUD web app using JQuery Mobile & WebSQL

by Anele 'Mashy' Mbanga

Demonstrates how to use SQLite database for mobile development

Create Data Classes

by Jeff Gaines

An application that creates a C# class to read/write data to/from an Access, SQLite, or XML database.

Creating a REST Server for a CRUD Web Application from a very Light Stack

by DaveDbViewSharp

Using lightweight server and database components, the article builds a REST server that returns serialised JSON objects to a single-page web application written in JQuery or AngularJS.

Creating JQuery Mobile CRUD Apps using JQM.Show, Genymotion, Android Studio and MS WebMatrix

by Anele 'Mashy' Mbanga

Create JQuery Mobile Apps with JQM.Show on your PC with these tools.

Database Bot using Oscova

by DaveMathews

Use Oscova, a bot development framework, to create a Natural Language Interface to an SQL Database

DataProvider - A Static Library for Handling Databases from C++

by Michael Haephrati

A Static Library which can be used for all kinds of database related needs

DecisionMatrix

by Terence Wallace

Short economics game to analyze human behavior and approach to simulate NPC decision making

Decouple ASP.NET Core Identity, Authentication and Database Engines

by Zijian

Reusable codes for OAuth security in business applications

Displaying recent browsing history

by Michael Haephrati

This article explains how and where browsing history is stored and how to fetch it.

Employee Attendance Tracking

by C Yang

Program to track employee work time

File Inventory - A Hybrid Version Control System

by C Yang

Program to inventory files in directory

File Inventory and Statistics

by C Yang

Program to inventory directories and tally files.

Getting Started with SQLite on Android

by Peter Leow

Perform CRUD, i.e., Create, Read, Update, and Delete, on data using a SQLite Database on Android

Handling Offline Capability and Data Sync In An Android App – Part 1

by Intel

In this 2-part series, we will take a look at how these APIs were used in a sample restaurant Android app, providing a seamless user experience.

JavaScript VB Functions

by Anele 'Mashy' Mbanga

Porting VB functions over to JavaScript and other useful functions

Junk Drawer

by dale.newman

Importing Excel & Delimited Files into a Junk Database

Know your Representatives

by Janaki.T

This app provides an systematic approach to connect public with their elected officials

LayerGen 3.5

by icemanind

Automatically generate Business and Data layers in C# or VB.Net from a SQL Server, Microsoft Access, MySql or SQLite database design.

Learn NServiceBus from .NET Core WebAPI

by Gunnar S

Convert an existing .NET Core WebAPI application to NServiceBus

Loading CSV and SQL Data into Pandas

by Glenn Prince

In this second part of the Data Cleaning with Python and Pandas series, now that we have a Jupyter Notebook set up and some basic libraries initialized, we need to load some data. To do this, we’ll load data from a CSV file, as well as from a local SQLite database.

metastrings: A Simple File-based Dynamic NoSQL Database

by Michael Sydney Balloni

Learn about the inner workings of a dynamic database, and how SQLite is a great fit

More SQLite Multi-threading

by Mircea Neacsu

Examines the performance of SQLite in multi-threading applications

mscript 3.0: Database Programming, Logging, and Many Language Improvements

by Michael Sydney Balloni

Check out the third major revision of mscript for replacing your nasty batch files with simple mscripts

Natural Language Interface to Database using SIML

by DaveMathews

Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL database.

Nested Transactions for System.Data.SQLite with Savepoints

by Midi_Mick

A set of extension methods giving System.Data.SQLite access to Savepoints

Part 1: CodeProject.Show: A CodeProject offline article writer

by Anele 'Mashy' Mbanga

Write your next CodeProject article using CodeProject.Show, a WinForms application

Part 2: CodeProject.Show DeepDive - exploring the source code behind

by Anele 'Mashy' Mbanga

Exploring the source code behind the offline CodeProject article writer CodeProject.Show.

Performing localized week based calendar computations with SQLite

by Oleksandr Dodatko

This tutorial shows how to create and use a SQLite custom function that performs locale aware week based calendar computations.

PHPFM: A Single File, Responsive File Manager

by Michael Chourdakis

A very quick file manager for your PHP site

Quick Introduction to YB.ORM - Object Relational Mapper for C++

by Vaclav Naydenov

How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.

QxOrm - C++ ORM (Object Relational Mapping) Library

by QxOrm

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)

Read SQLite Database from Android Asset Resource

by Yesy

Demonstrates a method to manipulate SQLite databases located in the asset folder

Reading Acrofields from PDF Files

by DotNetSteve

Variety is the spice of life - rewarding PDF AcroForm reader

Rednet DataAccess

by Rednet Software

Rednet.DataAccess is yet another component to work with data that simplifies your use.

Semantic Database: Concept, Architecture and Implementation

by Marc Clifton

No word has a value that can be identified independently of what else is in its vicinity.

Simple file system over SQLite

by Chilap

Implement an easy-to-use file system backed by a SQLite database.

Spinner Controls

by David Crow

How the selection in one spinner control can govern the contents of another

SQLite

by Serge V. Sushko

SQLite access C++ classes

Sqlite and UWP

by Gene Cole (CFSW)

Integrating Sqlite into your Visual Studio/C# application.

SQLite Compare Utility

by liron.levi

Utility for comparing two SQLite database files for both structure and data

SQLite configuration for C# application targeting any CPU - Part 1

by Southmountain

A discussion on how to configure folder structures for C# application with SQLite databases and ADO.NET assemblies with targeting to any CPU, no matter 32-bit or 64-bit. Part 1 is theoretic consideration for project folder structures. Part 2 will give a demo to approve this concept.

SQLite CRUD Operation Using Entity Framework 7

by Lộc Nguyễn

Example of Chinook digital media store database

SQLite Helper (C#)

by adriancs

Simplify the usage between C# and SQLite

SQLite interaction on Android with Visual Studio and Xamarin

by Emiliano Musso

In the present article we'll see how to develop a simple Android solution, through the use of Visual Studio e Xamarin, the developer framework which allows the creation of cross-platform solutions.

SQLite with C#.Net and Entity Framework

by Awesh Vishwakarma

The easiest way to use Entity Framework with SQLite databases in C# Winform and Console Applications

Sqlstone - Part 2: Every User Owns A Personal Copy of the Database: Solving Backend Challenges (Data Availability / Ownership)

by raddevus

Added enhancements to Sqlstone framework

Sqlstone: Every User Owns A Personal Copy of the Database: Solving Backend Challenges (Data Availability / Ownership)

by raddevus

Using .NET Core 8.x to create a WebAPI framework which saves each user's data in a personal copy of Sqlite database.

SVG Filters and Interactivity in Your Project

by Member 12149082

Description of useful SVG Filters and Interactivity

Symmetric Web Server

by Braden Murphy

Lightweight SQL & HTML Web Server Reporting

Testing Entity Framework Core

by Vlad Neculai Vizitiu

How to write automated tests using entity framework core

The Secrets of Internet Explorer Credentials

by Michael Haephrati

Third of several articles covering the secrets of obtaining stored (and encrypted) credentials stored by browsers

The Semantic Database In Action

by Marc Clifton

A Feed Reader Use Case, demonstrating in part how the Semantic Database works, as well as the Higher Order Programming Environment IDE

Unformatted Data Processing using Vim

by Robert Crockett

Use safe Destructive Editing techniques to load a SQLITE table

Universal System.Data.Sqlite binary for .NET and Mono

by Alexei Shcherbakov

How to make almost universal NuGet 'System.Data.Sqlite' package for .NET and Mono

Use existing sqlite database in Windows phone 8.1

by Sumit Samediya

In this article we will learn how to use existing sqlite database in WP 8.1 apps.

Using a Database With Your Android* App

by Android on Intel

In this article we will take a look at Android* SQLite API and helper classes for database creation and maintenance.

Using Python Scripts from a C# Client (Including Plots and Images)

by Thomas Weller

Demonstrates how to run Python scripts from C#

Using SQLite Database with Android

by Mina Samy

A tutorial on using SQLite on Android

Using SQLite Databases in Any Folder in WinRT

by Peter Moore - Chicago

By writing your own Virtual File System with a little C++, you can escape ApplicationData.LocalFolder and read and write databases in any folder your app has access to.

Using SQLite Embedded Database with Entity Framework and Linq-to-SQL

by Rahman Masudur

Using SQLite embedded database with entity framework and Linq-to-SQL

Using SQLite in C#/VB.Net

by Dirk Bahle

A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.

Using SQLite, Leverage the create_aggregate(), and SQL's Between Operator to Create a Normal Probability Distribution Histogram, or What is More...

by rerhart585

Using SQLite, leverage the create_aggregate(), and SQL's Between Operator to create a Normal Probability Distribution Histogram, or what is more commonly referred to as a Bell Curve.

Weather App with MVVM, IoC, DI and API

by Hein Pauwelyn

This is an application made for Windows (Universal) 10 devices made with MVVM, IoC-containers and dependency injection. There is also an API from Yahoo and SQLite service.

Weather or Not

by David Crow

The World's Best Weather Forecasting App (That's the Not Part!)

Weight History Application for Desktop and Android using the Ring Programming Language

by Mahmoud Samir Fayed

Simple database application for Desktop and Android written in the Ring Programming Language

What is Internet of Things, what are wearables and how do they interact to make things better

by Afzaal Ahmad Zeeshan

What are the wearable devices and what is the role of Internet of Things in them and how do they interact to make things better and easy.

Windows Service to block RDP attacks

by Bjørn

A Service listening to Windows EventLog, recognizing attacker IPs and block them in the Windows Firewall.

Working with SQLite in C# & VB

by Graeme_Grant

DotNet.Core.SQLite - a lightweight performance wrapper library for working with SQLite including usage examples in C# & VB

Xamarin Android App Using SQLite and Custom ListView

by Sharad Chandra Pyakurel

This tutorial will explain how to develop android app with Xamarin tool provided by visual studio. This post will walk you through creating a small android app related to AddressBook.

Yet Another ORM ADO.NET Wrapper

by GerVenson

ADO.NET ORM