#Sql

r/Database 8h ago u/donewithreallife Record keeping without AI Hello there, I am a marine biology MSc student, starting with my thesis, and my supervisor wants me to use Airtable as a way to keep the cohort/fish/tank information.…

Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.

Been working in sql for a long time and i created this tool which has been saving me tons of time and headache at my day to day. Check it out and let me know if you or your company might want a license submitted by /u/shredlegend [link] [comments]

Just had an interview with an employer that most people would consider a dream job and am nearly 100% sure I blew it. This is the only interview I've ever studied for. I did not apply to this role. An internal recruiter reached out to me.…

Hi! I'm self-taught in programming and have never learned how to handle databases; I'm trying to run a FiveM server from this opensource code: https://github.com/SOZ-Faut-etre-Sub/SOZ-FiveM-Server and followed their explanations to migrate the database,…

For example here is the n+1 problem // 1 query to get all surveys const surveys = await db.query("SELECT * FROM surveys"); // then N queries — one per survey const results = await Promise.all( surveys.map(async (survey) => { const employee = await…

Benchmarked SQLite write performance 11 ways and the result was not what I expected. The database wasn't the bottleneck. The ORM was. Raw sqlite3.executemany hits 88K r/s. SQLAlchemy caps at 3,800.…

Data drift is one of those issues that can look small at first but take much longer to track down than expected. A common case: staging and production schemas look the same, but a few reference tables have changed.…

Hi everyone, Working with JSON/JSONB data inside relational databases is often a pain. Most database IDEs treat JSON fields as massive, unformatted text strings, forcing you to copy-paste them into external formatters just to understand what's going on.…

I just started learning SQL through an online course at Western Governors University The online course has so much technical jargon that really seems uneccessary but I've been learning the actual coding aspect on Youtube and using other platforms like…

Hey everyone, we’ve been working on pgpulse (https://pgpulse.io), a Supabase-native PostgreSQL observability product, and I wanted to share one part of the thinking behind it and get feedback from people actually running apps on Supabase.…

Hi everyone, I'm working on a small online store that sells gadgets - about 5-7 types of devices (smartphones, smartwatches, tablets, etc.). Nothing crazy big, but users need to filter by stuff like: battery life / capacity screen size (inches) display…

Vendor decided for all newer versions of their software, which we need for compliance reasons, will no longer support MS SQL on-prem servers and everything is migrating to BigQuery.…

I work part-time as a student on a supply chain analytics team (we use SAP ECC R/3) and my boss wants to stop using TXT/CSV batch jobs. Instead, they want to move SAP tables and Z-transaction data directly into a middle layer in SQL Server for reporting…

Hi all! I tagged this as oracle since I believe that’s the closest SQL format to PL/SQL. I tried to search this, but I’m not sure how to word it, so I’m not getting any hits. The data I’m looking at shows charges on an account.…

We're building a data pipeline that processes FEC (Federal Election Commission) financial filing data. Each filing contains a parent record and thousands of itemization rows (individual transactions).…

I have this query in Bigquery: SELECT column1, column2, count(*) FROM table GROUP BY column1, column2 HAVING COUNT(*) > 1 When I run it, I get no data as a result, so no duplicates in the table.…

MySQL used to be the fast one. Back in the 5.7 days, if you ran a typical website-style workload, MySQL would out-run heavier, fancier databases. Speed was its best reputation. According to our benchmark numbers, that reputation no longer matches reality.…

Hey guys, I'm quite new in SQL, I learnt MySQL in college and we used the workbench. I'm building a DB for a project and since I have GitHub education, I have Jetbrains, so I can get DataGrip.…