databases/sql (all)
This tutorial shows you various ways to import CSV data into an SQLite table using sqlite3 and SQLite Studio tools.
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
#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...
Developed by ETH Zürich, the language explores new paradigms for LLM programming.
Intro Hello guys! Today I try to write about how to start using psql in Terminal app,...
Recursive queries are a straightforward solution to querying hierarchical trees. However, one loop in the relationship references results in a failing or never ending query when cycle detection is not used.
Simple hacks to try before moving to a different data model altogether
The QUALIFY clause is pure syntactic sugar
A SQLite extension which loads a Google Sheet as a virtual table. - 0x6b/libgsqlite
Speed up your SQL learning curve.
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
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
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
Finally, start practicing SQL with your own database
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.
Use these simple techniques to make your analysis and data extracts easier
Bringing it back to the basics
A Quick Guide to the IF, CASE, and IFNULL Statements
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
Reviewing more advanced SQL operations to extract additional data insights from the Irish Weather dataset.
SQL is a programming language used by relational database management systems. It provides numerous functions and methods that operate on the data stored in relational databases. SQL is not just a…
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!
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...
If you’ve been practicing your SQL religiously, like I suggested in Top Skills to Ace Every SQL Interview Question, then you’ve probably…
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…
How to avoid those dreaded pitfalls and “gotcha” moments when selecting databases for your next application?
A practical guide with MongoDB
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…
From the power of hierarchical queries to that of procedural constructs in SQL
Using SQLite to store your Pandas dataframes gives you a persistent store and a way of easily selecting and filtering your data
DuckDuckGo. Privacy, Simplified.
521 votes, 27 comments. 411K subscribers in the computerscience community. The hot spot for CS on reddit.
Transforming spreadsheets into queryable database tables
MongoDB and SQL databases are two polar opposite sides of the backend world. The former deals with chaotic unstructured data, while the…
This post is about installing SQL, explaining SQL and running SQL.
Everything You Need to Get Started!
The SQL queries I use as a data scientist and software engineer
I'm re-installing MySQL (5.7.29) for Ubuntu Linux 18.04 LTS. I installed the package using apt & started the service without issue. I was not asked for a root password during the install and am...
How to combine data spread over two CSV files, like separate tables in a normalized relational database.
In this new chapter, we are going to show the following examples in a local SQL Server using SQL Server command line (sqlcmd).
A command-line client for SQL Server with auto-completion and syntax highlighting - dbcli/mssql-cli