DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Improved Connection Pooling & Thread safety in ODBC Drivers

Improved Connection Pooling & Thread safety in ODBC Drivers

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
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

5
Comments 1
3 min read
What you should know about DB types, DB design, and successful software projects

What you should know about DB types, DB design, and successful software projects

47
Comments
2 min read
Switching to the NOWeb sphere projects

Switching to the NOWeb sphere projects

5
Comments
3 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
ESCAPE/19 - An Unbiased Multi-Cloud Conf in NYC

ESCAPE/19 - An Unbiased Multi-Cloud Conf in NYC

6
Comments
4 min read
Working with Legacy, a tale of a slow query.

Working with Legacy, a tale of a slow query.

10
Comments 2
4 min read
"UI"​ AND "UX"​ OR "Visual Design"​ AND "Product Design"​ onsite:opportunity

"UI"​ AND "UX"​ OR "Visual Design"​ AND "Product Design"​ onsite:opportunity

3
Comments
2 min read
How to setup automatic db backup in Laravel

How to setup automatic db backup in Laravel

16
Comments
2 min read
When SQL & Serverless aren't the right choices

When SQL & Serverless aren't the right choices

38
Comments
3 min read
Vocabulary guide of relational database terms

Vocabulary guide of relational database terms

6
Comments
4 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
The Problem With Machine Learning In Healthcare

The Problem With Machine Learning In Healthcare

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

Query to get Primary Key & Foreign Key columns

4
Comments
1 min read
The Java Database Way: Reduce TCO

The Java Database Way: Reduce TCO

4
Comments
2 min read
Setting up MYSQL on UBUNTU EC2 and hassle free connectivity from MYSQL Workbench

Setting up MYSQL on UBUNTU EC2 and hassle free connectivity from MYSQL Workbench

3
Comments
3 min read
How to integrate Firebase in Ionic 4 apps

How to integrate Firebase in Ionic 4 apps

8
Comments
12 min read
Installing psql(11.5) with hombrew, setting up PgAdmin and Postgres.app

Installing psql(11.5) with hombrew, setting up PgAdmin and Postgres.app

7
Comments
4 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
Recalculating Salesforce Formula Fields in Apex

Recalculating Salesforce Formula Fields in Apex

12
Comments 1
2 min read
What are the best apps/resources to keep your dev and designer tools updated?

What are the best apps/resources to keep your dev and designer tools updated?

3
Comments 1
1 min read
Recalcul des champs de formule Salesforce en Apex

Recalcul des champs de formule Salesforce en Apex

5
Comments
2 min read
Version Your Database / Future Directions

Version Your Database / Future Directions

4
Comments
2 min read
In-Memory Performance for Big Data

In-Memory Performance for Big Data

3
Comments
1 min read
SirixDB: Importance of Efficiently Retaining the History of Your Data

SirixDB: Importance of Efficiently Retaining the History of Your Data

6
Comments
5 min read
Looking for Open Source contributors (and users :-))

Looking for Open Source contributors (and users :-))

11
Comments
3 min read
SirixDB - Architecture of an Evolutionary, Temporal Database System

SirixDB - Architecture of an Evolutionary, Temporal Database System

5
Comments
7 min read
MySQL 8.0: New features

MySQL 8.0: New features

6
Comments
1 min read
Quickly edit database from an iPhone

Quickly edit database from an iPhone

9
Comments
2 min read
JOIN Semiotics and MassiveJS v6

JOIN Semiotics and MassiveJS v6

12
Comments
7 min read
Meet an Updated EntityDAC with Support for macOS 64-bit

Meet an Updated EntityDAC with Support for macOS 64-bit

6
Comments
1 min read
dbForge Studio First Supported MySQL CHECK Constraints

dbForge Studio First Supported MySQL CHECK Constraints

5
Comments
2 min read
Delphi Data Access Components are Now Compatible with macOS 64-bit

Delphi Data Access Components are Now Compatible with macOS 64-bit

2
Comments
1 min read
Understanding and Optimizing Throughput in Azure Cosmos DB

Understanding and Optimizing Throughput in Azure Cosmos DB

7
Comments 2
8 min read
Reading a Postgres EXPLAIN ANALYZE Query Plan

Reading a Postgres EXPLAIN ANALYZE Query Plan

8
Comments
5 min read
HBase upgrade on top of Event Sourcing and CQRS architecture in 3 weeks

HBase upgrade on top of Event Sourcing and CQRS architecture in 3 weeks

8
Comments
7 min read
At what point do you know you have a bad application architecture?

At what point do you know you have a bad application architecture?

5
Comments
1 min read
Building a low latency, globally distributed Python app using Macrometa's geo-distributed database cloud

Building a low latency, globally distributed Python app using Macrometa's geo-distributed database cloud

18
Comments
2 min read
Public GraphQL queries with Hasura

Public GraphQL queries with Hasura

20
Comments
3 min read
Simplified Surrogate Keys in Oracle 12c and later

Simplified Surrogate Keys in Oracle 12c and later

6
Comments
5 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
Need a cmd + Z in your database? Transactions to the rescue!

Need a cmd + Z in your database? Transactions to the rescue!

8
Comments 1
1 min read
Which Mobile Backend?

Which Mobile Backend?

5
Comments 6
1 min read
Your first DB index, by example

Your first DB index, by example

6
Comments
3 min read
How to fix Rails ActiveRecord::ConcurrentMigrationError

How to fix Rails ActiveRecord::ConcurrentMigrationError

5
Comments 2
1 min read
Database Migrations with Nodejs

Database Migrations with Nodejs

33
Comments 1
14 min read
PyMongo Tutorial: Testing MongoDB Failover in Your Python App

PyMongo Tutorial: Testing MongoDB Failover in Your Python App

5
Comments
11 min read
Devart .NET Connectivity Solutions Now Support Visual Studio 2019

Devart .NET Connectivity Solutions Now Support Visual Studio 2019

4
Comments
1 min read
Choose Great Keys

Choose Great Keys

6
Comments
3 min read
Creating a Date Dimension Table in PostgreSQL

Creating a Date Dimension Table in PostgreSQL

7
Comments
1 min read
Attaching actions to rollbacks in Spring

Attaching actions to rollbacks in Spring

6
Comments
2 min read
DBMS For Application Development: SQL (Structured Query Language)

DBMS For Application Development: SQL (Structured Query Language)

7
Comments
4 min read
Version control, not just for code anymore!

Version control, not just for code anymore!

6
Comments
5 min read
Transactional Data Operations in PostgreSQL Using Common Table Expressions

Transactional Data Operations in PostgreSQL Using Common Table Expressions

7
Comments
7 min read
Speeding up Postgres Restores

Speeding up Postgres Restores

14
Comments
5 min read
I Cover PostgreSQL Dev Setup and Installation in My Series "Bunches of Databases in Bunches of Weeks"

I Cover PostgreSQL Dev Setup and Installation in My Series "Bunches of Databases in Bunches of Weeks"

6
Comments
5 min read
Why I Dislike Paste Special Values In Excel

Why I Dislike Paste Special Values In Excel

3
Comments
9 min read
loading...