/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

simonwillison.net
| | github.com

Python CLI utility and library for manipulating SQLite databases - simonw/sqlite-utils
1.0 parsecs

Travel
| |
| | yasoob.me

Hi there fellas. Today i am going to teach you how to use sqlite databases with python. This post will cover the basics of making and using a sqlite database with python using the sqlite3 library. Okay lets get started. Firstly if you are using python 2.5 or greater then you will have sqlite3 installed otherwise you will have to install it. Creating and connecting to a database So how do you make a database in python using the sqlite3 library?
3.4 parsecs

Travel
| |
| | til.simonwillison.net

I was messing around in Python with an in-memory SQLite database, when I decided I actually wanted to save my experimental database to a file so I could explore it using Datasette .
2.6 parsecs

Travel
| |
| | architecturenotes.co

How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
26.0 parsecs

Travel
|