Forem

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.
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

6
Comments 2
13 min read
How Bruin turns a SELECT query into 9 different materialization strategies across 14 databases

How Bruin turns a SELECT query into 9 different materialization strategies across 14 databases

Comments
10 min read
Materialization strategies: how Bruin and dbt turn SELECT queries into tables

Materialization strategies: how Bruin and dbt turn SELECT queries into tables

Comments
11 min read
SQL Injection – with filter bypass via XML encoding | PortSwigger Lab Note #11

SQL Injection – with filter bypass via XML encoding | PortSwigger Lab Note #11

Comments
2 min read
Data quality testing: how Bruin and dbt take different paths to the same goal

Data quality testing: how Bruin and dbt take different paths to the same goal

1
Comments
7 min read
easy-query: The Most Powerful ORM for Java

easy-query: The Most Powerful ORM for Java

1
Comments
9 min read
Creating a Cross-platform Data Sandbox that makes Working with Data Easier and Faster

Creating a Cross-platform Data Sandbox that makes Working with Data Easier and Faster

1
Comments
3 min read
Power BI Meets SQL: Everything You Need to Know About Database Connections.

Power BI Meets SQL: Everything You Need to Know About Database Connections.

Comments
5 min read
Learning Database Practice from Theory ~ Efficient SQL with the Relational Model
Cover image for Learning Database Practice from Theory ~ Efficient SQL with the Relational Model

Learning Database Practice from Theory ~ Efficient SQL with the Relational Model

Comments
1 min read
SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)
Cover image for SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

1
Comments
2 min read
SQL for Generating Test Data in MySQL
Cover image for SQL for Generating Test Data in MySQL

SQL for Generating Test Data in MySQL

Comments
1 min read
Schema-risk

Schema-risk

1
Comments
2 min read
How to connect Power BI to a SQL database

How to connect Power BI to a SQL database

3
Comments
4 min read
5 SQL Formatting Rules That Make Your Queries Actually Readable

5 SQL Formatting Rules That Make Your Queries Actually Readable

1
Comments
3 min read
How to Store JSON and XML in SQL Databases
Cover image for How to Store JSON and XML in SQL Databases

How to Store JSON and XML in SQL Databases

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