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.
Code in Public - Time Management website
alecbsherman profile

Code in Public - Time Management website

#techtalks #lowcode #php #sql
2
Comments
1 min read
Schemaless SQL database for strong and lasting back end
niolap profile

Schemaless SQL database for strong and lasting back end

#database #sql #mongodb #javascript
10
Comments
2 min read
when you have millions of insert statements in a file...
franckpachot profile

when you have millions of insert statements in a file...

#postgres #yugabytedb #sql #database
28
Comments
6 min read
In the mist of the Big Data Hype, Let’s Discuss MySQL
veerreshr profile

In the mist of the Big Data Hype, Let’s Discuss MySQL

#sql #mysql #tutorial #programming
4
Comments 23
4 min read
SQL Injection Attacks and How Developers Can Prevent Them
lindsfonnes profile

SQL Injection Attacks and How Developers Can Prevent Them

#webdev #security #sql #100daysofhacking
35
Comments 2
7 min read
Sweet Alert JavaScript Library With Oracle Apex
jaseemdev profile

Sweet Alert JavaScript Library With Oracle Apex

#javascript #oracleapex #sql #react
2
Comments
1 min read
How to do a Select clause comparison of LocalDateTime in JPA
ama profile

How to do a Select clause comparison of LocalDateTime in JPA

#java #jpa #sql #codever
5
Comments
1 min read
Infrastructure as SQL
depombo profile

Infrastructure as SQL

#devops #cloud #terraform #sql
35
Comments 4
4 min read
Find Out What It Means to be a Data Scientist at Microsoft
nate_at_stratascratch profile

Find Out What It Means to be a Data Scientist at Microsoft

#datascience #database #dataanalytics #sql
4
Comments
14 min read
Yammer: My personal dive into a practice business problem
ahmedamrawadallahk8 profile

Yammer: My personal dive into a practice business problem

#sql
3
Comments
10 min read
Simple Scalable Search Autocomplete Systems
mdnurahmed profile

Simple Scalable Search Autocomplete Systems

#go #redis #elasticsearch #sql
8
Comments 1
6 min read
Using Recursive Common Table Expressions to fill missing continuous data | Oracle SQL
rolangom profile

Using Recursive Common Table Expressions to fill missing continuous data | Oracle SQL

#sql #plsql #oracle #datascience
5
Comments
2 min read
SQL Query into Pandas DataFrame - Part 3
dendihandian profile

SQL Query into Pandas DataFrame - Part 3

#sql #python #datascience #sqlite
5
Comments
1 min read
sql vs. nosql
promiser profile

sql vs. nosql

#sql #database #dbms
2
Comments
1 min read
Performant script in updating a large table🚀
jimmyyeung profile

Performant script in updating a large table🚀

#django #database #sql #productivity
10
Comments
3 min read
What is SQL and What Its Value?
doramiller303 profile

What is SQL and What Its Value?

#sql #database
2
Comments
2 min read
Databases: Important Theoretical Concepts
fahidlatheef profile

Databases: Important Theoretical Concepts

#sql #postgres #database
16
Comments
4 min read
Another SQL cheat sheet
spo0q profile

Another SQL cheat sheet

#database #sql
30
Comments 1
5 min read
10 Ways to optimise your Database queries
ktnl profile

10 Ways to optimise your Database queries

#sql #postgres #database
24
Comments 2
7 min read
Decentralized Security From a Centralized Database
cassidymountjoy profile

Decentralized Security From a Centralized Database

#sql #database #datascience #blockchain
5
Comments
4 min read
SQL : JSON Datatype
dev117uday profile

SQL : JSON Datatype

#sql #programming #database
6
Comments
4 min read
SQL : Internal Functions
dev117uday profile

SQL : Internal Functions

#sql #programming #database
4
Comments
4 min read
SQL : Arrays
dev117uday profile

SQL : Arrays

#sql #programming #database
3
Comments
5 min read
SQL : Sequences
dev117uday profile

SQL : Sequences

#sql #database #programming
3
Comments
1 min read
SQL : Date/ Time and TimeStamps
dev117uday profile

SQL : Date/ Time and TimeStamps

#sql #programming #database
2
Comments
3 min read
SQL : User Defined Datatypes
dev117uday profile

SQL : User Defined Datatypes

#sql #database #programming
2
Comments
3 min read
SQL : DataTypes
dev117uday profile

SQL : DataTypes

#sql #database #programming
2
Comments
6 min read
MongoDB equivalent of SQL LIKE query
tios profile

MongoDB equivalent of SQL LIKE query

#mongodb #sql #regex
5
Comments
1 min read
SQL Query into Pandas DataFrame - Part 2
dendihandian profile

SQL Query into Pandas DataFrame - Part 2

#sql #python #datascience #sqlite
2
Comments
1 min read
Migration from Mssqlserver to Mongodb for Developers
ekhosravie profile

Migration from Mssqlserver to Mongodb for Developers

#sql #mongodb #database
2
Comments
12 min read
Announcing Hightouch Audiences: Enabling Marketers to Self-Serve their Data
zackkhan profile

Announcing Hightouch Audiences: Enabling Marketers to Self-Serve their Data

#analytics #sql #analyst #datascience
1
Comments
5 min read
Deleting duplicate value at the same column in table of sql
hte305 profile

Deleting duplicate value at the same column in table of sql

#sql
6
Comments 1
1 min read
App Desktop com React + Electron + Sqlite | MS TO-DO clone
tuliocalil profile

App Desktop com React + Electron + Sqlite | MS TO-DO clone

#react #typescript #sql #microsoft
5
Comments 2
7 min read
Create, Insert, Retrieve Data in SQL
jaamaalxyz profile

Create, Insert, Retrieve Data in SQL

#beginners #learning #sql #database
3
Comments
2 min read
SQL Injection 101
yongdev profile

SQL Injection 101

#sql #security #php #server
14
Comments 3
5 min read
MongoDb Vs Sql
naitik_pitroda profile

MongoDb Vs Sql

#mongodb #sql #database
2
Comments
2 min read
UUID or cached sequences?
franckpachot profile

UUID or cached sequences?

#database #postgres #sql #yugabytedb
16
Comments
7 min read
mysql 101
drsimplegraffiti profile

mysql 101

#mysql #sql #database #beginners
5
Comments
5 min read
Redshift es compatible con vistas materializadas!
julietaansola profile

Redshift es compatible con vistas materializadas!

#aws #sql
2
Comments
2 min read
CockroachDB Grants and Schemas explained
sheaffej profile

CockroachDB Grants and Schemas explained

#cockroachdb #security #postgres #sql
6
Comments
10 min read
I'm building a modern spreadsheet
stephensisk profile

I'm building a modern spreadsheet

#showdev #sql #tooling #spreadsheet
7
Comments 1
9 min read
SQL Performance - pagination scalability
rafhofman profile

SQL Performance - pagination scalability

#sql #performance #pagination
3
Comments
1 min read
Basic SQL Concepts
fahidlatheef profile

Basic SQL Concepts

#sql #postgres #database
5
Comments
3 min read
Index Only Scan on Functional Indexes
franckpachot profile

Index Only Scan on Functional Indexes

#postgres #sql #database
20
Comments 2
4 min read
A kind of flashback query in PostgreSQL
franckpachot profile

A kind of flashback query in PostgreSQL

#postgres #database #sql
12
Comments
3 min read
SQL vs NoSQL
jryther profile

SQL vs NoSQL

#database #beginners #sql
4
Comments
2 min read
SQL SERVER REMOTE CONFIGURATIONS ON LINUX
wanjohichristopher profile

SQL SERVER REMOTE CONFIGURATIONS ON LINUX

#database #datawarehouse #etl #sql
5
Comments
2 min read
Wondering How Your Data is Evolving? Time Travel Queries in bSQL Can Help
cassidymountjoy profile

Wondering How Your Data is Evolving? Time Travel Queries in bSQL Can Help

#sql #datascience #database
3
Comments
5 min read
How immutable data can benefit your data-driven application.
cassidymountjoy profile

How immutable data can benefit your data-driven application.

#database #sql #blockchain #security
15
Comments
2 min read
Beware the Performance Dangers of MySQL Views
jamiemcmanus profile

Beware the Performance Dangers of MySQL Views

#mysql #sql #database
19
Comments 1
4 min read
SQL 101: How to Insert and Update Data From Databases Using SQL
fpcorso profile

SQL 101: How to Insert and Update Data From Databases Using SQL

#sql #datascience #database
3
Comments
4 min read
When and how to JOIN a table with itself
chuniversiteit profile

When and how to JOIN a table with itself

#sql
2
Comments
8 min read
How To Use SQL Subqueries
rettx profile

How To Use SQL Subqueries

#guide #beginners #sql
8
Comments
3 min read
usql on YugabyteDB
franckpachot profile

usql on YugabyteDB

#yugabytedb #sql #database
2
Comments
4 min read
ORM's x Query Builder's x Raw SQL
pedrocardoz0 profile

ORM's x Query Builder's x Raw SQL

#discuss #beginners #database #sql
13
Comments
6 min read
SQL Query into Pandas DataFrame - Part 1
dendihandian profile

SQL Query into Pandas DataFrame - Part 1

#sql #python #datascience #sqlite
7
Comments
2 min read
How do you number SELECT query results using SQL?
chuniversiteit profile

How do you number SELECT query results using SQL?

#sql
3
Comments
5 min read
Entenda como nossa base de Diretórios Brasileiros facilita sua vida
crislane profile

Entenda como nossa base de Diretórios Brasileiros facilita sua vida

#database #datascience #sql #braziliandevs
6
Comments
4 min read
How many rows would have been there without that LIMIT clause?
dspsolves profile

How many rows would have been there without that LIMIT clause?

#database #sql #mysql #postgres
12
Comments
6 min read
Tutorial on How to connect to a Linked Server
imkateyoung profile

Tutorial on How to connect to a Linked Server

#sql #database #sqlbase
3
Comments
3 min read
loading...