Overdue Last read · last published · next check
Last read 2 days ago, longer than this feed's 3 hours schedule.
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]
submitted by /u/Bnafek [link] [comments]
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…
submitted by /u/techsence [link] [comments]
submitted by /u/Reasonable_Wait6676 [link] [comments]
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'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?…
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…
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…
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…
