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
#60: Break Into Google Spanner Architecture (5 Minutes)
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.
While both WHERE and HAVING are used for filtering rows, condition in WHERE clause is applied before grouping of data and condition on HAVING is applied after grouping
Window functions are an advanced feature of SQL that provides powerful tools for detailed data analysis and manipulation without grouping data into single output rows, which is common in aggregate functions.
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
"Deep" modules, mismatched interfaces - and why SAP is so painful
A complete GPT2 implementation as a single SQL query in PostgreSQL.
Introduction: Losing or forgetting the MySQL root password can be a stressful situation, but don't...
Intro Hello guys! Today I try to write about how to start using psql in Terminal app,...
A SQLite extension which loads a Google Sheet as a virtual table. - 0x6b/libgsqlite
Data is naturally at the heart of the job of a data scientist or data analyst. You can get your...
SQL (Structured Query Language) is a programming language used to manage and manipulate relational...
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implemen…
Learn SQL commands for filtering, string operations, alias, joining tables, if-else statements, and grouping.
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
We've open sourced Trilogy, the database adapter we use to connect Ruby on Rails to MySQL-compatible database servers.
Let's open a hex editor and see what this thing is made of
When migrating from PostgreSQL to MySQL we often get stuck with syntax between databases. Here are...
general purpose extensions to golang's database/sql - jmoiron/sqlx
Databases are the houses of our data and data scientists HAVE TO HAVE A KEY! In this article, I discuss some lesser known concepts of SQL that data scientists do not familiarize themselves with.
Bringing it back to the basics
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
Implementing search in your Rails app can be vexing. Here's a great pattern to use that combines the best parts of ActiveRecord and Postgres.
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
Are you a NoSQL beginner, but want to become a NoSQL Know-It-All? Well, this is the place for you. Get up to speed on NoSQL technologies from a beginner's point of view, with this collection of related progressive posts on the subject. NoSQL? No problem!
To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going...
The ultimate set of SQLite extensions.
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
The last SQL guide for data analysis you'll need! OK, maybe it’s actually the first, but it’ll give you a solid head start.
Historically speaking, processing large amounts of structured data has been the domain of relational databases. Databases, consisting of tables that can be joined together or aggregated…
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implemen…
DuckDuckGo. Privacy, Simplified.
This post is about installing SQL, explaining SQL and running SQL.
How to combine data spread over two CSV files, like separate tables in a normalized relational database.
A command-line client for SQL Server with auto-completion and syntax highlighting - dbcli/mssql-cli