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.
How Python and SQL are Changing the Hedge Fund Industry
rumzzbajwa profile

How Python and SQL are Changing the Hedge Fund Industry

#python #sql #webdev
12
Comments
4 min read
Elasticsearch for Beginners and SQL Developers
egen profile

Elasticsearch for Beginners and SQL Developers

#elasticsearch #sql #tutorial #cloud
3
Comments
1 min read
First NoSQL For SQL Developers
ravi8080 profile

First NoSQL For SQL Developers

#sql #coder #appdeveloper #beginners
3
Comments 1
2 min read
Learn SQL: Microsoft SQL Server - Episode 1: Introduction
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

#sql #beginners #database
31
Comments 2
8 min read
Run SQL Server in Docker container
abdelouahedd profile

Run SQL Server in Docker container

#docker #sql
7
Comments
1 min read
Building a Smart Contract Application Using bSQL and Daml
cassidymountjoy profile

Building a Smart Contract Application Using bSQL and Daml

#blockchain #database #sql #datascience
6
Comments
10 min read
Primary Keys in SQL
jo profile

Primary Keys in SQL

#sql
10
Comments 1
2 min read
A Detailed Report on SQL INJECTION
ks1912 profile

A Detailed Report on SQL INJECTION

#cybersecurity #sql #database #security
3
Comments
6 min read
Open Source SQL Parsers
vrajat profile

Open Source SQL Parsers

#sql #opensource #database
3
Comments
4 min read
Learning MySQL with basic SQL Commands
siddheshcodemaster profile

Learning MySQL with basic SQL Commands

#mysql #sql #database #datascience
8
Comments
6 min read
SQL Anti-pattern: Never Use Boolean Flags
davidrjenni profile

SQL Anti-pattern: Never Use Boolean Flags

#sql #bestpractice #codereview #webdev
5
Comments
3 min read
Introduction to the Join Ordering Problem
agoncharuk profile

Introduction to the Join Ordering Problem

#queryoptimizer #sql #database
5
Comments
4 min read
SQL Server to React in 60 Seconds With Prisma
jonrcrowell profile

SQL Server to React in 60 Seconds With Prisma

#sql #javascript #react #nextjs
53
Comments 1
5 min read
How we sync Stripe to manage trials and subscriptions
thisisgoldman profile

How we sync Stripe to manage trials and subscriptions

#stripe #programming #react #sql
3
Comments
3 min read
What's New in PostgreSQL 14?
crcastle profile

What's New in PostgreSQL 14?

#postgres #tutorial #sql
6
Comments
5 min read
Introducing Tabulamax
diogenesofweb profile

Introducing Tabulamax

#showdev #sql #knex #svelte
5
Comments 3
1 min read
Best practices for AWS Athena
cthompsonh profile

Best practices for AWS Athena

#cloud #aws #athena #sql
26
Comments 2
3 min read
A Data Spider in Recursive SQL
geraldew profile

A Data Spider in Recursive SQL

#sql
5
Comments
11 min read
🚀 The Missing SQL Basics Crash Course
bobbyiliev profile

🚀 The Missing SQL Basics Crash Course

#database #sql #devops #100daysofcode
116
Comments 11
12 min read
Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions
teamrudderstack profile

Replacing Segment Computed & SQL Traits With dbt & RudderStack Warehouse Actions

#sql #dbt #datawarehouse #rudderstack
5
Comments
11 min read
Hindsight 20/20: Querying Any Point in Time
cassidymountjoy profile

Hindsight 20/20: Querying Any Point in Time

#sql #database #datascience
5
Comments
2 min read
Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground
lisahui profile

Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

#database #opensource #devops #sql
6
Comments
1 min read
How To Fix Slow MariaDB Replication Lag
flokoe profile

How To Fix Slow MariaDB Replication Lag

#database #sql #devops #performance
6
Comments
2 min read
How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭
piusrichter profile

How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭

#sqlserver #listlabel #sql #reporting
7
Comments
2 min read
FAQ: blockchain technology in bSQL
cassidymountjoy profile

FAQ: blockchain technology in bSQL

#sql #database #datascience
2
Comments
2 min read
Should I use SQLite, PostgreSQL, or MySQL?
simoncodephere profile

Should I use SQLite, PostgreSQL, or MySQL?

#discuss #sql #database #webdev
168
Comments 26
5 min read
SQL - Resumo para iniciantes
dgoposts profile

SQL - Resumo para iniciantes

#sql #database
2
Comments
4 min read
SQL Lock to give you shock
abirkhan profile

SQL Lock to give you shock

#sql #mysql #database
3
Comments
2 min read
Making SQLite Easy with Codesphere!
simoncodephere profile

Making SQLite Easy with Codesphere!

#sql #sqlite #database #webdev
13
Comments
2 min read
Four Database APIs
torgeek profile

Four Database APIs

#api #sql #json #objectscript
9
Comments
15 min read
Code in Public - Time Management website
alecbsherman profile

Code in Public - Time Management website

#techtalks #lowcode #php #sql
2
Comments
1 min read
Schemaless SQL database for strong and lasting back end
niolap profile

Schemaless SQL database for strong and lasting back end

#database #sql #mongodb #javascript
10
Comments
2 min read
when you have millions of insert statements in a file...
franckpachot profile

when you have millions of insert statements in a file...

#postgres #yugabytedb #sql #database
28
Comments
6 min read
SQL Injection Attacks and How Developers Can Prevent Them
lindsfonnes profile

SQL Injection Attacks and How Developers Can Prevent Them

#webdev #security #sql #100daysofhacking
34
Comments 2
7 min read
In the mist of the Big Data Hype, Let’s Discuss MySQL
veerreshr profile

In the mist of the Big Data Hype, Let’s Discuss MySQL

#sql #mysql #tutorial #programming
4
Comments
4 min read
Sweet Alert JavaScript Library With Oracle Apex
jaseemdev profile

Sweet Alert JavaScript Library With Oracle Apex

#javascript #oracleapex #sql #react
2
Comments
1 min read
How to do a Select clause comparison of LocalDateTime in JPA
ama profile

How to do a Select clause comparison of LocalDateTime in JPA

#java #jpa #sql #codever
5
Comments
1 min read
Infrastructure as SQL
depombo profile

Infrastructure as SQL

#devops #cloud #terraform #sql
35
Comments 4
4 min read
Find Out What It Means to be a Data Scientist at Microsoft
nate_at_stratascratch profile

Find Out What It Means to be a Data Scientist at Microsoft

#datascience #database #dataanalytics #sql
4
Comments
14 min read
Yammer: My personal dive into a practice business problem
ahmedamrawadallahk8 profile

Yammer: My personal dive into a practice business problem

#sql
3
Comments
10 min read
Simple Scalable Search Autocomplete Systems
mdnurahmed profile

Simple Scalable Search Autocomplete Systems

#go #redis #elasticsearch #sql
6
Comments 1
6 min read
Using Recursive Common Table Expressions to fill missing continuous data | Oracle SQL
rolangom profile

Using Recursive Common Table Expressions to fill missing continuous data | Oracle SQL

#sql #plsql #oracle #datascience
5
Comments
2 min read
SQL Query into Pandas DataFrame - Part 3
dendihandian profile

SQL Query into Pandas DataFrame - Part 3

#sql #python #datascience #sqlite
5
Comments
1 min read
sql vs. nosql
promiser profile

sql vs. nosql

#sql #database #dbms
2
Comments
1 min read
Performant script in updating a large table🚀
jimmyyeung profile

Performant script in updating a large table🚀

#django #database #sql #productivity
10
Comments
3 min read
What is SQL and What Its Value?
doramiller303 profile

What is SQL and What Its Value?

#sql #database
2
Comments
2 min read
Databases: Important Theoretical Concepts
fahidlatheef profile

Databases: Important Theoretical Concepts

#sql #postgres #database
16
Comments
4 min read
Another SQL cheat sheet
spo0q profile

Another SQL cheat sheet

#database #sql
30
Comments 1
5 min read
10 Ways to optimise your Database queries
ktnl profile

10 Ways to optimise your Database queries

#sql #postgres #database
24
Comments 2
7 min read
Decentralized Security From a Centralized Database
cassidymountjoy profile

Decentralized Security From a Centralized Database

#sql #database #datascience #blockchain
5
Comments
4 min read
SQL : JSON Datatype
dev117uday profile

SQL : JSON Datatype

#sql #programming #database
6
Comments
4 min read
SQL : Internal Functions
dev117uday profile

SQL : Internal Functions

#sql #programming #database
4
Comments
4 min read
SQL : Sequences
dev117uday profile

SQL : Sequences

#sql #database #programming
3
Comments
1 min read
SQL : Arrays
dev117uday profile

SQL : Arrays

#sql #programming #database
3
Comments
5 min read
SQL : Date/ Time and TimeStamps
dev117uday profile

SQL : Date/ Time and TimeStamps

#sql #programming #database
2
Comments
3 min read
SQL : User Defined Datatypes
dev117uday profile

SQL : User Defined Datatypes

#sql #database #programming
2
Comments
3 min read
SQL : DataTypes
dev117uday profile

SQL : DataTypes

#sql #database #programming
2
Comments
6 min read
MongoDB equivalent of SQL LIKE query
tios profile

MongoDB equivalent of SQL LIKE query

#mongodb #sql #regex
5
Comments
1 min read
SQL Query into Pandas DataFrame - Part 2
dendihandian profile

SQL Query into Pandas DataFrame - Part 2

#sql #python #datascience #sqlite
2
Comments
1 min read
Migration from Mssqlserver to Mongodb for Developers
ekhosravie profile

Migration from Mssqlserver to Mongodb for Developers

#sql #mongodb #database
2
Comments
12 min read
loading...