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

Decouple ASP.NET Core Identity, Authentication and Database Engines

by Zijian

Reusable codes for JWT security in business applications

More SQLite Multi-threading

by Mircea Neacsu

Examines the performance of SQLite in multi-threading applications

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

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.

All Articles

Sqlite

Run Database and GUI Clients in Docker

6 Jul 2022 by DiponRoy

Quick start example to run DB and clients in docker

Full Service SQLite for WPF (Including File Handling)

19 Jun 2015 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.

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

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

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How to View SQLite Data from Droidio

7 Apr 2014 by B. Clay Shannon

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

Generator for SQLite Use in Android

13 Nov 2014 by A.Ebrahimi

Tools introduction for Android developers who use SQlite in coding

Business Logic Server as Windows Service (Architectural Prototype)

23 Jan 2016 by Igor_A

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

entity-framework

Android Database Example Project (Thread Safe Version)

13 Jun 2014 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.

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

SQL-Server-2008R2

Yet Another Duplicate File Detector

22 Jan 2016 by kaviteshsingh

Simple utility to scan and find duplicate files in a directory.

Use of Realm Object in Realm Event Handler

23 Jun 2018 by Biswal Tanmaya

Use of Realm object in Realm event handler

Updating an SQLite database

21 Aug 2011 by Mike Hankey

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

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

13 Jun 2013 by Deepali Dhingra

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

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

11 Jul 2015 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.

Using Data Classes in ASP.NET - A Beginner's Guide

16 Aug 2015 by Wombaticus

A beginner's introduction to using data classes in ASP.NET.

How To Select Rows by Row Number in Sqlite

5 Sep 2015 by Member 2007625

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

Building a Simple Typescript ORM around sqlite

4 Sep 2021 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.

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

10 Mar 2022 by Master DJon

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

entity-framework

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

31 Mar 2023 by Member 4206974

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

Using SQLite: An Example of CRUD Operations in C#.NET

20 Nov 2015 by Lộc Nguyễn

With a DEMO WPF application (WinNotif)

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

7 Jun 2017 by Niemand25

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

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

20 May 2014 by B. Clay Shannon

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

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

23 Dec 2015 by Md. Marufuzzaman

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

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Database Driven Properties

12 Nov 2014 by Christopher Crain

Create a dynamic class driven by your database.

Xamarin + SQlite + Android

2 Nov 2014 by Ullas_Krishnan

How to use SQLite with Xamarin C# Android

Logtext with Parameters using sqlite3

15 Aug 2016 by Anthony Lansbergen

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

Easy Database Table Change History

5 Nov 2014 by Johnny L Washington

Capture data changes in history table

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Quick-and-Dirty Deployment of Apps

9 Dec 2014 by B. Clay Shannon

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

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Overloaded Server: Quick Fix

7 Dec 2015 by Igor_A

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

entity-framework

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

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

17 May 2019 by Emrah Koçak

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

Auto Increment Column Options in Different Databases

4 Jul 2022 by DiponRoy

How to auto increment column options in databases

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

20 Mar 2015 by furytrader

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

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

7 Mar 2015 by IAndreev93

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

SQL-Server-2008R2

UniDAC - database's direct connection

29 Sep 2015 by Thiago Gaidzinski

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