Top "Sqlite" questions

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

Password Protect a SQLite DB. Is it possible?

I have to face a new little project. It will have about 7 or 9 tables, the biggest of them will grow …

c# sqlite
Could not load file or assembly 'System.Data.SQLite'

I've installed ELMAH 1.1 .Net 3.5 x64 in my ASP.NET project and now I'm getting this error (whenever I try to …

.net sqlite elmah
How to import load a .sql or .csv file into SQLite?

I need to dump a .sql or .csv file into SQLite (I'm using SQLite3 API). I've only found documentation for …

database sqlite import sqlite-shell
What are the performance characteristics of sqlite with very large database files?

2020 update, about 11 years after the question was posted and later closed, preventing newer answers. Almost everything written here is obsolete. …

database performance sqlite
Importing a CSV file into a sqlite3 database table using Python

I have a CSV file and I want to bulk-import this file into my sqlite3 database using Python. the command …

python database csv sqlite
"Insert if not exists" statement in SQLite

I have an SQLite database. I am trying to insert values (users_id, lessoninfo_id) in table bookmarks, only if …

sqlite constraints sql-insert
How to have an automatic timestamp in SQLite?

I have an SQLite database, version 3 and I am using C# to create an application that uses this database. I …

c# sqlite timestamp
Creating stored procedure and SQLite?

Is it somehow possible to create a stored procedure, when using SQLite?

sqlite stored-procedures
svn cleanup: sqlite: database disk image is malformed

I was trying to do a svn cleanup because I can't commit the changes in my working copy, and I …

sqlite svn tortoisesvn
SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()

I'd like to avoid having many checks like the following in my code: myObj.someStringField = rdr.IsDBNull(someOrdinal) ? string.Empty : …

.net sqlite dbnull