Tag: yagni principle

LOB data rarely causes problems on day one.  The real damage happens quietly, over years, until storage, backups, and maintenance collapse…Continue reading on Medium »

Enterprise Data Warehouse DecommissioningContinue reading on Medium »

You picked PostgreSQL because it’s “battle-tested.” Now your write workload is melting your disk budget.Continue reading on Medium »

I am learning SQL and working on a personal project. Before I go ahead and build this database, I just wanted to get some feedback on my ER diagram. Specifically, I am not sure whether the types of relations I made are accurate. But, I am definitely open to any other feedback you might have. My goal is to create a basic airlines operations database that has the ability to track passenger, airport, and airline info to build itineraries. submitted by /u/sandmann07 [link] [comments]

Optimizing a database requires a combination of indexing strategies, memory tuning, query optimization, and periodic maintenance.Continue reading on Medium »

All you needContinue reading on Medium »

PowerBI Course at Rs 99Continue reading on PowerBI + Microsoft Fabric »

PART-1Continue reading on Medium »

Covers Derived data concepts from the DDIA bookContinue reading on Medium »

Organizations that master SQL Server replication gain a decisive edge in distributing data securely while building AI-ready pipelines that…Continue reading on Medium »

Since my last post there is more than 1 year passed, improving and hardening the APIs, fixing bugs. Now as the 1.0 of release of the…Continue reading on Medium »

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

Looked at neon they do give pg 18 but it isn't built with io_uring, can't truly get the benifits of async io select version(); version ----------------------------------------------------------------------------------------------------------------------- PostgreSQL 18.1 (32149dd) on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit (1 row) neondb=> select name, enumvals from pg_settings where name = 'io_method'; name | enumvals -----------+--------------- io_method | {sync,worker} Any provider that does that for free? submitted by /u/ThreadStarver [link] [comments]

I'm creating an app that may require thousands to tens of thousands of select queries to be sent to a PostgreSQL database. Is there an efficient way to handle that many requests? submitted by /u/paulchauwn [link] [comments]

I've been preparing for database-related interviews (backend/data/infra role), but I keep running into the same problem: my practical database skills don't always translate well to whiteboard discussions. In my daily work, I rely heavily on context: existing architecture, real data distribution, query plans, metrics, production environment constraints, etc. I iterate and validate hypotheses repeatedly. But whiteboarding lacks all of this. In interviews, I'm asked to design architectures, explain the role of indexes, and clearly articulate trade-offs. All of this has to be done from memory in a few minutes, with someone watching. I'm not very good at "thinking out loud," my thought process seems to take longer than average, and I speak relatively slowly... I get even more nervous and sometimes stutter when an interviewer is watching me. I've tried many methods to improve this "whiteboard thinking" ability. For example, redesigning previous architectures from scratch without looking at notes; practicing explaining design choices verbally; and using IQB interview questions to simulate the types of questions interviewers actually ask. Sometimes I use Beyz coding assistant and practice mock interviews with friends over Zoom to test the coherence of my reasoning when expressed verbally. I also try to avoid using any tools, forcing myself to think independently, but I don't know which of these methods are truly helpful for long-term improvement. How can I quickly improve my whiteboard thinking skills in a short amount of time? Any advice would be greatly appreciated! TIA! submitted by /u/Various_Candidate325 [link] [comments]

Hi Everyone, We’re planning a new infrastructure rehaul in our organization. The idea is: A Production database in a Production VNet A separate Testing VNet with a Test DB server When new code is pushed to the test environment, a test database is created from production data I’m leaning toward using Azure’s managed database restore from backup to create the test database. However, our sysadmin suggests manually dumping the production database (pg_dump) and restoring it into the test DB using scripts as part of the deployment. For those who’ve done this in Azure: Which approach is considered best practice? Is managed restore suitable for code-driven test deployments, or is pg_dump more common? Any real-world pros/cons? Would appreciate hearing how others handle this. Thanks! submitted by /u/Additional-Skirt-937 [link] [comments]

I’m having a bit of a problem with my website. I sent it off of digital products and the problem is that I have roughly around over 1 million files to upload to the site. The problem is not with the amount of storage but with the sheer number of files from my hosting plan I’m only allowed 700,000 files and unfortunately that will not be enough. I’m using C panel. and they were unsure what to do. I need the solution for this. They need at least 100 GB. Any suggestions anyone? For context these are zip files and video files. submitted by /u/Comfortable_Fly_6372 [link] [comments]

I have built an alpha version: https://github.com/ShreyashM17/ShunyaDB of it, I would be building this in upcoming months. This would be based on Rust, It would eventually support Vector, Document, Graph, etc types of data. I am open to knowing your opinions, let me know if I should do something, in a different way. submitted by /u/AmbitiousSwan5130 [link] [comments]

Our company's ERP system started with a few basic (but important) customizations, but over time each department has added new features based on what they need. And that makes sense because at first, we 100% needed to improve workflows, but now I'm seeing more and more bugs and slowdowns. The problem is, the more we customize, the harder it becomes to maintain. And whenever we need a really important big upgrade, it's kind of like building on top of crap.. So how can you tell when there's been too much customization? How do you not let it turn into technical debt? I need to understand this "add more features" VS clean up what you have thing, and whether or not we need to bring someone in to help, since we're thinking we can get Leverage Tech for ERP but we don't want to pay for a full new system (yet). submitted by /u/rennan [link] [comments]

Some backstory: My team and I built a SaaS tool that is closing to 100K MRR, growing at about 10-15% pm. We’re located in Europe and our team dynamic is rather conservative. A 5-person team from which 2 are devs. We’ve realized from past experience that small, hybrid teams work better, but marketing and product often take up dev time to pull PostgreSQL data because they don’t know SQL. We looked at tools that can simplify these database interactions by eliminating the need for SQL. Perhaps an AI tool that creates the code for you. Something that keeps things well organized and makes visual reports. The level of query complexity is not (yet) that big, so it should be doable. But data protection is essential and the most important deciding factor. After looking for a while I identified several open source options that look reliable (Vanna and chat2db) but it is painfully evident that their Github and PR is manipulated with marketing tactics. Hence, despite claiming data protection and security, I am still uncertain. Then we got a recommendation for TalkBI from a startup friend. They are using it for the same reason we want to, but it’s not open source. I noticed it’s hosted by European providers and everything is encrypted and secure. Yet the tool is quite new and unpopular compared to the other two options. TalkBI reviews are scarce. So I am looking for other teams who might’ve used TalkBI and what you think about it. More specifically around encryption standards, how data is (or could be) used by the company, and if TalkBI is safe to connect our database to. Or, if you know of a company that might’ve used them feel free to DM me their name so I can talk with their team directly. submitted by /u/gallade17 [link] [comments]

Hi r/Database, I’m one of the developers behind Valentina Studio, a cross-platform database tool, (Win, Linux, Mac). In our recent 16.5 release we added an AI chat directly into the SQL editor — not as a generic chatbot, but as a feature that understands the current query, schema, and referenced tables. The goal is to reduce context switching while keeping SQL execution explicit and controlled. Some design details: The experience is inspired by Copilot-style workflows, adapted for databases. AI uses your current SQL, schema, and referenced tables as context. Switch between Ask Mode and Agent Mode. Agent Mode can adjust and run SQL queries when needed. Works with OpenAI, Claude, Gemini, OpenRouter, and xAI. Supports custom instructions per provider. A practical AI assistant designed specifically for SQL work. Each SQL Editor has its own chat and context. AI has access to Python engine of Valentina Studio. What do you think? We going yet to add other information, e.g. Query Result. submitted by /u/ruslan_zasukhin [link] [comments]

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

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

I need to convince my boss to buy SQL Standard licenses. We are already using Express, but how do I make the argument to buy licenses? submitted by /u/Tight-Shallot2461 [link] [comments]

I've been building a Postgres database manager that is absolutely stuffed with features including: ER diagram & schema navigator Relationship explorer Database data quality auditing Simple dashboard Table skills (pivot table detection etc...) Smart data previews (URL, geo, colours etc...) I really think I've built possibly the best user experience in terms of navigating and getting the most out of your tables. Right now the app is completely standalone, it just stores everything in local storage. Would love to get some feedback on it. I haven't even given it a proper domain or name yet! Let me know what you think: https://schema-two.vercel.app/ submitted by /u/Luc_Gibson [link] [comments]

Hi everyone, In our company, we are currently migrating a legacy local MS Access database to a self-hosted PostgreSQL server (running on a dedicated rack server). Now I need a frontend solution for 3-4 users working in a mixed environment of Windows, macOS, and Linux. I am essentially looking for "Access features without the internal database engine". Here is what I need specifically: Visual Form Builder (Data Entry): I need the classic "Access User Interface" experience. Forms with buttons, input fields, dropdowns, and sub-forms to populate and manage the database efficiently. It needs to be more than just a spreadsheet view; I need actual GUI "masks" for the users. Scripting/Logic: A functional replacement for VBA to handle button actions and business logic. Visual Report Designer: This is a hard requirement. I need pixel-perfect printing/PDF generation for invoices and reports. Most modern web-builders (like Budibase, NocoDB, etc.) seem great for simple CRUD interfaces but often feel terrible for complex reporting or "dense" data entry screens. My Question: Is there a professional tool that actually covers all Access capabilities (especially the rich forms and reporting) but runs on top of Postgres and works across all OSs? Thanks! submitted by /u/thef4f0 [link] [comments]

I am new to databases and need to make one for my A-level coursework. While normalising my relational database I ended up creating many smaller tables that link the main tables and only contain the primary key of the two tables they are linked to as fields. This is to facilitate the many-to-many relations between tables. Do these tables have an actual name, I haven't been able to find one and am tired of calling them cross-reference tables every time I mention them in the written section. Any help is greatly appreciated! submitted by /u/A_British_Dude [link] [comments]

Working on a backend project and went with PostgreSQL. It's been solid, but I'm always curious what others in the community prefer. - What are you using and why? submitted by /u/Automatic-Step-9756 [link] [comments]

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

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

Hello guys, I want to understand the concept of the wraparound in transaction ID and the frozen rows what happens exactly in it. I keep getting lost. submitted by /u/HyperNoms [link] [comments]

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

I have some experience with Supabase and they're kinda everywhere. The hipster in my spirit wants to try something new and lesser-known. Does anyone have any good recommendations that aren't either completely code and/or paired with a vibecode/lowcode frontend builders (like lovable or bubble)? Headless database tools ig? Edit: postgress with vector db?? submitted by /u/twitter_is_DEAD [link] [comments]

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

it feels like every time i start a project, people want to talk about distributed systems, global scaling, and no-sql flexibility before we even have enough rows to fill an excel sheet. it is a total trap. we spend weeks setting up these complex, "future-proof" clusters that are a nightmare to query and even harder to back up. we are basically building a rocket ship to go to the grocery store. meanwhile, a simple, "boring" postgres or mysql setup on a single server could handle our entire workload with 90% less stress and a much smaller bill. submitted by /u/daniel_odiase [link] [comments]