#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Problem description & analysis: A certain database table has multiple fields, each storing an email address, which may be null or duplicated.Task: Now we need to merge multiple fields int...

21.04.2025 0 Read More

Statistics by time window: SPL VS SQL #16

The Time field of a certain database table is time, and the time interval is sometimes greater than 1 minute. Now we need to divide the data into windows every minute, fill in the missing windows, and...

22.04.2025 0 Read More

Importing month names into SQLite3 can be useful

SQLite3, very compact and very useful SQLite3 is a marvellously useful tool. I've seen it used in finance, image management, system admin...It's estimated there are billions of SQLite DBs in ...

22.04.2025 0 Read More

Convert LONG to LOB on import(23ai)

Tables utilizing the LONG data type often present challenges when transitioning to LOB data types. Oracle Database 23ai introduces a powerful enhancement to simplify this process. With this release, t...

22.04.2025 0 Read More

Build a Shared-Nothing Distributed Queue with SQLite and Python

Need a lightweight job queue that runs across multiple machines without Redis, RabbitMQ, or cloud services? In this post, we’ll build a surprisingly capable distributed queue using SQLite, Python, a...

22.04.2025 0 Read More

MySQL Timeout 🐬⏰ Explained

MySQL offers various timeout settings that are essential for ensuring system stability, preventing resource exhaustion, and maintaining performance, especially in high-traffic environments or when dea...

22.04.2025 0 Read More

Postgresql soft-delete strategies: balancing data retention

Usually, when we work in applications where the capacity is needed to restore deleted records at certain point in time, such as messaging systems where the user may have deleted messages/attachments b...

23.04.2025 0 Read More

Perbedaan Antara SOQL dan SOSL di Salesforce

1. Apa itu SOQL? SOQL (Salesforce Object Query Language) digunakan untuk men-query data dari satu objek atau beberapa objek yang memiliki hubungan langsung. 🧠 Mirip seperti SQL di database biasa, ...

23.04.2025 0 Read More

Getting Started with SQL: A Guide for Data Analysts

SQL (Structured Query Language) is often the first tool data analysts reach for — and for good reason. It’s powerful, widely used, and surprisingly readable once you get the hang of it.In this pos...

23.04.2025 0 Read More

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

I kept mixing up these SQL commands, so I turned them into courtroom characters to make it stick—comic included! tags: sql, learning, comic, beginners Hey DEV fam 👋I’m currently learni...

23.04.2025 0 Read More

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Statistics by time window: SPL VS SQL #16

Importing month names into SQLite3 can be useful

Convert LONG to LOB on import(23ai)

Build a Shared-Nothing Distributed Queue with SQLite and Python

MySQL Timeout 🐬⏰ Explained

Postgresql soft-delete strategies: balancing data retention

Perbedaan Antara SOQL dan SOSL di Salesforce

Getting Started with SQL: A Guide for Data Analysts

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

#reading

#popular