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.
Which database to choose for your project

Which database to choose for your project

24
Comments 5
5 min read
Using Dapper over EntityFramework for database operations in .NET Core

Using Dapper over EntityFramework for database operations in .NET Core

9
Comments 2
4 min read
Querying ActiveStorage Attachments

Querying ActiveStorage Attachments

14
Comments 2
1 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

27
Comments 9
3 min read
Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile

Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile

12
Comments 2
8 min read
Level Up Your dbt Schema Tests in 4 Easy Steps

Level Up Your dbt Schema Tests in 4 Easy Steps

3
Comments
3 min read
TypeORM - Prevent SQL Injection with Node.js, React and TypeScript

TypeORM - Prevent SQL Injection with Node.js, React and TypeScript

39
Comments 2
9 min read
5 Data Sources for Your Next Data Engineering Projects

5 Data Sources for Your Next Data Engineering Projects

49
Comments
6 min read
Amazon Redshift ML - Creating Machine Learning Models with Standard SQL.

Amazon Redshift ML - Creating Machine Learning Models with Standard SQL.

10
Comments 1
6 min read
Raw SQL vs Rails Queries

Raw SQL vs Rails Queries

12
Comments
2 min read
SQL Or NOSQL: That is the question!

SQL Or NOSQL: That is the question!

5
Comments
5 min read
Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

11
Comments
11 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

101
Comments 6
12 min read
SQLite, Perl, and a Boolean

SQLite, Perl, and a Boolean

6
Comments 6
2 min read
Sanitizing SQL in Rails/ActiveRecord

Sanitizing SQL in Rails/ActiveRecord

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