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.
View and Read SQL Server Transaction Log Data

View and Read SQL Server Transaction Log Data

5
Comments 1
1 min read
Learning about how to connect a Database

Learning about how to connect a Database

7
Comments 2
1 min read
Creating a Postgres database + user

Creating a Postgres database + user

5
Comments
1 min read
Starting my journey!

Starting my journey!

5
Comments 2
1 min read
Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

2
Comments
2 min read
#SQL30 Day 16: Dev Badges

#SQL30 Day 16: Dev Badges

7
Comments
4 min read
#SQL30 Day 15: Fuzzy Matching

#SQL30 Day 15: Fuzzy Matching

10
Comments
3 min read
#SQL30 Day 14: UFO Sightings

#SQL30 Day 14: UFO Sightings

6
Comments
2 min read
#SQL30 Day 13: Permutations

#SQL30 Day 13: Permutations

8
Comments
2 min read
That's how I came back in time

That's how I came back in time

2
Comments
2 min read
#SQL30 Day 7: Grouping Sets

#SQL30 Day 7: Grouping Sets

6
Comments 1
3 min read
#SQL30 Day 9: Longest Span

#SQL30 Day 9: Longest Span

9
Comments
3 min read
#SQL30 Day 4: Video Game Sales

#SQL30 Day 4: Video Game Sales

7
Comments 1
3 min read
SQL In The Real World: Setting Expectations For Your First Job

SQL In The Real World: Setting Expectations For Your First Job

14
Comments
4 min read
My SQL5.5: Reasons for being World’s Most Popular Opensource Database

My SQL5.5: Reasons for being World’s Most Popular Opensource Database

4
Comments
2 min read
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

5
Comments
2 min read
Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

3
Comments
2 min read
JOINs on JOINs on JOINs

JOINs on JOINs on JOINs

14
Comments
3 min read
When SQL & Serverless aren't the right choices

When SQL & Serverless aren't the right choices

38
Comments
3 min read
How to Install MySQL on Mac

How to Install MySQL on Mac

6
Comments
2 min read
dbForge Transaction Log – A New Tool Made by Devart

dbForge Transaction Log – A New Tool Made by Devart

3
Comments
2 min read
How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

8
Comments 8
1 min read
Query to get Primary Key & Foreign Key columns

Query to get Primary Key & Foreign Key columns

4
Comments
1 min read
MySQL- Indexing Basics

MySQL- Indexing Basics

7
Comments
1 min read
Todo List App Using Flask and SQL-Alchemy

Todo List App Using Flask and SQL-Alchemy

7
Comments
1 min read
Database Views and How to Use Them in a Rails Based Application?

Database Views and How to Use Them in a Rails Based Application?

5
Comments
8 min read
Conhecendo o Azure Data Studio

Conhecendo o Azure Data Studio

2
Comments
2 min read
Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

10
Comments
4 min read
Sumar y restar cantidades con SQL en WordPress

Sumar y restar cantidades con SQL en WordPress

7
Comments
3 min read
How to Get the First or Last Value in a Group Using Group By in SQL

How to Get the First or Last Value in a Group Using Group By in SQL

5
Comments
11 min read
Analyzing Meetup Data With SQL And Tableau - A Free Webinar

Analyzing Meetup Data With SQL And Tableau - A Free Webinar

9
Comments
1 min read
JOIN Semiotics and MassiveJS v6

JOIN Semiotics and MassiveJS v6

12
Comments
7 min read
Native Android Database

Native Android Database

4
Comments
1 min read
Using Python to Scrape the Meet-Up API

Using Python to Scrape the Meet-Up API

58
Comments
5 min read
Improving Community Support for Liquibase

Improving Community Support for Liquibase

12
Comments
1 min read
Tips for Writing an ETL Console Application in C# .NET Core

Tips for Writing an ETL Console Application in C# .NET Core

8
Comments
5 min read
SQL joins recall - a little bit too late

SQL joins recall - a little bit too late

14
Comments
3 min read
Intermittent RDS Errors When Triggering Lambda Functions

Intermittent RDS Errors When Triggering Lambda Functions

6
Comments
3 min read
Database management and use among multiple developers?

Database management and use among multiple developers?

4
Comments 1
1 min read
Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds

Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds

14
Comments
5 min read
SQL is neither dead nor a dinosaur. You should use it for your web app.

SQL is neither dead nor a dinosaur. You should use it for your web app.

15
Comments 1
8 min read
Practicality Beats Purity - Pure SQL vs ORMs

Practicality Beats Purity - Pure SQL vs ORMs

7
Comments
1 min read
SQL Injection??

SQL Injection??

6
Comments 1
1 min read
Vacuum after you tidy up

Vacuum after you tidy up

18
Comments
4 min read
Three tables every analyst needs

Three tables every analyst needs

7
Comments
6 min read
Embrace the Base

Embrace the Base

6
Comments
1 min read
Creating My First Sinatra App

Creating My First Sinatra App

9
Comments
4 min read
AMA with Julia Silge, Stack Overflow's Data Scientist

AMA with Julia Silge, Stack Overflow's Data Scientist

5
Comments
1 min read
Simplified Surrogate Keys in Oracle 12c and later

Simplified Surrogate Keys in Oracle 12c and later

6
Comments
5 min read
Boxball: Prebuilt baseball stats databases using Docker

Boxball: Prebuilt baseball stats databases using Docker

7
Comments
4 min read
Setting up your Heroku site with JawsDB using Sequel Pro

Setting up your Heroku site with JawsDB using Sequel Pro

6
Comments
3 min read
The terrifying mongoDB sintaxe

The terrifying mongoDB sintaxe

5
Comments 2
1 min read
The Magic Of A Single Integer Number To Contain Huge Information

The Magic Of A Single Integer Number To Contain Huge Information

8
Comments
1 min read
Does Coding in CMS makes you unprofessional?

Does Coding in CMS makes you unprofessional?

8
Comments 2
1 min read
Bug: SQL Stored Procedure Returning -1 in Entity Framework

Bug: SQL Stored Procedure Returning -1 in Entity Framework

5
Comments
2 min read
Managing Data in the Cloud ☁

Managing Data in the Cloud ☁

10
Comments
2 min read
Tracking the Trackers

Tracking the Trackers

5
Comments 2
4 min read
Write a Postgresql proxy. The Beginning.

Write a Postgresql proxy. The Beginning.

5
Comments
2 min read
Superglue for Gaps in Your AWS Infrastructure — automation scripts using SQL and Javascript

Superglue for Gaps in Your AWS Infrastructure — automation scripts using SQL and Javascript

3
Comments
4 min read
How to store ‘last seen’ for users in Phoenix

How to store ‘last seen’ for users in Phoenix

6
Comments
2 min read
loading...