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.
The Wild SQL Query I Wrote For Work This Week

The Wild SQL Query I Wrote For Work This Week

61
Comments 1
7 min read
Intro to SQL User Defined Functions (UDFs) in Redshift

Intro to SQL User Defined Functions (UDFs) in Redshift

8
Comments
5 min read
How can I stop a PostgreSQL query automatically when the table is locked?

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

5
Comments 2
1 min read
Access Google BigQuery Data with Entity Framework 6

Access Google BigQuery Data with Entity Framework 6

6
Comments
3 min read
API data persistence

API data persistence

9
Comments
3 min read
Best way to store array type data inside database?

Best way to store array type data inside database?

28
Comments 22
1 min read
Free SQL hosting providers ?

Free SQL hosting providers ?

27
Comments 23
1 min read
🤔 How to create a MySQL connection and run queries with Python3

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

13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?

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

14
Comments 2
1 min read
SQL Conceitos Básicos. Postgres + Docker

SQL Conceitos Básicos. Postgres + Docker

12
Comments
10 min read
Database generic way of achieving Query Result Change Notification

Database generic way of achieving Query Result Change Notification

7
Comments 1
1 min read
SMSS -'Connect to Server' Hell

SMSS -'Connect to Server' Hell

6
Comments
1 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL

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

11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

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

8
Comments
8 min read
Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

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

15
Comments
5 min read
Documenting SQL with Markdown and Diagrams

Documenting SQL with Markdown and Diagrams

24
Comments 5
2 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
Setting up an ASP.NET Core Restaurant Website with a Vue.js Online Ordering Page.

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

10
Comments 1
4 min read
A plea for blogging about SQL

A plea for blogging about SQL

8
Comments 1
2 min read
How to organize dynamic attributes/properties of products specification?

How to organize dynamic attributes/properties of products specification?

6
Comments 2
1 min read
C#: Data Access Batch Execution is now very simple with RepoDb ORM

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

32
Comments 2
5 min read
Index Overview

Index Overview

17
Comments
4 min read
RDBMS or NoSQL: The question that pops up with every new project!

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

13
Comments 8
2 min read
How To Use Postgres With Knex On Your Node API

How To Use Postgres With Knex On Your Node API

13
Comments
2 min read
Coding Bootcamp - Backend #1 - Asynchronous code

Coding Bootcamp - Backend #1 - Asynchronous code

34
Comments 2
1 min read
Laravel, Lumen dockerization

Laravel, Lumen dockerization

7
Comments
1 min read
SQL Join Memento

SQL Join Memento

6
Comments
3 min read
Query NetSuite Data through ODBC in Node.js

Query NetSuite Data through ODBC in Node.js

9
Comments 3
3 min read
Sinatra Web App: MVC, Sessions, and Routes

Sinatra Web App: MVC, Sessions, and Routes

9
Comments
4 min read
SQL API for Real-Time Kafka Analytics in 3 Steps

SQL API for Real-Time Kafka Analytics in 3 Steps

6
Comments
8 min read
Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

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

49
Comments 11
5 min read
Exterminate! 🤖 (or Destroying Associated Records in Rails)

Exterminate! 🤖 (or Destroying Associated Records in Rails)

24
Comments 4
4 min read
The best free courses to learn about Databases and SQL for Beginners

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

38
Comments
4 min read
♻️🐘 Disposable local Postgres databases (without containers!)

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

22
Comments
6 min read
Writing SQL for humans with Literate SQL

Writing SQL for humans with Literate SQL

46
Comments 4
7 min read
Connect to postgresdatabase with JAVA

Connect to postgresdatabase with JAVA

4
Comments
1 min read
Programming Paradigm

Programming Paradigm

85
Comments 9
4 min read
Hierarchical JSON with SQLite / RediSQL

Hierarchical JSON with SQLite / RediSQL

9
Comments
4 min read
Connect your node backend to postgresql database

Connect your node backend to postgresql database

3
Comments
1 min read
Remove duplicates rows with SQL

Remove duplicates rows with SQL

10
Comments
1 min read
Paradigmas de Programação

Paradigmas de Programação

19
Comments 3
4 min read
SQL Indexes 101

SQL Indexes 101

19
Comments
3 min read
Multiple SQL Inserts and Transactions with Objection Js

Multiple SQL Inserts and Transactions with Objection Js

12
Comments
4 min read
PostgreSQL Pro Tip: Beware of BETWEEN

PostgreSQL Pro Tip: Beware of BETWEEN

12
Comments 2
1 min read
SELECT beginner FROM all;

SELECT beginner FROM all;

6
Comments
5 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
NoSql but with SQL

NoSql but with SQL

5
Comments
1 min read
Would you like to have better XML support in SQL Server?

Would you like to have better XML support in SQL Server?

5
Comments
1 min read
SQL: Timestamps

SQL: Timestamps

41
Comments 4
2 min read
Building Dynamic React Apps with Database Data

Building Dynamic React Apps with Database Data

23
Comments
9 min read
Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

11
Comments 2
12 min read
Why is My SQL Server Query So Slow

Why is My SQL Server Query So Slow

13
Comments 1
6 min read
What are SQL Indexes and how to create one? (For Beginners)

What are SQL Indexes and how to create one? (For Beginners)

15
Comments 4
1 min read
The SQL Savant: Inner Joins in SQL

The SQL Savant: Inner Joins in SQL

32
Comments 4
5 min read
Database normalization may be harmful to efficiency on large scale analytics projects.

Database normalization may be harmful to efficiency on large scale analytics projects.

12
Comments 2
2 min read
SQL and the Soup Kitchen

SQL and the Soup Kitchen

6
Comments 1
1 min read
Creating a C# Repository in .NET Core using RepoDb

Creating a C# Repository in .NET Core using RepoDb

14
Comments 7
5 min read
Simple Queue in PostgreSQL

Simple Queue in PostgreSQL

14
Comments 2
2 min read
An Example to Demonstrate The Vulnerability of SQL Injection and Its Prevention in Oracle

An Example to Demonstrate The Vulnerability of SQL Injection and Its Prevention in Oracle

8
Comments
3 min read
Using Single and Multiline Comments

Using Single and Multiline Comments

8
Comments 2
1 min read
loading...