# newest submissions : Database r/database, mirrored by the RSS Amplifier directory. Page: Feed: --- ## [Looking for MySQL GUI Software](https://www.reddit.com/r/Database/comments/1w19yl1/looking_for_mysql_gui_software/) _2026-08-29 · /u/marviano\__ That can: - Copy to Database to Different Host/Database - Copy "Create table" Query Currently im using SQLyog, 13.1.1 looking for free MySQL GUI software that have similar feature, because im planning to upgrade my current MySQL to version 9, which is not supported with my current SQLyog version submitted by /u/marviano\_ \[link\] \[comments\] ## [Is my facet based Database for media metadata structured correctly?](https://www.reddit.com/r/Database/comments/1w19bp3/is_my_facet_based_database_for_media_metadata/) _2026-08-29 · /u/Bnafek_ submitted by /u/Bnafek \[link\] \[comments\] ## [DBMS CMU](https://www.reddit.com/r/Database/comments/1w0zh9g/dbms_cmu/) _2026-08-28 · /u/Sensitive-Towel-9883_ Anyone interested in doing the CMU (Carnegie Mellon University) Database Management Systems course together? I’ve already covered the basic DBMS concepts. My main goal with this course is to go deeper and understand how database systems actually work internally—things like storage, indexing, query execution, transactions, etc. If you're interested, please make sure you have the prerequisites… ## [4 silent data leaks you will accidentally build when moving your SaaS to Postgres Row-Level Security (RLS)](https://www.reddit.com/r/Database/comments/1vz64d5/4_silent_data_leaks_you_will_accidentally_build/) _2026-08-26 · /u/techsence_ submitted by /u/techsence \[link\] \[comments\] ## [OKVS vs. World](https://www.reddit.com/r/Database/comments/1vz5i6o/okvs_vs_world/) _2026-08-26 · /u/Reasonable\_Wait6676_ submitted by /u/Reasonable\_Wait6676 \[link\] \[comments\] ## [Built a Database Backup Wizard (Windows desktop app), supports MySQL, PostgreSQL, MongoDB, SQL Server, Oracle, SQLite](https://www.reddit.com/r/Database/comments/1vz4l5k/built_a_database_backup_wizard_windows_desktop/) _2026-08-26 · /u/mrak\_47_ Freelance project, sharing because it turned out pretty solid. What it does: Supports 7 DB engines (SQL Server, MySQL, PostgreSQL, MongoDB, MariaDB, Oracle, SQLite, ODBC) Data preview before backup shows table-wise records before you commit Local or cloud destinations (FTP, SFTP, S3, OneDrive, Google Drive, Mega) Native full backup (.bson/.sql) or JSON export as your choice Scheduling, retention… ## [I was thinking to improve MySQL as it had a lot of room for improvements. I need you guys to comment and share all your thoughts too.](https://www.reddit.com/r/Database/comments/1vz4hey/i_was_thinking_to_improve_mysql_as_it_had_a_lot/) _2026-08-26 · /u/Resistorsoup2984_ I've been working on something I think is interesting, that hasn't been done before in the Node.js/TypeScript ecosystem, and I wanted to share the idea and get your thoughts. The Idea: BeatSQL - A Zero-Trust Embedded Database Engine The concept of BeatSQL (BSQL) is simple, but radical: what if your database encrypted data at the column level by default, and took security to a mathematical level?… ## [How do you decide when a database query needs optimization vs. a schema change?](https://www.reddit.com/r/Database/comments/1vyvf8x/how_do_you_decide_when_a_database_query_needs/) _2026-08-26 · /u/shdw\_0x0_ I've been working with SQL and database performance, and one thing I find interesting is knowing when to stop tuning the query itself. For example, if a query is slow because of a missing index, that's fairly straightforward. But at larger data volumes, you can reach a point where adding indexes and rewriting the query only gets you so far. How do you usually decide that the problem is actually… ## [How are you structuring databases for nonprofits without creating duplicate records?](https://www.reddit.com/r/Database/comments/1vy4g6l/how_are_you_structuring_databases_for_nonprofits/) _2026-08-25 · /u/IntrepidAnalyst254_ I'm helping a nonprofit clean up years of spreadsheets, and the biggest challenge has been keeping one record for each client while tracking multiple programs, referrals, and services over several years. Every solution looks good until you start thinking about reporting and long-term maintenance. Curious how others have modeled this. Are you building everything from scratch, customizing a CRM, or… ## [Build with the cheapest GPUs (Sponsored)](https://crawlproof.com/a/piAgLnGNNdHD) _2026-08-25 · **Sponsored**_ Deployed a live API in minutes; one user spent under $10. ## [Book recommendations for big refactorings?](https://www.reddit.com/r/Database/comments/1vxxqwm/book_recommendations_for_big_refactorings/) _2026-08-25 · /u/Lopsided\_Pride\_6165_ At work I am working on a legacy CRM. The issue is that the database is a mess. There are no foreign keys to form relationships etc. I was wondering if there are books that are specificly for refactoring databases? The only one I found so far is actually called "Refactoring Databases". But I want to ask real people (not just gpt) what books are good to solve this problem? Do you have book…