DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
dbt Macros & Jinja Explained (With Real Examples)

dbt Macros & Jinja Explained (With Real Examples)

5
Comments 3
4 min read
Currently learning Data Science, here is what I've learnt so far. Pt.4

Currently learning Data Science, here is what I've learnt so far. Pt.4

1
Comments
2 min read
Your first SQL query can work before you understand it

Your first SQL query can work before you understand it

Comments
3 min read
From 35 seconds to half a second: 70 faster dashboards in plain Postgres

From 35 seconds to half a second: 70 faster dashboards in plain Postgres

Comments
5 min read
How to make a Grocery store Web app with Python, Flask and MySQL (Part-1 How to use MySQL)

How to make a Grocery store Web app with Python, Flask and MySQL (Part-1 How to use MySQL)

Comments
7 min read
Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Comments
8 min read
Why Your Database Gets Slower as Your App Grows

Why Your Database Gets Slower as Your App Grows

1
Comments
3 min read
PostgreSQL MVCC Autovacuum Starvation: HOT Update Breakdown & Table Bloat under Heavy Write Loads

PostgreSQL MVCC Autovacuum Starvation: HOT Update Breakdown & Table Bloat under Heavy Write Loads

Comments
4 min read
Use your filesystem as your database

Use your filesystem as your database

Comments
12 min read
SnowPro Core COF-C03 vs COF-C02: What Changed

SnowPro Core COF-C03 vs COF-C02: What Changed

Comments
2 min read
The 5 Mistakes I Made as a Beginner Data Analyst (And How to Fix Them)

The 5 Mistakes I Made as a Beginner Data Analyst (And How to Fix Them)

Comments
6 min read
Model Critique or Server Evidence: A Debate for Agent SQL Acceptance

Model Critique or Server Evidence: A Debate for Agent SQL Acceptance

Comments
9 min read
SQL and Database Fundamentals: From Tables to Transactions and Indexes

SQL and Database Fundamentals: From Tables to Transactions and Indexes

Comments
17 min read
What 6,000 Pharmacy Transactions Taught Me About Discounts

What 6,000 Pharmacy Transactions Taught Me About Discounts

1
Comments
6 min read
Write-Audit-Publish: Never Promote a Bad Table Again

Write-Audit-Publish: Never Promote a Bad Table Again

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.