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.
Data Strategies for a Test Automation Framework
dwwhalen profile

Data Strategies for a Test Automation Framework

#qa #testing #automatedtesting #sql
20
Comments
4 min read
Document vs Relational Databases
tehbakey profile

Document vs Relational Databases

#database #sql #nosql
45
Comments 7
3 min read
Creating a Transaction Interceptor Using Nest.js
gibsonjoshua55 profile

Creating a Transaction Interceptor Using Nest.js

#nestjs #sequelize #typescript #sql
32
Comments 4
5 min read
Get started with Dapper .NET
yorek profile

Get started with Dapper .NET

#azure #sql #microorm #csharp
17
Comments
6 min read
Regex: from a backup file list to a RESTORE script in under 2 minutes
rimutaka profile

Regex: from a backup file list to a RESTORE script in under 2 minutes

#productivity #sql #regex
6
Comments
5 min read
A deeper dive into Sequelize queries: dynamic field names, the Op object, and raw SQL insertions
joannat profile

A deeper dive into Sequelize queries: dynamic field names, the Op object, and raw SQL insertions

#javascript #sql
25
Comments 2
3 min read
How to Extract Knowledge from Wikipedia, Data Science Style
wayofnumbers profile

How to Extract Knowledge from Wikipedia, Data Science Style

#sparql #sql #wikidata #ontology
9
Comments
7 min read
Java(Spring Boot) Best Database Practices
sainiankitsaini profile

Java(Spring Boot) Best Database Practices

#springboot #java #sql #database
6
Comments
2 min read
Building REST API with Python, Flask and Azure SQL
yorek profile

Building REST API with Python, Flask and Azure SQL

#azure #sql #python #webdev
19
Comments
4 min read
How to use Change Data Capture (CDC) with Postgres
thiagosilvaf profile

How to use Change Data Capture (CDC) with Postgres

#database #postgres #sql #tutorial
21
Comments 4
3 min read
What have the STORED PROCEDURES ever done for us?
vbilopav profile

What have the STORED PROCEDURES ever done for us?

#database #sql
14
Comments 6
4 min read
Adventures in SQL Source Control with SSDT
drmurloc profile

Adventures in SQL Source Control with SSDT

#sql #database
11
Comments 2
7 min read
Coding Bootcamp - Backend #3 - Databases, SQL, and knex
alexandertrout profile

Coding Bootcamp - Backend #3 - Databases, SQL, and knex

#sql #javascript #node
6
Comments
5 min read
T-SQL CRUD procedures auto-generator
peledzohar profile

T-SQL CRUD procedures auto-generator

#sql #database
38
Comments 2
4 min read
First steps to caching PostgreSQL queries with Redis
secondej profile

First steps to caching PostgreSQL queries with Redis

#postgres #redis #database #sql
53
Comments
5 min read
The Best MYSQL Courses for Beginners
iam_aprogrammer profile

The Best MYSQL Courses for Beginners

#sql #database #webdev #beginners
12
Comments
5 min read
Using the IFS variable to do things with CSV files
cishiv profile

Using the IFS variable to do things with CSV files

#bash #productivity #sql #database
5
Comments
5 min read
Optimize multiple INSERTs (for Oracle)
michelc profile

Optimize multiple INSERTs (for Oracle)

#sql
6
Comments 4
3 min read
How to Synchronize relational databases with Dotmim.Sync
mimetis profile

How to Synchronize relational databases with Dotmim.Sync

#database #synchronization #sql #dotnet
21
Comments 4
5 min read
User management for Node.js & MySQL using Sequelize and PassportJS
darshanbib profile

User management for Node.js & MySQL using Sequelize and PassportJS

#node #sql
34
Comments 6
8 min read
API data persistence with relational databases
cesareferrari profile

API data persistence with relational databases

#sql #backend
10
Comments
3 min read
SQL Story of unbroken chains of events (daily/weekly streaks)
keyridan profile

SQL Story of unbroken chains of events (daily/weekly streaks)

#sql #postgres #tutorial
21
Comments 2
7 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers
kickingthetv profile

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

#testing #sql #database #postgres
14
Comments 2
11 min read
Complete MySQL Course: Beginner to Advanced
iam_aprogrammer profile

Complete MySQL Course: Beginner to Advanced

#sql #database #webdev #tutorial
30
Comments
1 min read
Notes on Migrating from MS SQL Server to PostgreSQL
mjclemente profile

Notes on Migrating from MS SQL Server to PostgreSQL

#sql #postgres #database #webdev
9
Comments
8 min read
API data persistence with relational databases
cesareferrari profile

API data persistence with relational databases

#sql #backend
6
Comments
2 min read
The Wild SQL Query I Wrote For Work This Week
antjanus profile

The Wild SQL Query I Wrote For Work This Week

#sql #database #postgres
61
Comments 1
7 min read
Intro to SQL User Defined Functions (UDFs) in Redshift
realtrevorfaux profile

Intro to SQL User Defined Functions (UDFs) in Redshift

#sql #database #redshift #aws
8
Comments
5 min read
How can I stop a PostgreSQL query automatically when the table is locked?
barbaraips profile

How can I stop a PostgreSQL query automatically when the table is locked?

#help #postgres #sql
5
Comments 2
1 min read
Access Google BigQuery Data with Entity Framework 6
jerodimusprime profile

Access Google BigQuery Data with Entity Framework 6

#csharp #sql #bigquery #tutorial
6
Comments
3 min read
API data persistence
cesareferrari profile

API data persistence

#sql #backend
9
Comments
3 min read
Best way to store array type data inside database?
mittalyashu profile

Best way to store array type data inside database?

#help #database #question #sql
25
Comments 22
1 min read
Free SQL hosting providers ?
sharadcodes profile

Free SQL hosting providers ?

#help #discuss #sql #postgres
27
Comments 23
1 min read
🤔 How to create a MySQL connection and run queries with Python3
benjaminmock profile

🤔 How to create a MySQL connection and run queries with Python3

#python #beginners #database #sql
13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?
h2l profile

Good sources (courses, books, sites) on database design and data modeling?

#database #design #sql
14
Comments 2
1 min read
SQL Conceitos Básicos. Postgres + Docker
gennipher profile

SQL Conceitos Básicos. Postgres + Docker

#docker #sql #postgres #beginners
12
Comments
10 min read
Database generic way of achieving Query Result Change Notification
sivaraam profile

Database generic way of achieving Query Result Change Notification

#help #database #sql #java
7
Comments 1
1 min read
SMSS -'Connect to Server' Hell
dalbirsingh profile

SMSS -'Connect to Server' Hell

#sql #database #devops #azure
6
Comments
1 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL
rinsama77 profile

Basic DB Using SQL Server (Part 3) - retrieve data using SQL

#muict #dblab #sql #database
11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints
rinsama77 profile

Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

#muict #dblab #sql #database
8
Comments
8 min read
Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core
shanemlk profile

Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

#node #csharp #webdev #sql
15
Comments
5 min read
Documenting SQL with Markdown and Diagrams
minchulkim87 profile

Documenting SQL with Markdown and Diagrams

#sql #python #documentation #productivity
24
Comments 5
2 min read
PostgreSQL Tutorial for beginners to Advance level.
vinodchauhan7 profile

PostgreSQL Tutorial for beginners to Advance level.

#sql #beginners #postgres #database
95
Comments 2
18 min read
Setting up an ASP.NET Core Restaurant Website with a Vue.js Online Ordering Page.
shanemlk profile

Setting up an ASP.NET Core Restaurant Website with a Vue.js Online Ordering Page.

#vue #csharp #webdev #sql
10
Comments 1
4 min read
A plea for blogging about SQL
geraldew profile

A plea for blogging about SQL

#sql #data #blogging
8
Comments 1
2 min read
How to organize dynamic attributes/properties of products specification?
mssadewa profile

How to organize dynamic attributes/properties of products specification?

#discuss #javascript #php #sql
6
Comments 2
1 min read
C#: Data Access Batch Execution is now very simple with RepoDb ORM
mikependon profile

C#: Data Access Batch Execution is now very simple with RepoDb ORM

#csharp #dotnet #sql #tutorial
32
Comments 2
5 min read
Index Overview
suvhotta profile

Index Overview

#database #sql #index #rdbms
17
Comments
4 min read
RDBMS or NoSQL: The question that pops up with every new project!
pareshjoshi profile

RDBMS or NoSQL: The question that pops up with every new project!

#database #sql #nosql #backend
13
Comments 8
2 min read
How To Use Postgres With Knex On Your Node API
jimmymcbride profile

How To Use Postgres With Knex On Your Node API

#node #postgres #database #sql
13
Comments
2 min read
Coding Bootcamp - Backend #1 - Asynchronous code
alexandertrout profile

Coding Bootcamp - Backend #1 - Asynchronous code

#javascript #node #sql #postgres
34
Comments 2
1 min read
Laravel, Lumen dockerization
pacoogle profile

Laravel, Lumen dockerization

#docker #laravel #php #sql
7
Comments
1 min read
SQL Join Memento
michelc profile

SQL Join Memento

#sql #snippet
6
Comments
3 min read
Query NetSuite Data through ODBC in Node.js
jerodimusprime profile

Query NetSuite Data through ODBC in Node.js

#node #webdev #sql
9
Comments 3
3 min read
Sinatra Web App: MVC, Sessions, and Routes
jacquelinelam profile

Sinatra Web App: MVC, Sessions, and Routes

#ruby #sql #webdev #beginners
9
Comments
4 min read
SQL API for Real-Time Kafka Analytics in 3 Steps
shawn profile

SQL API for Real-Time Kafka Analytics in 3 Steps

#showdev #kafka #sql #database
6
Comments
8 min read
Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼
alexantra profile

Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

#python #sql #database #analyst
49
Comments 11
5 min read
Exterminate! 🤖 (or Destroying Associated Records in Rails)
thecodepixi profile

Exterminate! 🤖 (or Destroying Associated Records in Rails)

#ruby #rails #sql #database
24
Comments 4
4 min read
The best free courses to learn about Databases and SQL for Beginners
nodejsztutorial profile

The best free courses to learn about Databases and SQL for Beginners

#sql #database #tutorial #beginners
38
Comments
4 min read
♻️🐘 Disposable local Postgres databases (without containers!)
monacoremo profile

♻️🐘 Disposable local Postgres databases (without containers!)

#showdev #sql #postgres #database
22
Comments
6 min read
loading...