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.
PostgreSQL Foreign Data Wrappers
zchtodd profile

PostgreSQL Foreign Data Wrappers

#sql #database #postgres #python
19
Comments
5 min read
Choosing a Database Manager. SQL or Nah?
thetealpickle profile

Choosing a Database Manager. SQL or Nah?

#beginners #backend #database #sql
9
Comments 5
3 min read
How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?
kp profile

How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

#help #mysql #database #sql
9
Comments 8
1 min read
Building a SQL Development Environment for Messy, Semi-Structured Data
shawn profile

Building a SQL Development Environment for Messy, Semi-Structured Data

#sql #database
7
Comments
5 min read
Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips
seangwright profile

Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips

#kentico #sql #csharp #dotnet
9
Comments
9 min read
Coding Abomination: Conway's Game of Life in TSQL
barrettotte profile

Coding Abomination: Conway's Game of Life in TSQL

#tsql #sql #python #gameoflife
6
Comments 1
3 min read
Grafana Time-Series Dashboards with the Rockset-Grafana Plugin
shawn profile

Grafana Time-Series Dashboards with the Rockset-Grafana Plugin

#opensource #sql #devops
5
Comments
5 min read
Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries
shawn profile

Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries

#serverless #sql #database
9
Comments
5 min read
Blockbuster Movie Trends
williamhuybui profile

Blockbuster Movie Trends

#python #datascience #sql #database
15
Comments
4 min read
A simple user permission model for sophisticated systems
dillonsadofsky profile

A simple user permission model for sophisticated systems

#sql #cpp #mysql
23
Comments
14 min read
Tales from Technological Backwaters
bugmagnet profile

Tales from Technological Backwaters

#javascript #sqlserver #sql
7
Comments
3 min read
What is your favorite SQL viewer/tool
levivm profile

What is your favorite SQL viewer/tool

#discuss #sql #database
6
Comments 9
1 min read
Need help with sql (*_*) !
mahendrachoudhary profile

Need help with sql (*_*) !

#help #database #sql #rails
7
Comments 2
1 min read
The “Natural order” misconception
peledzohar profile

The “Natural order” misconception

#sql #misconceptions
6
Comments
2 min read
Difference between varchar, nvarchar in sql server ?
twostepdeveloper profile

Difference between varchar, nvarchar in sql server ?

#sql #database #bestpractice #datatype
21
Comments 1
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.