· software
Don't pull the entire dump if you only need a small piece
The problem: huge backups for a tiny test In a recent project I needed to generate complex PDF reports from a distributed data system. The reports relied on th...
-
- · software
Oracle 19.28 - New features
New Features in Oracle 19.28 - DBMS_DEVELOPER PL/SQL Packages – New PL/SQL package to retrieve object metadata as JSON instead of XML, improving integration an...
- · software
Turning Database Schemas into Diagrams & Docs — Open for Early Feedback
Databases are one of those things that every dev touches but very few are comfortable explaining — especially when you inherit a project or join a new team. Bet...
- · software
How to Generate Test Data for PostgreSQL (2 Methods)
!Cover image for How to Generate Test Data for PostgreSQL 2 Methodshttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/...
- · software
We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly
What is Vizora? Vizora is a database intelligence tool for developers. Instead of connecting to your database or asking for credentials, you simply: - Paste yo...
- · software
SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭
What is the WHERE Clause? The WHERE clause is basically SQL's filter button. You don't want all rows – you want specific rows. sql SELECT FROM students; All ro...
- · software
Automating our changelog with Cursor commands
Ever since Cursor commands were released, we've been usingthem to find ways to shortcut common tasks at PlanetScale. A Cursor command allows you to add slash /a...
- · software
Testing Database Logic: What to Test, What to Skip, and Why It Matters
Testing Database Logic and Migrations in Laravel Database logic is one of the hardest parts of an application to test properly. Not because it is exotic or com...
- · software
I just finished my database assignment even though the deadline was yesterday at 11:59pm 😅 Moments like this remind me that I’m actually living the dream I once talked about: becoming a software engineer. Learning backend engineering with Node.js has
Moments like this remind me that I’m actually living the dream I once talked about: becoming a software engineer. Learning backend engineering with Node.js has...
- · software
The basics of managing the database schema changes
Building an application requires data storage and, consequently, database schemas When you update a released application, you must often modify these schemas....
- · software
👉“I Didn’t Understand JPA Until I Built the Persistence Layer”
!Cover image for 👉“I Didn’t Understand JPA Until I Built the Persistence Layer”https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto...
- · software
SQLNet A social network that looks like Twitter but you write SQL to do anything
Article URL: https://sqlnet.cc Comments URL: https://news.ycombinator.com/item?id=46483657 Points: 23 Comments: 2...