IntroductionContinue reading on Medium »

Simplifying complex table comparisons and streamlining data-to-JSONContinue reading on Medium »

Before we jump in — Some motivationContinue reading on Medium »

Migrating from Microsoft SQL Server (MSSQL) to MySQL is a strategic move many organizations consider to optimize costs, leverage…Continue reading on Medium »

Migrating from MySQL to SQL Server represents one of the most critical database operations that IT professionals face today.Continue reading on DBConvert Blog »

IntroductionContinue reading on Medium »

Learn how to turn partial matches into performance magicContinue reading on Medium »

MongoDB, with its high-performance default storage engine WiredTiger, is a powerful NoSQL database trusted by startups and enterprises…Continue reading on Medium »

submitted by /u/der_gopher [link] [comments]

Hello, I am a software engineer with almost 8 years of experience. During this time, I have mostly worked with MySQL, Postgres and Mongo DB. While these three are the most used ones, I think I am at a disadvantage for not knowing other database technologies. I want to widen my skillset by learning another database technology such as wide column, graph and big data technologies. Some of the Databases that I am thinking of are Cassandra, H-Base, Neo4j, Scylla DB, Arango DB I would love to get some feedback on which database I can take on for my self learning, that will add value to my career as a backend engineer, and has a high demand in the job market. Thank you. submitted by /u/ProbableBarnacle [link] [comments]

In modern enterprise applications, it’s common to interact with multiple databases — especially when dealing with region-specific data…Continue reading on Medium »

submitted by /u/der_gopher [link] [comments]

When working with PostgreSQL, especially on bigger projects or with other people, understanding the structure and relationships in your…Continue reading on DevOps.dev »

submitted by /u/mohamedheiba [link] [comments]

submitted by /u/javinpaul [link] [comments]

Hey folks, I just graduated (computer engineering) with little tech industry experience—mainly ESL teaching and an IoT internship. I live in a challenging region with few tech companies and a language barrier, but I’m determined to break into a data role, ideally as an SQL Server DBA. I’m certified in Power BI and I love working with databases—designing schemas, optimizing performance, and writing complex queries. Since I don’t have a job yet, I decided to “pretend” I’m already a DBA and let ChatGPT guide me like a senior mentor. I asked it to design a scenario-based course that takes someone from junior to “elite” SQL Server DBA. The result was a 6-phase curriculum covering: Health checks, automation & PowerShell scripting Performance tuning using XEvents, Query Store, indexing, etc. High availability & disaster recovery (Always On, log shipping) Security & compliance (TDE, data masking, auditing) Cloud migrations & hybrid architectures (Azure SQL, ASR) Leadership, mentoring, and community engagement Each phase has real-world scenarios (e.g., slow checkout performance, ransomware recovery, DR failovers) and hands-on labs. There's even a final capstone project simulating a 30TB enterprise mess to fix. I've just completed Phase 1, Scenario 1—built a containerized SQL Server instance in Docker, used PowerShell and dbatools to run health checks, restore backups, and establish baselines. It’s tough and pushes me beyond my comfort zone, but I’ve learned more in a few weeks than I did in school. My Questions: If I complete Phases 1 to 3 and document them properly, do you think it’s enough to put on my resume or GitHub to land an entry-level DBA role? Is this kind of self-driven, mentored-by-AI project something that would impress a hiring manager? Any suggestions on showcasing this journey? (blogs, portfolio site, LinkedIn, etc.) Would love feedback from seasoned DBAs or folks who broke into the field unconventionally. Thanks! submitted by /u/nsark [link] [comments]

submitted by /u/Disastrous_Past_4794 [link] [comments]

Long story short I did some digging Citus is not supported and they had multi node feature that they killed. Obviously we can do either master replica reads for a while until you need more write power then you go down sharding route. Any plan for something streamlined? I saw they have blog post on how to scale timescaledb https://www.tigerdata.com/learn/guide-to-postgresql-scaling They seem to go down the continuous aggregation route aka optimization rather than scale in my eyes at least. So anyone had similar issue? What’s your solution guys? submitted by /u/squadfi [link] [comments]

At work, we have a server with three databases: dev, test, and prod. We all make changes to the dev db together and when we are happy with the result, we run it in the test db. If that passes, we paste the SQL into a git repo. Our team lead manually updates prod based on updates to the git repo. This feels wrong to me. I inquired about having a copy of SQL Server Developer on our local computers but IT gave a generic "it's a security risk" and said no. Is our existing process fine? Should we be doing something else? I'd like to emphasize that I've already spent a full week on related google searches and gotten very little useful insight. submitted by /u/lolcrunchy [link] [comments]

submitted by /u/akhilgod [link] [comments]

MariaDB 11.8 became generally available in early June and it is the new LTS version production users should move to. What are the experiences of people so far here, is the 11.8.2 stable and safe to migrate to? Or are there any reason to postpone upgrades from older MariaDB 11.4.x to this version? Should people migrating from MySQL 5.7 / 8.0 go to MariaDB 11.4 or is this new 11.8 ready for production use in environments that need to be very stable? submitted by /u/OttoKekalainen [link] [comments]

submitted by /u/saipeerdb [link] [comments]

submitted by /u/philippemnoel [link] [comments]

Hello, I just started an internship and they will assign as tasks within a week. They told us to study oracle database. We already know sql and worked with postgres and microsoft sql server. I want to study the full syntax of oracle + get used to the software and architecture of the database. Does anyone know any short courses / youtube playlists we can try that are good? I want something intermediate that delves into the specific oracle syntax, not just general sql? submitted by /u/doinkxx [link] [comments]

submitted by /u/NoInteraction8306 [link] [comments]

submitted by /u/raghasundar1990 [link] [comments]

Hi Guys, I am currently using CSV files to manage data. But that is not at all efficient, my current config is as follows There is a data folder in which I have raw data files, and then a folder called analysis data with the processed CSVs, I need a database that achieves the following: Easy Python integration Resource-efficient Supports nested structure / semi-structured data Scales decently (~10K files worth of data) Portable submitted by /u/Vegetable_Play_9821 [link] [comments]

Hey , some context : I'm currently part of a team working on a educational plateform now i'm no webdev and never launched a proper app online , my work is actually on the document side of things , we have hundreds of math docs on markdown to serve for students depending on level,difficulty,chapter,etc,... now my choice was markdown and xaml since it's easy to work with and to parse in webpage. so far all the prototypes i've worked are of course offline so i just access the folder location on my disk but i'm assuming we won't be doing that for 1k+ students everytime they navigate to a different exercice. SO where should i look to be able to tackle : 1- categorizing documents to be able to serve intelligent and personalized content to students based on algorithms 2- do i store names+locations somewhere and the actual files somewhere else ? what services are lightest for the tast ? 3- am i missing something and being very silly ? help set me on the right path please 🙂 4- Thanks in advance <3 submitted by /u/Necessary_Tradition5 [link] [comments]

HI guys, basically i have a database exam pretty soon and i'm still here trying to grasp the conceptual design to draw an ER Schema. My university provided me with slides and like 3 exercises, but i have no solution to them (the professor probably reviewed them in class, but i coudn't attend the classes due to some personal problems). I tried using chatgbt and image making to check if my drawn version was right but i think all the ER diagrams that it produced were kinda not right, or some attributes were missing or were actually empty etc.. Is there any software or AI that can actually help me to see if i did my exercises right? This is an example of one of my exercises on the slides: Also, if you guys could give me some tips on how you would personally tackle it, i would gladly appreciate it! https://preview.redd.it/76tviijcjvaf1.png?width=889&format=png&auto=webp&s=055022c223d8ef423b2f28b2ed2bb2743671aaf0 submitted by /u/ShokoTendoo [link] [comments]

I remembered a very ridiculous thing. I Had a behavioral interview last week, and out of nowhere, the interviewer goes: “How would you explain normalization with a sense of humor?” I panicked. My brain was like: uh… make third normal form… funny? All I could think of was:“Normalization is like decluttering your kitchen..If you have three identical spatulas in three drawers, maybe make a single ‘spatula drawer’ and reference it from there.” They chuckled. I’m not sure if that’s because it was actually funny or just tragically nerdy. Afterwards I plugged the question into Beyz interview helper and got some surprisingly helpful variations. It generated one where normalization was compared to organizing your closet (“Don’t repeat outfits in three places, just tag them!”). Another version compared it to splitting your Spotify playlists so you don’t have the same song on 7 different lists. Honestly… not bad for an AI wingwoman. Anyone else ever get thrown a “make databases fun” kind of question? Would love to hear your best DB jokes or metaphors lol I’m collecting them now, just in case.. submitted by /u/Various_Candidate325 [link] [comments]

I am looking for a database programmer to make modifications to an existing database. The database is running on a Linux machine. submitted by /u/Errr797 [link] [comments]

submitted by /u/BoysenberryLocal5576 [link] [comments]

I'm curious here, about people who have a production data ingestion pipeline, and in particular for IoT sensor applications, what it is, and whether you're happy with it or what you would change My use case is having 100k's of devices in the field, sending one data point each 10 minutes The current pipeline I imagine would be MQTT(Emqx) -> Redpanda -> Flink (for analysis) -> TimescaleDB submitted by /u/oulipo [link] [comments]

Hey r/Database, I'm reaching out to this community because it's one of the few places with a high concentration of people who will immediately understand the problem we're trying to solve. I promise this isn't a sales pitch; we're bootstrapped, pre-revenue and are genuinely looking for expert guidance. The Origin Story (The "Why"): My co-founder was a DBA and architect for military contractors for over 15 years. He ran into a situation where a critical piece of data was changed in a production SQL Server database, and by the time anyone noticed, the logs had rolled, and the nightly backups were useless. There was no way to definitively prove who changed what, when, or what the original value was. It was a nightmare of forensics and finger-pointing. He figured there had to be a better way than relying on complex log parsing or enterprise DAMs that cost a fortune and take months to deploy. What We Built: So, he built this tool which at its core, it does one thing very well: it captures every single row-level change (UPDATE, INSERT, DELETE) in a SQL Server database and writes it to an immutable, off-host log in real-time. Think of it as a perfect, unbreakable data lineage for every transaction. It's designed to answer questions like: "Who changed the price on this product row at 9 PM on Sunday?" "What was the exact state of this customer record before the production bug corrupted it?" "Our senior DBA just left; what kind of critical changes was she making that we need to know about?" It's zero-code to set up and has a simple UI (we call it the Lighthouse) so that you can give your compliance folks or even devs a way to get answers without having to give them direct DB access. The Ask: We Need Your Brutal Honesty We are looking for a small group of experienced DBAs to become our first design partners. We need your unfiltered feedback to help us shape the roadmap. Tell us what's genius, what's garbage, what's missing, and how it would (or wouldn't) fit into your real-world workflow. What's in it for you? Free, unlimited access to the platform throughout the design partner program. A significant, permanent discount if you decide you want to use the product afterward. No obligation at all. You'll have a real impact on the direction of a tool built specifically for the problems you face. An opportunity to get early hands-on experience with a new approach to data auditing. If you've ever had to spend a weekend digging through transaction logs to solve a mystery and wished you had a simpler way, I'd love to chat. How to get in touch: Please comment below or shoot me a DM if you're interested in learning more. I'm happy to answer any and all questions right here in the thread. Thanks for your time and expertise. (P.S. - Right now we are focused exclusively on SQL Server, but support for Postgres and others is on the roadmap based on feedback like yours.) submitted by /u/tohar-papa [link] [comments]

Hi guys, as the title suggests, is Supabase good for production? And if yes, what kind of plan should I buy? We are currently a team of developers and buying a plan for each member seems costly. Should I opt for a different approach? What should I do in this situation guys? submitted by /u/BoysenberryLocal5576 [link] [comments]