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.
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

9
Comments
3 min read
Using Single and Multiline Comments

Using Single and Multiline Comments

8
Comments 3
1 min read
CockroachDB via Crystal ... In under 50 lines

CockroachDB via Crystal ... In under 50 lines

7
Comments
6 min read
RepoDb - a hybrid ORM library for .NET.

RepoDb - a hybrid ORM library for .NET.

9
Comments 4
2 min read
Elasticsearch Comrade Part #1 - SQL Queries

Elasticsearch Comrade Part #1 - SQL Queries

9
Comments
1 min read
When to use/not use an ORM

When to use/not use an ORM

10
Comments 6
1 min read
jOOQ - a short guide

jOOQ - a short guide

16
Comments
8 min read
Codeigniter custom helper functions which will increase your productivity

Codeigniter custom helper functions which will increase your productivity

23
Comments 2
2 min read
Updating a table from another table

Updating a table from another table

8
Comments 3
1 min read
Understanding SQL Server Isolation Levels through example

Understanding SQL Server Isolation Levels through example

11
Comments
6 min read
For the 1024 time – DateTime has no format!

For the 1024 time – DateTime has no format!

11
Comments 2
2 min read
ORM vs Query Builders vs Raw SQL

ORM vs Query Builders vs Raw SQL

28
Comments 8
2 min read
GraphQL with Postgres views and materialized views

GraphQL with Postgres views and materialized views

6
Comments
5 min read
6 Common Sequelize Queries Explained in SQL

6 Common Sequelize Queries Explained in SQL

6
Comments
4 min read
How I passed 70-761 T-SQL exam

How I passed 70-761 T-SQL exam

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