DEV Community

loading...

select * from SQL

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

👋 Sign in for the ability sort posts by top and latest.
Level Up Your dbt Schema Tests in 4 Easy Steps

Level Up Your dbt Schema Tests in 4 Easy Steps

Reactions 2 Comments
3 min read
Introduction to NoSQL (with Pros & Cons)

Introduction to NoSQL (with Pros & Cons)

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

SQL Or NOSQL: That is the question!

Reactions 4 Comments
5 min read
Python function to work with dynamic SQL Queries

Python function to work with dynamic SQL Queries

Reactions 3 Comments
4 min read
Exploit Website Databases Using SQLmap

Exploit Website Databases Using SQLmap

Reactions 2 Comments
2 min read
Connect to MySQL

Connect to MySQL

Reactions 5 Comments
1 min read
Write Faster and More Efficient SQL Queries

Write Faster and More Efficient SQL Queries

Reactions 2 Comments
9 min read
SqlAlchemy Python ORM

SqlAlchemy Python ORM

Reactions 5 Comments
2 min read
SQLite, Perl, and a Boolean

SQLite, Perl, and a Boolean

Reactions 5 Comments 6
2 min read
How to Query in SQFLite using Flutter Apps | Flutter SQFLite Tutorials for beginners #2

How to Query in SQFLite using Flutter Apps | Flutter SQFLite Tutorials for beginners #2

Reactions 4 Comments
1 min read
What I Learned This Week: Database Constraints

What I Learned This Week: Database Constraints

Reactions 5 Comments
2 min read
What is Cost-based Optimization?

What is Cost-based Optimization?

Reactions 3 Comments
5 min read
Docker: how to build & use your first image

Docker: how to build & use your first image

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

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

Reactions 9 Comments
6 min read
Raw SQL vs Rails Queries

Raw SQL vs Rails Queries

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

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

Reactions 6 Comments
10 min read
Connection Leak in MSSQL

Connection Leak in MSSQL

Reactions 6 Comments
1 min read
[SQL] Find third largest record from a table

[SQL] Find third largest record from a table

Reactions 6 Comments
1 min read
Brief Introduction to ORM

Brief Introduction to ORM

Reactions 5 Comments
1 min read
Base64 Conversions in SQL Server

Base64 Conversions in SQL Server

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

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

Reactions 5 Comments
9 min read
Five classic SQL & database posts - June 2021

Five classic SQL & database posts - June 2021

Reactions 23 Comments 1
2 min read
Ordering fuzzy search results by relevancy using trigrams

Ordering fuzzy search results by relevancy using trigrams

Reactions 5 Comments
5 min read
5 Data Sources for Your Next Data Engineering Projects

5 Data Sources for Your Next Data Engineering Projects

Reactions 35 Comments
6 min read
SQL vs NoSQL - Which is better for you?

SQL vs NoSQL - Which is better for you?

Reactions 5 Comments 3
5 min read
Bases de datos: Vistas

Bases de datos: Vistas

Reactions 5 Comments 1
2 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)

Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)

Reactions 4 Comments
2 min read
Funções - PostgreSQL

Funções - PostgreSQL

Reactions 5 Comments
5 min read
PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?

PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?

Reactions 6 Comments
2 min read
Database Design and SQL for Beginners

Database Design and SQL for Beginners

Reactions 4 Comments 1
2 min read
Visualizing Covid-19 PostgreSQL Data With Arctype

Visualizing Covid-19 PostgreSQL Data With Arctype

Reactions 2 Comments
7 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 1)

Ծրագրային անվտանգություն՝ SQL Injection (մաս 1)

Reactions 3 Comments
1 min read
Dialect differences between SQLite and Postgres in Sequelize

Dialect differences between SQLite and Postgres in Sequelize

Reactions 5 Comments
4 min read
Bulk load Pandas DataFrames into SQL databases using Jaydebeapi

Bulk load Pandas DataFrames into SQL databases using Jaydebeapi

Reactions 6 Comments
2 min read
SQL & database monthly wrap up - May 2021

SQL & database monthly wrap up - May 2021

Reactions 14 Comments 5
2 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Reactions 76 Comments 4
12 min read
Paintinglite -- Sqlite3 SDK Specially Designed For iOS

Paintinglite -- Sqlite3 SDK Specially Designed For iOS

Reactions 4 Comments
17 min read
Quick post about the SQLite UPSERT and the new RETURNING clause.

Quick post about the SQLite UPSERT and the new RETURNING clause.

Reactions 4 Comments
2 min read
Automate Backup database SQL Server in docker container.

Automate Backup database SQL Server in docker container.

Reactions 6 Comments
2 min read
Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

Reactions 3 Comments
2 min read
A beginner SQL cheatsheet — Part II: Examples

A beginner SQL cheatsheet — Part II: Examples

Reactions 5 Comments
4 min read
Azure SQL Revealed A Guide to the Cloud for SQL Server Professionals

Azure SQL Revealed A Guide to the Cloud for SQL Server Professionals

Reactions 2 Comments
1 min read
Do Product Led Growth Companies Have Higher Revenue Retention?

Do Product Led Growth Companies Have Higher Revenue Retention?

Reactions 7 Comments
7 min read
A beginner SQL cheatsheet — Part I: Syntax

A beginner SQL cheatsheet — Part I: Syntax

Reactions 5 Comments
4 min read
SQLAlchemy Core in Python: Getting Started

SQLAlchemy Core in Python: Getting Started

Reactions 7 Comments
2 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

Reactions 4 Comments
5 min read
Building a Hybrid SQL + NoSQL E-Commerce Data Model

Building a Hybrid SQL + NoSQL E-Commerce Data Model

Reactions 4 Comments
7 min read
Querying Your In-Memory-Data-Grid: Why and How?

Querying Your In-Memory-Data-Grid: Why and How?

Reactions 5 Comments
8 min read
PostgreSQL: How to update large tables

PostgreSQL: How to update large tables

Reactions 5 Comments
4 min read
Sanitizing SQL in Rails/ActiveRecord

Sanitizing SQL in Rails/ActiveRecord

Reactions 6 Comments
3 min read
Be careful using ROLLBACK on nested transaction in SQL Server!

Be careful using ROLLBACK on nested transaction in SQL Server!

Reactions 6 Comments
3 min read
PlanetScale CLI Basics

PlanetScale CLI Basics

Reactions 9 Comments
5 min read
Inner and Outer Joins in SQL

Inner and Outer Joins in SQL

Reactions 10 Comments 2
3 min read
📊 A couple of interesting Stack Overflow queries to play with [Query Stack Overflow] 📈

📊 A couple of interesting Stack Overflow queries to play with [Query Stack Overflow] 📈

Reactions 21 Comments 12
7 min read
PostgreSQL Correct Timezones Handling Cookbook

PostgreSQL Correct Timezones Handling Cookbook

Reactions 7 Comments
2 min read
Opensource Introduction to SQL eBook 💡

Opensource Introduction to SQL eBook 💡

Reactions 24 Comments
3 min read
Rule-based Query Optimization

Rule-based Query Optimization

Reactions 4 Comments
7 min read
Database Modeling With Ecto Part 2 - has many and belongs to Relationships

Database Modeling With Ecto Part 2 - has many and belongs to Relationships

Reactions 10 Comments 1
7 min read
SqlAlchemy: simplify complex joins

SqlAlchemy: simplify complex joins

Reactions 5 Comments
3 min read
Understanding 'Cursor' in SQL

Understanding 'Cursor' in SQL

Reactions 2 Comments
1 min read
loading...
Forem Open with the Forem app