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.
OpenAI SQL Query generator with GPT-3 and Nextjs

OpenAI SQL Query generator with GPT-3 and Nextjs

14
Comments 1
6 min read
Part Six: Functions

Part Six: Functions

4
Comments
12 min read
How to add a condition in SQL with GROUP BY

How to add a condition in SQL with GROUP BY

8
Comments
1 min read
Advent of Code - Day 2

Advent of Code - Day 2

6
Comments
4 min read
Advent of Code - Day 1

Advent of Code - Day 1

11
Comments 3
4 min read
Include API Key In HTTP Requests

Include API Key In HTTP Requests

10
Comments 4
3 min read
SQL Join explained!

SQL Join explained!

7
Comments 1
2 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

2
Comments
15 min read
What is SQL Injection and How to prevent it?

What is SQL Injection and How to prevent it?

11
Comments 1
10 min read
5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

3
Comments
5 min read
Online PHP & SQL sandbox with ChatGPT support

Online PHP & SQL sandbox with ChatGPT support

65
Comments 6
2 min read
How to configure WordPress in Nextjs using REST API

How to configure WordPress in Nextjs using REST API

1
Comments
4 min read
sql-export - create .md / .json files from database content

sql-export - create .md / .json files from database content

2
Comments
2 min read
Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

37
Comments
2 min read
ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

8
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.