Why Mongo DB?Continue reading on Medium »

In the previous chapters, we saw two important things:Continue reading on Medium »

When starting a Django project, SQLite3 is a fantastic choice. It requires zero configuration and lives as a simple file right inside your…Continue reading on Medium »

Merhabalar, bu yazımda sizlere mikroservislerle çalışırken sıkça karşılaştığımız CAP teoreminden bahsedeceğim.Continue reading on Medium »

The SQL mistakes I wish I had avoided earlier.Continue reading on Medium »

It’s often common to see these word thrown around amongst developers and technical recruiters, as a beginner you might get confused on…Continue reading on Medium »

The actual queries I run when I’m hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant…Continue reading on Medium »

Migrating Rails multi-tenancy from Apartment to PostgreSQL Row-Level Security before you are too big to do it cleanlyContinue reading on Level Up Coding »

From a single MongoDB replica to 4 trillion messages here’s every engineering decision that actually mattered.Continue reading on Medium »

This is article 1 of 8 in my Oracle Database Skills series.Continue reading on Oracle Developers »

I’m a full-stack developer with a backend focus. I was searching for a playlist to deep dive into databases and improve my understanding of them. Someone recommended this playlist. Has anyone watched it before and can share their feedback? Also, if anyone has a better recommendation, please let me know. https://preview.redd.it/e7apkritqa1h1.png?width=287&format=png&auto=webp&s=987eb637b9b3d5042c7b43e7c9d52f553d78f40c submitted by /u/EqualMatch7754 [link] [comments]

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

Please don't judge me, I'm not applying for a DB job, I just want to get basic design principles. If possible very example driven, why to use one to many in this case, or not to use. I know that every field needs years to master, even what I mentioned, I don't want to master it 🙂 So any course suggestions? [Edit] SQL is not a huge problem, I want to know things like, should everything related to a user be a huge table? Should I put flags about his password in the same table as his address. Or separate tables based in some principles? submitted by /u/Numerous_Economy_482 [link] [comments]

Im trying to wrap my head on how to program to apply payments against invoices. I have a data table for invoices and one for payments so far User selects new payment and is taken to the payment screen User selects customer A list is populated with any invoices with a balance above zero for that customers id User enters amount of payment, and also how much of that goes to each invoice When user hits DONE, the program would check if the overall amount matches the sums of all amount entered to each invoice But there is a payment details data table im missing? And how does it tie in to hold the “where payment was applied”? submitted by /u/spaceradiowave [link] [comments]

I have a Windows 11 machine. I want to create a database which contains records sorted by date. For each date, I will have a text file, and a video that could be 1 or 2 gigabytes. The resulting file will be in the order of a terabyte. I am the only person who will ever use this database. Which free or cheap software do I need to create and use this database? submitted by /u/Richardcavell [link] [comments]

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

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

Async insert mode in ClickHouse is a great tool for high-frequency writes, but it has some gotchas around when data is actually committed and how deduplication works. We put together a technical walkthrough. submitted by /u/Marksfik [link] [comments]

I'm working as a Software Engineer (Frontend) and didn't work with Databases that deep for so many years. Last time was 6-7 years ago in University and I was working with MySQL Now I'm gonna work on my side projects and I want to know about everything on the Database side and also use them at my work. I totally forgot so many topics. Right now the tool which I'm gonna use is Supabase and PostgreSQL I found this course on FrontendMaster (Which I have subscription) but it's for 7 hours. Does anyone recommend any other courses or better ways so I can go through all the topics and not miss anything? (I generally like watching courses) submitted by /u/Big-Walrus6334 [link] [comments]

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

I currently use an excel spreadsheet to keep track of horses and their trip notes. I am looking to build a database that’s a little cleaner to be able to filter easier and store this data, compared to an excel sheet. Any thoughts/direction on how to accomplish this? submitted by /u/biigeiight [link] [comments]

submitted by /u/db-master [link] [comments]

Hello! I'm really hoping someone may be able to help me. I'm trying to find a free way to create a digitized database for a small group of user records for my new position as I had something similar at my last job. However, at my last job we just created a database with Microsoft access and I had no part in its creation, just in basic data management. I am unfortunately not look for anything robust, just need a small server to host this. I am unfortunately pretty technologically weak in terms of creating or coding something, but I can maintain records. I saw someone saying that like postgres is a good free database but I am finding myself more and more lost trying to work with it. Is there a way to do what I'm trying to do, is postgres good, or should I just find an alternative to what i'm trying to do and database management isn't what I'd need? submitted by /u/gr8twisting [link] [comments]

Hello, first of all sorry if this isn't the right sub. But I'm reading and trying to apply Len Silverton's Data Model Resource Book, but there is one thing I can't grasp yet. If I invoice for a shipment and some items were damaged, I could make another invoice to credit for those items, but if I want to send a replacement in another shipment, how can I attach that to that invoice or previous shipment? I have table shipment_items_billing, which is made of (shipment_id, shipment_item_seq_id, invoice_id, invoice_item_seq_id) (composed pk). So if I query a group by shipments, sum(qty shipped - qty_billed), I get how much I'm owing the client. For example: invoice1: qty=10 shipment1: qty=8 so I'm owing the client 2 units. But if I make another shipment linked to invoice1 with qty=2, I get that I still owe 2 items for shipment1 and 8 are not invoiced for shipment2. I could make a different query to see which invoices have pending shipping quantities, but then if I query the first one i still get the wrong values. What's wrong with my understanding? Edit: here is an example I wrote: https://pastebin.com/dc3ymFxZ submitted by /u/twaw09 [link] [comments]

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

Hey folks, I’m working on an open-source Rust project that sits between app and DB, and I’m looking for technical feedback on design tradeoffs. Current scope: MySQL + PostgreSQL protocol support read/write routing connection pooling query fingerprinting + slow-query analytics optional dashboard/API Questions I’d really value input on: Where would you draw the line between proxy responsibilities vs app responsibilities? What failure modes should be prioritized first (pool starvation, failover flapping, tx edge cases)? For production usage, what would be your “must-have before adoption” checklist? submitted by /u/Physical_Math_9135 [link] [comments]

(if this is not the right place to post please remove / redirect me) Hi all, I work at a firm and part of my role is managing our physical and digital library which has numerous resources including books, reports, references, etc. These resources are organised by dewy decimal system, and we use Notion as a library catalogue to search for the location of these items. The physical library has these resources on shelves, and for the digital library we keep the resources in file explorerer. If a resource is moved, deleted or added, it must be updated manually in notion, and so I was wondering if there was a way to automate this. I've been thinking of using a combination of SharePoint and Microsoft lists, but I'm wondering if there's a better way to do this? Thanks! submitted by /u/mincedduck [link] [comments]

Hi Everyone, I wanted to ask if there’s any way through which someone can directly fetch internal data from a local or cloud database. I built a simple tool that allows users to download financial data in CSV format. The issue with the current system is that if a user needs data for hundreds of instruments, they have to enter each instrument name one by one and download separate CSV files for each. I feel this becomes a very tedious process. So, I was thinking it might be better to provide users with direct access to the data and let them work with it however they want. Also, the users here are not random people they are a few of my friends who need access to this data. Tech Stack POSTGRES PgAdmin application submitted by /u/Ok_Egg_6647 [link] [comments]

Hey everyone, I'm losing my mind with this issue. I have two Spring Boot projects — one using MySQL and one using PostgreSQL. I've been trying to set database credentials using setx in Windows CMD, but IntelliJ keeps picking up old values even after restarting. The problem: Even after running setx DB_USERNAME postgres, the app still tries to connect as root Even after hardcoding the credentials directly in application.properties, I still get Access denied for user 'root'@'localhost' Invalidating IntelliJ cache didn't help Run Configurations don't have any hardcoded env variables What I've tried: setx DB_USERNAME and setx DB_PASSWORD multiple times Hardcoding credentials directly in application.properties Invalidating IntelliJ caches and restarting Creating a new MySQL user with a simpler password (no special characters) Adding spring.batch.jdbc.initialize-schema=never Environment: IntelliJ IDEA Spring Boot 3.4.5 MySQL 8.0 + PostgreSQL 18 Windows 11 JDK 17 Has anyone faced this? How do I force IntelliJ/Spring to actually use the credentials I set? submitted by /u/Aggressive_Science_5 [link] [comments]

I got a test involving that in 2 days, and until now i just end up blindly guessing based on patterns since i cannot understand how to analyze it, even with everything i hit up on the internet. submitted by /u/Elite_Asriel [link] [comments]

Been working on this for a while and figured our approach might be interesting to people who've tried (and failed) to point an LLM at a legacy codebase and ask it to "migrate to MongoDB." Spoiler: that doesn't work. Not on anything bigger than a toy project. The reason isn't that the models are bad at writing code - they're great at it. The reason is that they don't understand the code, and more importantly, they don't have the fluid abstraction thinking a human architect uses to decide what to migrate to in the first place. Schema redesign, query reshaping, DAL boundaries, transactional semantics - those are architectural decisions, not synthesis problems. Throwing more context window at it doesn't fix this. What we ended up doing instead is reframing replatforming as a workflow rather than a single agent task: - Discovery (map app surface, data flows, query patterns) - DAL isolation + test coverage to lock current behavior - Migration assessment (what's actually movable, what's a landmine) - Schema design, but empirically validated against real query patterns instead of guessed - New parallel DAL implementation alongside the legacy one - Live Data migration with CDC (we use our own tool, Dsync) for low-downtime cutover Each stage is idempotent, produces reviewable artifacts, and critically, runs at a specific level of abstraction. A human architect reviews architectural decisions and test results - not diffs. That's the part that unlocks it for actual codebases. What we tested it on: MS SQL -> Mongo/Cosmos Postgres -> Mongo Dynamo → Mongo/Cosmos What it's not: a magic button. It compresses the engineering bottleneck dramatically, but you still own UAT, environment promotion, stakeholder sign-off, and the cutover itself. Anyone selling you "production replatform in a weekend" is lying. Would love to hear from folks who faced the problem before (or now!) and what approaches you used or contemplated. submitted by /u/mr_pants99 [link] [comments]

I have this table (Sqlite): CREATE TABLE "userActivity" ( "actionId"INTEGER, "action"TEXT, "userId"INTEGER, "timestamp"TEXT, PRIMARY KEY("actionId" AUTOINCREMENT), FOREIGN KEY("userId") REFERENCES "users"("userId") ) that is read into this DTO: UserActivity <F extends Enum<F> & Feature<F>> { private F action; private Account<F> user; private LocalDateTime timestamp; public UserActivity(F action, Account<F> user, LocalDateTime timestamp) { this .action = action; this .user = user; this .timestamp = timestamp; } .... However, I have problems when a user gets deleted, since a user is referenced using id. I have a soft delete strategy whereby there's a copy users_archive table, that keeps all rows deleted from the users table. How do I resolve this? 1. Keep only a snapshot of the user (userName, accountType, accountClass) as strings (not a fan of having "non-descriptive" data structures/DTOs. Create a user_activity_archive that references users_archive; and have a row that gets deleted from users cascade into userActivity. A third strategy other than this? Thanks in advance. submitted by /u/No-Security-7518 [link] [comments]

https://dveeden.github.io/mysql-history-graph/ submitted by /u/dveeden [link] [comments]

I'm hoping to build something that would help me at work. We have multiple carriers that have rates based on similar criteria, and right now I need to check each carrier individually. I'd like to be able to fill in boxes of a query with age, sex, and smoker status and get the results of each carriers' plans. Ideally this would show all 7 carriers and their 5 plans each. I'd like to create either a spreadsheet or LibreOffice Base tool to help me do this, but I'm not sure if it's better to use one over the other. If I use Excel, do I have to do vlookup in a grid for each option? I tried to do a database on my own using basic tutorials, but I think I need to make multiple sheets instead of one like I tried? submitted by /u/kittenco [link] [comments]

The Database team at Figma built a new service that implements connection & load management primitives to protect our Postgres fleet. Read more about it here: https://www.figma.com/blog/pgkeeper-building-the-bouncer-we-needed-for-postgres/ submitted by /u/mehantr [link] [comments]