Category: Sqlite

SQLite, a lightweight database, is a relational database management system that complies with ACID. It is contained in a relatively small C library. It is a public domain project established by D. Richard Hipp. Its design goal is embedded, and it has been used in many embedded products. It occupies very low resources. In embedded devices, only a few hundred K of memory may be enough. It can support mainstream operating systems such as Windows/Linux/Unix, and can be combined with many programming languages, such as Tcl, C#, PHP, Java, etc., as well as ODBC interfaces. It is also compared with the two open source Mysql and PostgreSQL In terms of world-famous database management systems, its processing speed is faster than them.

How to add foreign keys to an existing SQLite table?

I have the following table:

CREATE TABLE child(
id INTEGER PRIMARY KEY,
parent_id INTEGER,
description TEXT); How to add foreign key constraints on parent_id? Assume that foreign keys are enabled.

Most examples assume that you are creating a table-I want to add constraints to an existing table.

September 22, 2021By Simo Sqlite Existing, How to add, SQLITE, tableLeave a Comment

Where can I find the old SQLite version of the source file?

The downloads page on www.sqlite.org seems to have only a link to the current version. I want to get a previous version. I don’t see any obvious links to historical versions on the website (unless

September 22, 2021By Simo Sqlite file, Find, old, source, SQLITE, version, Where, You canLeave a Comment

Import SQLite Database from SDCARD to Android – No Assets folder

I am trying to import my sqlite database from sdcard or any external location to my Android application. My application requires database import so that the database schema will not change, but the

September 22, 2021By Simo Sqlite Android, Assets, database, folders, import, no, SDCARD, SQLITELeave a Comment

Create a SQLite database (2)

First create a database table, and then perform the delete update operation in the main activity

public< /span> class MainActivity extends AppCompatActivity {

@Override

protected void

September 22, 2021By Simo Sqlite create, database, SQLITE, twoLeave a Comment

How to convert Unix era in SQLite

Can you help me convert the unix era into the format yyyy-mm-dd hh:mm:ss(24h) in sqlite? (GMT 7 is very appreciated).

For example: from 1319017136629 to 4:38:56 PM GMT 7 on Wednesday, October

September 22, 2021By Simo Sqlite Central, conversion, How, SQLITE, Times, UNIXLeave a Comment

Use the Order By clause in the group_concat function in SQLite

I don’t think I can use the ORDER BY clause in the GROUP_CONCAT function.

Does anyone know a tricky way to implement this behavior in SQLite? ?

I have seen this question before. But I h

September 22, 2021By Simo Sqlite CONCAT, function, Group, order, SQLITE, UsedLeave a Comment

What is the priority of multiple JOIN statements in SQLITE?

To my surprise, the following two queries returned different results:

SELECT *
FROM foo
JOIN bar
ON bar.id=foo.bar_id
JOIN baz
ON baz.id=foo.baz_id
LEFT JOIN zig
ON zig.foo_id=foo.id;

September 22, 2021By Simo Sqlite JOIN, middle, multiple, priority, SQLITE, statement, whatLeave a Comment