blog/support-for-sqlite-extensions-added/

[utterances-bot]

Support for SQLite extensions added - DB Browser for SQLite

https://sqlitebrowser.org/blog/support-for-sqlite-extensions-added/

[syedasaddev]

import sqlite3

Create a database in RAM

db = sqlite3.connect(':memory:')

Get a cursor object

cursor = db.cursor() cursor.execute(''' CREATE TABLE Ages ( name VARCHAR(128), age INTEGER )''')

cursor.execute('''DELETE FROM Ages''')

Insert users

cursor.execute('''INSERT INTO Ages (name, age) VALUES ('Mara', 28)''') cursor.execute('''INSERT INTO Ages (name, age) VALUES ('Otto', 33)''') cursor.execute('''INSERT INTO Ages (name, age) VALUES ('Fyn', 31)''') cursor.execute('''INSERT INTO Ages (name, age) VALUES ('Neshawn', 17)''')

Select user

cursor.execute('''SELECT hex(name || age) AS X FROM Ages ORDER BY X''')

retrieve the first row

user1 = cursor.fetchone()

Print the first column retrieved(user's name)

print("The first row in the resulting record set : "+user1[0])

Commit changes into database

db.commit()

Close database

db.close()

[justinclift]

@syedasaddev Um, what's that for? :smile: