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.
MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)
mfaysaldev profile

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

#mysql #sql #database #beginners
Comments
9 min read
Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases
tejaswipandava profile

Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases

#architecture #database #sql
Comments
2 min read
Model Complaints as Batch Events, Not Support Tickets: Lot Links, Severity Triage and Hold Triggers in a Food ERP
yit2022 profile

Model Complaints as Batch Events, Not Support Tickets: Lot Links, Severity Triage and Hold Triggers in a Food ERP

#erp #database #architecture #saas
Comments
5 min read
Designing an Audit Trail for Attendance Edits Without Overwriting Source Events
insacheck profile

Designing an Audit Trail for Attendance Edits Without Overwriting Source Events

#webdev #database #architecture #backend
Comments
4 min read
Bringing Snowflake App Runtime Into Your Data Lineage Graph: A Horizon Context Experiment
takimiko_gohan profile

Bringing Snowflake App Runtime Into Your Data Lineage Graph: A Horizon Context Experiment

#database #nextjs #snowflake #ai
Comments
7 min read
Ephemeral credentials for databases: moving past the shared application account
onaeiuspkz profile

Ephemeral credentials for databases: moving past the shared application account

#identity #database #zerotrust
Comments
2 min read
You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.
uptimearchitect profile

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

#oracle #database #performance #sql
Comments
9 min read
6 Common GBase Database(GBase 8s) oninit Startup Failures and How to Troubleshoot Them
mmllllzcn profile

6 Common GBase Database(GBase 8s) oninit Startup Failures and How to Troubleshoot Them

#gbase #database #数据库 #programming
2
Comments
3 min read
GBase Database(GBase 8s) Character Set Migration: From en_US.8859-1 to zh_CN.utf8
mmllllzcn profile

GBase Database(GBase 8s) Character Set Migration: From en_US.8859-1 to zh_CN.utf8

#gbase #database #数据库 #beginners
2
Comments
3 min read
5 Common Reasons Why GBase Database(GBase 8s) Cannot Connect After Installation
mmllllzcn profile

5 Common Reasons Why GBase Database(GBase 8s) Cannot Connect After Installation

#gbase #database #数据库 #programming
2
Comments
4 min read
Meet Inibase: a file-based TypeScript database with column storage
kamatil profile

Meet Inibase: a file-based TypeScript database with column storage

#typescript #node #database #opensource
Comments
3 min read
Handling Balances and Transactions: Patterns and Anti-Patterns
devaaai profile

Handling Balances and Transactions: Patterns and Anti-Patterns

#architecture #backend #database #softwareengineering
Comments
6 min read
Proposed Shared Hosting for Node.js: Co-locating App, Database, and Files with Idle App Suspension for Resource Efficiency
pavkode profile

Proposed Shared Hosting for Node.js: Co-locating App, Database, and Files with Idle App Suspension for Resource Efficiency

#node #hosting #resourceefficiency #database
1
Comments
15 min read
How to Set Up SQL Server Management Studio (SSMS) on a Windows PC
rtstrom_98 profile

How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

#sql #database #mysql #devchallenge
Comments
4 min read
PostgreSQL Performance Playbook: Tuning, Indexing, and Advanced Queries
ukasha_mahir_84eeb71db239 profile

PostgreSQL Performance Playbook: Tuning, Indexing, and Advanced Queries

#postgres #database #performance #tuning
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.