Click here to Skip to main content

Submit your article

Sqlite

SQLite

Great Reads

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

by Thomas Weller

Demonstrates how to run Python scripts from C#

Database Bot using Oscova

by DaveMathews

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

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.

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.

Latest Articles

Displaying recent browsing history

by Michael Haephrati

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

SQLite Helper: A Micro-ORM for SQLite Database

by Code Artist

This project showcases how SQLiteHelper simplifies database interactions, which allows developers to concentrate more on the application's logic rather than the complexities of SQL query writing.

Decouple ASP.NET Core Identity, Authentication and Database Engines

by Zijian

Reusable codes for OAuth security in business 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

All Articles

Sqlite

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

26 Aug 2019 by Thomas Weller

Demonstrates how to run Python scripts from C#

machine-learning

Database Bot using Oscova

17 Jan 2017 by DaveMathews

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

Loading CSV and SQL Data into Pandas

29 May 2020 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.

artificial-intelligence

Weather App with MVVM, IoC, DI and API

29 Jul 2016 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.

The Secrets of Internet Explorer Credentials

30 Jan 2017 by Michael Haephrati

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

Decouple ASP.NET Core Identity, Authentication and Database Engines

12 Jul 2024 by Zijian

Reusable codes for OAuth security in business applications

Natural Language Interface to Database using SIML

14 May 2015 by DaveMathews

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

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

22 Nov 2021 by Michael Sydney Balloni

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

Displaying recent browsing history

N 29 Sep 2024 by Michael Haephrati

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

Create a CRUD web app using JQuery Mobile & WebSQL

28 Mar 2015 by Anele 'Mashy' Mbanga

Demonstrates how to use SQLite database for mobile development

Reading Acrofields from PDF Files

29 Sep 2015 by DotNetSteve

Variety is the spice of life - rewarding PDF AcroForm reader

SQL-Server-2008R2

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

8 Dec 2016 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.

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

6 Feb 2017 by Florimond

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

Building a Questionnaire Site with Node.js

13 Nov 2017 by Afzaal Ahmad Zeeshan, Iqra Ali

Develop questionnaire site with Node.js, SQLite and Pug

12 Jun 2020 by David Crow

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

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

8 Jan 2022 by Michael Haephrati

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

Automatic Compilation and Distribution of Reports and Analyses

3 Feb 2023 by JBartlau

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

data-visualization

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

21 May 2015 by Anele 'Mashy' Mbanga

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

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

31 Jan 2018 by Pawel idzikowski

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

metastrings: A Simple File-based Dynamic NoSQL Database

9 Aug 2021 by Michael Sydney Balloni

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

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

15 May 2015 by Anele 'Mashy' Mbanga

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

Use existing sqlite database in Windows phone 8.1

20 Mar 2016 by Sumit Samediya

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

Nested Transactions for System.Data.SQLite with Savepoints

10 Sep 2016 by Midi_Mick

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

A Database Initialiser for SQLite and NPoco

5 Jun 2021 by Private Dobbs

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

Testing Entity Framework Core

12 Nov 2018 by Vlad Neculai Vizitiu

How to write automated tests using entity framework core

entity-framework

21 Aug 2018 by Gene Cole (CFSW)

Integrating Sqlite into your Visual Studio/C# application.

Spinner Controls

13 Sep 2018 by David Crow

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

20 Feb 2020 by Terence Wallace

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

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

24 Jun 2024 by raddevus

Added enhancements to Sqlstone framework

Know your Representatives

22 Aug 2013 by Janaki.T

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

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

1 May 2015 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.

Beginning Hybrid Mobile App Development with Corona SDK

28 Aug 2015 by Anele 'Mashy' Mbanga

SVG Filters and Interactivity in Your Project

25 Mar 2016 by Member 12149082

Description of useful SVG Filters and Interactivity

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

10 Feb 2017 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.

product-showcase

Automation Testing Dogma and Exploration

12 Nov 2018 by Vlad Neculai Vizitiu

Automation testing dogma and exploration

entity-framework

Semantic Database: Concept, Architecture and Implementation

25 Oct 2014 by Marc Clifton

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

Windows Service to block RDP attacks

28 Jul 2015 by Bjørn

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

The Semantic Database In Action

4 Nov 2014 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

Learn NServiceBus from .NET Core WebAPI

13 Aug 2018 by Gunnar S

Convert an existing .NET Core WebAPI application to NServiceBus

C#: Avoiding Performance Issues with Inserts in SQLite

17 Dec 2014 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

Symmetric Web Server

21 Apr 2015 by Braden Murphy

Lightweight SQL & HTML Web Server Reporting

More SQLite Multi-threading

25 Mar 2024 by Mircea Neacsu

Examines the performance of SQLite in multi-threading applications

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

20 May 2015 by Anele 'Mashy' Mbanga

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

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

SQLite CRUD Operation Using Entity Framework 7

4 Feb 2016 by Lộc Nguyễn

Example of Chinook digital media store database

entity-framework

Using SQLite in C#/VB.Net

25 Jun 2018 by Dirk Bahle

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

Build a website with Kaliko CMS using ASP.NET MVC

23 Jan 2016 by Fredrik Schultz

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

SQL-Server-2012

Working with SQLite in C# & VB

1 Jul 2018 by Graeme_Grant

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

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

Android dynamic Sqlite database management v.2

16 Oct 2014 by Pavel Durov

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

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

24 Mar 2013 by Sandip.Nascar

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

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

24 Apr 2019 by QxOrm

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

Using SQLite Databases in Any Folder in WinRT

9 Mar 2015 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.

SQLite Compare Utility

21 Feb 2015 by liron.levi

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

PHPFM: A Single File, Responsive File Manager

5 Feb 2017 by Michael Chourdakis

A very quick file manager for your PHP site

Junk Drawer

7 Mar 2016 by dale.newman

Importing Excel & Delimited Files into a Junk Database

Create Data Classes

4 Mar 2011 by Jeff Gaines

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

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

22 Dec 2017 by Dirk Bahle

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

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

8 Nov 2013 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.

JavaScript VB Functions

10 Jul 2015 by Anele 'Mashy' Mbanga

Porting VB functions over to JavaScript and other useful functions

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

20 Jun 2024 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.

ASP.NET MVC Documents sample Part 2

1 May 2014 by Eric Goedhart

Part two of the ASP.NET MVC Documents Sample

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

6 Aug 2011 by Rahman Masudur

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

entity-framework

1 Jun 2016 by icemanind

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

A Simple Android SQLite Example

6 Jun 2014 by Azim Zahir

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

Getting Started with SQLite on Android

3 Jan 2017 by Peter Leow

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

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

26 May 2022 by Michael Sydney Balloni

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

Simple file system over SQLite

30 Mar 2012 by Chilap

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

Xamarin Android App Using SQLite and Custom ListView

6 Apr 2016 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.

File Inventory - A Hybrid Version Control System

14 Mar 2012 by C Yang

Program to inventory files in directory

SQLite Helper (C#)

28 Mar 2014 by adriancs

Simplify the usage between C# and SQLite

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

30 Oct 2014 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.

C# & SQLite - Storing Images

15 May 2011 by kribo

How to insert images / binary data into a database.

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

21 Sep 2014 by Alexei Shcherbakov

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

Using a Database With Your Android* App

17 Nov 2014 by Android on Intel

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

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

19 Oct 2014 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.

artificial-intelligence

Article 8 - Handling Input and Storage on Android

9 Sep 2014 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

SQLite with C#.Net and Entity Framework

2 Mar 2017 by Awesh Vishwakarma

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

Yet Another ORM ADO.NET Wrapper

12 Sep 2018 by GerVenson

ADO.NET ORM

Using SQLite Database with Android

27 May 2013 by Mina Samy

A tutorial on using SQLite on Android

Android Data Storage

14 Sep 2014 by Varavut

Lean about how to manage the data

Accessing Backed Up iPhone SMS Messages

27 Oct 2014 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.

SQLite interaction on Android with Visual Studio and Xamarin

17 Feb 2017 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.

Rednet DataAccess

18 Jul 2021 by Rednet Software

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

SQLite

11 Apr 2016 by Serge V. Sushko

SQLite access C++ classes

Performing localized week based calendar computations with SQLite

30 May 2012 by Oleksandr Dodatko

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

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

20 Apr 2019 by BrainlessLabs.com, sibani.p

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

Anatomy of the Android operating System

3 Aug 2014 by henry sentio kauta

The Android operating System in action

Code Sharing in Windows Universal App

20 Mar 2016 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.

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

30 Apr 2016 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.

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

3 Jul 2011 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.

Windows-Phone-7

Antivirus Part--2

19 Aug 2019 by VISWESWARAN1998

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

Employee Attendance Tracking

31 Jan 2012 by C Yang

Program to track employee work time

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

10 Oct 2016 by Mahmoud Samir Fayed

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

Calendar - calendar with notes using the Qt framework

12 May 2017 by alexey_t

A simple calendar with notes support

Read SQLite Database from Android Asset Resource

22 Mar 2018 by Yesy

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

File Inventory and Statistics

5 Feb 2012 by C Yang

Program to inventory directories and tally files.

Unformatted Data Processing using Vim

18 Jul 2018 by Robert Crockett

Use safe Destructive Editing techniques to load a SQLITE table