Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Max

Feb 11 '20

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

#productivity #sql #regex

5 min read

Joanna

Feb 8 '20

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

#javascript #sql

3 min read

Michael Li

Feb 9 '20

How to Extract Knowledge from Wikipedia, Data Science Style

#sparql #sql #wikidata #ontology

7 min read

sainiankitsaini

Feb 8 '20

Java(Spring Boot) Best Database Practices

#springboot #java #sql #database

2 min read

Davide Mauri for Microsoft Azure

Feb 8 '20

Building REST API with Python, Flask and Azure SQL

#azure #sql #python #webdev

4 min read

Thiago

Feb 7 '20

How to use Change Data Capture (CDC) with Postgres

#database #postgres #sql #tutorial

3 min read

vbilopav

Feb 7 '20

What have the STORED PROCEDURES ever done for us?

#database #sql

4 min read

Jonathan Eccker for DealerOn Dev

Feb 7 '20

Adventures in SQL Source Control with SSDT

#sql #database

7 min read

Feb 7 '20

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

#sql #javascript #node

5 min read

Feb 6 '20

T-SQL CRUD procedures auto-generator

#sql #database

4 min read

zakwillis

Feb 6 '20

Why you must add relational database development to your toolkit

#database #productivity #sql

5 min read

I am a Programmer

Feb 5 '20

The Best MYSQL Courses for Beginners

#sql #database #webdev #beginners

5 min read

Feb 5 '20

Using the IFS variable to do things with CSV files

#bash #productivity #sql #database

5 min read

Michel

Feb 4 '20

Optimize multiple INSERTs (for Oracle)

#sql

3 min read

Sébastien Pertus

Feb 4 '20

How to Synchronize relational databases with Dotmim.Sync

#database #synchronization #sql #dotnet

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.