This tutorial shows you various ways to import CSV data into an SQLite table using sqlite3 and SQLite Studio tools.
sqlite
Neat open source project on the GitHub organisation for the UK government's Department for Business and Trade: a "Python virtual filesystem for SQLite to read from and write to S3." …
An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations. By the way, the talk about the system that made me me to explore SQLite in anger can now be seen here. Normally it is your Ruby (or Python, or Go, or whatever) program which calls SQLite to make it “do stuff”. Most calls will be mapped to a native call like sqlite3_exec() which will do “SQLite things” and return you a result, converted into data structures accessible to your runtime. But there is another possible direction here - SQLite can actually call your code instead.
Some of the interesting and insane facts I learned about SQLite
Alex Garcia announced the much-anticipated release of sqlite-vec v0.1.0. This new SQLite extension, written entirely in C, introduces a powerful vector search capability to the SQLite database system. Released under the MIT/Apache-2.0 dual license, sqlite-vec aims to be a versatile and accessible tool for developers across various platforms and environments. Overview of sqlite-vec The sqlite-vec extension enables vector search functionality within SQLite by allowing the creation of virtual tables with vector columns. Users can insert data using standard SQL commands and perform vector searches using SELECT statements. This integration means that vector data can be stored and queried within the
Get started with SQLite databases in Python using the built-in sqlite3 module.
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
a.k.a. leave BeautifulSoup in the past and embrace SQL I used DALL·E to generate thumbnails for this post: “cute cartoon|claymation abominable snowman scraping ice off his frozen car windshield” is nightmare fuel Some of the most common web-scraping tasks can be done in pure SQLite - meaning no Python, Node, Ruby, or other programming languages necessary, only the SQLite CLI and some extensions. The main extension that enables this: sqlite-http, which allows you to make HTTP requests and sa
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
general purpose extensions to golang's database/sql - jmoiron/sqlx
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
One of the most valuable technical skills I use working on a data science team in the retail space is SQL…
To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going...
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
Using SQLite to store your Pandas dataframes gives you a persistent store and a way of easily selecting and filtering your data
Transforming spreadsheets into queryable database tables
