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.
Dicas de Grails #2 - acessando o contexto do Spring
loboweissmann profile

Dicas de Grails #2 - acessando o contexto do Spring

#braziliandevs #grails #sql #ptbr
4
Comments
2 min read
Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile
gevera profile

Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile

#svelte #graphql #postgraphile #sql
12
Comments 2
8 min read
Installing Microsoft SQL Server on your Mac with docker
stuartcreed profile

Installing Microsoft SQL Server on your Mac with docker

#sql #mac
2
Comments
1 min read
The SSDT Refactor Log
drmurloc profile

The SSDT Refactor Log

#sql
7
Comments
4 min read
Level Up Your dbt Schema Tests in 4 Easy Steps
cocopo profile

Level Up Your dbt Schema Tests in 4 Easy Steps

#datascience #database #dbt #sql
3
Comments
3 min read
Python function to work with dynamic SQL Queries
bhavanaeh profile

Python function to work with dynamic SQL Queries

#python #postgres #sql #webdev
10
Comments
4 min read
Write Faster and More Efficient SQL Queries
rettx profile

Write Faster and More Efficient SQL Queries

#indexing #guide #sql #database
6
Comments
9 min read
Too Good to Be True: Why NewSQL Failed
rettx profile

Too Good to Be True: Why NewSQL Failed

#database #sql #nosql
2
Comments 1
10 min read
Brief Introduction to ORM
il3ven profile

Brief Introduction to ORM

#database #sql
5
Comments
1 min read
TypeORM - Prevent SQL Injection with Node.js, React and TypeScript
yoshi_yoshi profile

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

#node #security #sql #typescript
45
Comments 2
9 min read
Docker: how to build & use your first image
ossan profile

Docker: how to build & use your first image

#docker #linux #sql #devops
6
Comments
6 min read
Introduction to NoSQL (with Pros & Cons)
taavirehemagi profile

Introduction to NoSQL (with Pros & Cons)

#nosql #sql #database #performance
3
Comments
6 min read
Amazon Redshift ML - Creating Machine Learning Models with Standard SQL.
kamparia profile

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

#aws #machinelearning #sql #datascience
10
Comments 1
6 min read
Raw SQL vs Rails Queries
samalasumanth0262 profile

Raw SQL vs Rails Queries

#rails #ruby #sql #performance
12
Comments
2 min read
5 Data Sources for Your Next Data Engineering Projects
seattledataguy profile

5 Data Sources for Your Next Data Engineering Projects

#database #datascience #beginners #sql
38
Comments
6 min read
SQL Or NOSQL: That is the question!
bekbrace profile

SQL Or NOSQL: That is the question!

#sql #mysql #database #mongodb
5
Comments
5 min read
What I Learned This Week: Database Constraints
desilerma25 profile

What I Learned This Week: Database Constraints

#postgres #database #sql
5
Comments
2 min read
Exploit Website Databases Using SQLmap
attaullahshafiq10 profile

Exploit Website Databases Using SQLmap

#sql #cybersecurity #security
5
Comments
2 min read
Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka
ftisiot profile

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

#apachekafka #apacheflink #streaming #sql
11
Comments
11 min read
Database Design and SQL for Beginners
markm208 profile

Database Design and SQL for Beginners

#database #sql #sqlite
4
Comments 2
3 min read
Connection Leak in MSSQL
ssukhpinder profile

Connection Leak in MSSQL

#todayilearned #sql #beginners #discuss
5
Comments
1 min read
[SQL] Find third largest record from a table
mu profile

[SQL] Find third largest record from a table

#sql
6
Comments
1 min read
Connect to MySQL
sbalasa profile

Connect to MySQL

#sql #mysql
6
Comments
1 min read
SqlAlchemy Python ORM
sbalasa profile

SqlAlchemy Python ORM

#sql #sqlalchemy #orm
6
Comments
2 min read
Dialect differences between SQLite and Postgres in Sequelize
evantahler profile

Dialect differences between SQLite and Postgres in Sequelize

#node #postgres #sql
5
Comments
4 min read
SQLite, Perl, and a Boolean
fgasper profile

SQLite, Perl, and a Boolean

#programming #perl #sql
6
Comments 6
2 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha
jbranchaud profile

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

#sql #postgres #database #performance
96
Comments 6
12 min read
Quick post about the SQLite UPSERT and the new RETURNING clause.
mliakos profile

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

#sql #sqlite
6
Comments
2 min read
SQL vs NoSQL - Which is better for you?
sayanide profile

SQL vs NoSQL - Which is better for you?

#database #sql #tutorial #productivity
5
Comments 3
5 min read
Bases de datos: Vistas
gareisdev profile

Bases de datos: Vistas

#beginners #database #sql
5
Comments 1
2 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)
narek_babajanyan profile

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

#owasp #security #sql
5
Comments
2 min read
Funções - PostgreSQL
alexandrel0pes profile

Funções - PostgreSQL

#postgres #database #sql
6
Comments
5 min read
PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?
ferreira_mariana profile

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

#postgres #sql
7
Comments
2 min read
Sanitizing SQL in Rails/ActiveRecord
nicklevenson profile

Sanitizing SQL in Rails/ActiveRecord

#rails #activerecord #ruby #sql
7
Comments
3 min read
PlanetScale CLI Basics
nickelkr profile

PlanetScale CLI Basics

#database #sql #mysql
15
Comments
5 min read
Inner and Outer Joins in SQL
kirstybrews profile

Inner and Outer Joins in SQL

#sql #database #beginners
10
Comments 2
3 min read
📊 A couple of interesting Stack Overflow queries to play with [Query Stack Overflow] 📈
grahamthedev profile

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

#showdev #sql #api #webdev
18
Comments 12
7 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 1)
narek_babajanyan profile

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

#security #sql #injection #owasp
3
Comments
1 min read
Opensource Introduction to SQL eBook 💡
bobbyiliev profile

Opensource Introduction to SQL eBook 💡

#sql #database #webdev #books
27
Comments
3 min read
Database Modeling With Ecto Part 2 - has many and belongs to Relationships
cultofmetatron profile

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

#elixir #phoenix #sql #posgresql
8
Comments 1
7 min read
Automate Backup database SQL Server in docker container.
pobx profile

Automate Backup database SQL Server in docker container.

#sql #linux #docker
8
Comments 1
2 min read
Arel Notes
konnorrogers profile

Arel Notes

#arel #ruby #rails #sql
27
Comments
4 min read
Do Product Led Growth Companies Have Higher Revenue Retention?
rettx profile

Do Product Led Growth Companies Have Higher Revenue Retention?

#growth #product #sql #finance
6
Comments
7 min read
Querying Your In-Memory-Data-Grid: Why and How?
nfrankel profile

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

#sql #cache #inmemorydatagrid #query
5
Comments
8 min read
Sql Joins Cheat Sheet
hoanganhlam profile

Sql Joins Cheat Sheet

#sql #cheatsheet
6
Comments 1
1 min read
PostgreSQL: How to update large tables
gsandec profile

PostgreSQL: How to update large tables

#sql #codereview #tutorial #postgres
7
Comments
4 min read
Be careful using ROLLBACK on nested transaction in SQL Server!
hanewali profile

Be careful using ROLLBACK on nested transaction in SQL Server!

#sql
7
Comments
3 min read
What is SQL mainly used for?
katholder profile

What is SQL mainly used for?

#sql #database #programming #devops
2
Comments
3 min read
SQL Joins
danyson profile

SQL Joins

#sql #database #tutorial
24
Comments 1
3 min read
Ordering fuzzy search results by relevancy using trigrams
anakbns profile

Ordering fuzzy search results by relevancy using trigrams

#sql #postgres #performance
6
Comments
5 min read
Rule-based Query Optimization
devozerov profile

Rule-based Query Optimization

#sql #calcite #presto #cockroachdb
4
Comments
7 min read
Best Practices to Become a Data Engineer
ralphbrooks profile

Best Practices to Become a Data Engineer

#python #datascience #sql
9
Comments
11 min read
How to make the most out of #100DaysOfCode
jo profile

How to make the most out of #100DaysOfCode

#100daysofcode #sql #mysql #postgres
7
Comments
3 min read
SqlAlchemy: simplify complex joins
sarcxd profile

SqlAlchemy: simplify complex joins

#python #sql #sqlalchemy
5
Comments
3 min read
Understanding 'Cursor' in SQL
fahadhassan1213 profile

Understanding 'Cursor' in SQL

#sql #mysql #database
4
Comments 1
1 min read
SQL Migrations with Cobra & Golang Migrate
lucasnevespereira profile

SQL Migrations with Cobra & Golang Migrate

#go #sql #cli #webdev
19
Comments
4 min read
Relational vs Non-Relational Database | Simple Explanation 🚀
saumyanayak profile

Relational vs Non-Relational Database | Simple Explanation 🚀

#database #programming #codenewbie #sql
3
Comments 1
4 min read
SQLAlchemy Core in Python: Getting Started
bhuma08 profile

SQLAlchemy Core in Python: Getting Started

#sql #python #database #beginners
5
Comments
2 min read
4 Free AWS courses on PostgreSQL
vishnuchilamakuru profile

4 Free AWS courses on PostgreSQL

#database #postgres #beginners #sql
4
Comments 1
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture
devgraph profile

How Database Load Balancing Completes the 3-Tiered Architecture

#database #sql #webdev #cloud
6
Comments
5 min read
loading...