Which Tool Would Death Use to Track the Departed? Excel, SQL, or NoSQL?
If Death decided to maintain records for every soul ever taken, which tool would be the most suitable? While this might sound macabre, it……
$ grep -rn "#Databases" ./posts
Converting a Pandas DataFrame to SQL Statements
In this tutorial, you will learn how to convert a Pandas DataFrame to SQL commands using SQLite. By the end, you’ll be able to generate SQL……
SQL: Group Rows By Minute Intervals
When working with large datasets, especially event logs, it’s common to group data by specific time intervals to better analyze trends and……
Mastering the SQL LAG Function: Comparing Data Like a Pro
The LAG() function in SQL is a window function that provides access to a row at a specified physical offset before the current row within……
SQL: powerful tricks with self-joins
If you are using SQL you know about the many types of joins, like inner join, left join, right, etc.. one particular powerful type of join……
SQL: return a random percentage of rows from a query
Assume you have the following task, you need to get a random percentage of records from a query, how do you do this? it might sound a bit……
SQL: How to find the diff between two record sets
In this article, I will show you how to subtract one result set from another. The database I will use is SQLite which supports the EXCEPT……
Flask: initialize your database with a command line argument!
One common task when deploying applications is to create the database and tables before first run, there are many ways to do this but an……
Use curl to write dinfluxDB
In this article i will show you how to use curl a well known and trusted tool to write data to influxdb, probably now you are wondering……
How to configure a MongoDB
MongoDB is a cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents……