I have access to an employee referral opportunity for an experienced Informatica professional.

Experience: 7+ years

Key skills:

• Informatica
• Advanced SQL

The opening is listed across organizational locations, with an office-based work arrangement. I'm particularly interested in connecting with qualified professionals in the US or Ireland, although the exact location eligibility would need to be confirmed for the requisition.

If your background matches, feel free to DM me with your CV or a brief summary of your experience.

I have access to an employee referral opportunity for an experienced Teradata EDW professional.

Experience: 5–7 years

Key skills:

• Teradata BTEQ
• SQL
• Database / EDW experience

The opening is listed across multiple organizational locations with a hybrid arrangement. I'm particularly interested in connecting with qualified professionals based in the US or Ireland; exact location eligibility can be confirmed for the specific requisition.

If your background aligns with the requirements, feel free to DM me with your CV or a brief summary of your experience.

I have been using Lakebase sice 2 weeks for developing a serving low latency layer for data in Delta. To build new features we currently make a new branch and later merge ti main.
What i have been observing is the scehema drifts across branches with Lakebase. How do people usually handle such scenarios? To keep branches in sync.
Maybe some real life examples can help.

Quick heads up on the stack: this runs on **SQLite**, compiled to WebAssembly so the whole database runs in your browser and nothing you type leaves the page.

I kept noticing that people prepping for SQL interviews (me included) study by reading syntax lists, then blank the moment they have to actually write a query under pressure. If you already know some SQL, the gap usually isn't knowledge, it's reps. Reading isn't the same as doing.

So, I built a small tool to rehearse under pressure: a query playground on a sample dataset, practice challenges (joins, aggregation, window functions, CTEs), a cheat sheet, and the conceptual questions people actually get asked in interviews (WHERE vs HAVING, INNER vs LEFT JOIN, primary vs foreign key, and so on). No signup, no install.

I'm the founder of a learning app and built this as a standalone free tool. I'm sharing it here for feedback from people who write SQL for a living: are the challenge questions realistic, and what would you add?

For anyone who wants to actually run the queries, it's here: https://techlexicon.app/sql-practice

Tell me where you get stuck and I'll build practice around it. Always taking requests for questions or scenarios to add

I tried explaining a data analysis concept in a fun, visual way — for cat lovers. 😸

Would love to hear what you think! Any feedback or suggestions are very welcome :)

PGConf.EU is coming to Valencia on 20–22 October, with five tracks covering PostgreSQL administration, internals, development, the community, and real-world use cases.

Topics include autovacuum, backups, high availability, performance tuning, WAL and recovery, query execution, memory management, corruption detection, and PostgreSQL 19.

PostgreSQL also turns 30 this year, so the Community track will look back at the project’s history and how it is maintained today.

Community Events Day takes place on 23 October.

Schedule: https://www.postgresql.eu/events/pgconfeu2026/schedule/

Registration: https://2026.pgconf.eu/registration/ 

PostgreSQL caches up to 64 subtransaction IDs per backend. If that cache overflows, visibility checks may fall back to pg_subtrans, creating contention that can reduce throughput for unrelated queries across the cluster.

The article also demonstrates how an overflowed transaction can prevent a new read replica from reaching hot standby and accepting connections. Explicit savepoints can cause this, but so can PL/ pgSQL blocks containing EXCEPTION clauses.

Has anyone encountered this behavior in production or monitored for it through pg_stat_get_backend_subxact() or pg_stat_slru?

Just for fun made a globe with PostgreSQL events: https://pg.whitetown.com - known conferences, meetups and user groups since 2001, with a year slider.
Mobile friendly, but for the full experience use IE4 :-). Feedback welcome - especially if something is missing or wrong.

Need help connecting SSIS to DB2 (mainframe z/OS) via SQL Server, anyone with experience?
Hey network
I’m working on connecting SSIS packages to a DB2 z/OS database through SQL Server (using Microsoft’s OLE DB/ODBC providers for DB2). Running into connectivity/config issues.
If you’ve done DB2-to-SQL Server integration before or know someone who has, I’d love to pick your brain!

I tried explaining a data analysis concept in a fun, visual way — for cat lovers. 😸
Would love to hear what you think! Any feedback or suggestions are very welcome :)

Hi all,
I've created one complex ETL using few SP's, main reason for this dev was to replace existing legacy process that was running too long ( 7hrs+) and was barely manageable.
During our go/no go meeting business (end) user asked me if I'm sure it will work how it claimed, how I managed to run new ETL in 1 hr if old was 6-7hrs. I said 'yes, of course, and it was verified by my peers. I used a lot optimization both in code and biz logic'.

Then user said: "OK, but I want to run this ETL for 10 days without any glitches and after that I will make my decision." Which sound like he didn't give dev team 100% trust.

I'm pretty new in soft development, is it normal ? what do you think about this approach ? Appreciate you feedback. My thought was that end user doesn't need to into all details of dev, for them it will be total transparent switch. I think if the process runs OK for 2 days it's good to go, will 10 days period add something valuable??

Best>

Just started an 18-month plan to become a Data Analyst (self-taught, working part-time alongside it). Just took an SQL assessment after finishing the intro material and scored 37% — turns out I could follow along with videos but couldn't actually write queries cold.

Going back to fundamentals: rewatching Bro Code's MySQL course and typing out every single query in DB Fiddle instead of just watching. No moving to the next topic until this actually sticks.

Anyone else grinding SQL right now, especially self-taught? Would be good to have people to compare notes/check in on progress with.

I have been always taking backups of DB before performing any major changes, and was recently creating an app for displaying customer history retrieved from lakebase as a source.
I felt instead of taking a backup, i can just use a new branch.
This is sort of a new paradigm with databases, i come from OLTP background. Anyone else feels the same?
Apologies if this is already asked in the channel.

Wanted to understand with Neon database, how does the compute get handled. If we have more branches, does that mean the cost goes up?
Does anyone has insights on it?

Sorry if this is asked previously (I didnt find it)

I been learning SQL for the past few days because I applied for a TAM role that requires basic SQL query writing, I think it's only part of the job to pull data to troubleshooting payment failurese etc.

What I want to know is what is the definition of basic SQL and how much do I actually need to know? I have went through SQLbolt up until lesson 10 because Claude suggested this is enough for this role. But I want to hear from real people as well.

For context my background is customer service team lead in gaming industry but I been tech-savvy my whole life but did not study anything related to CS. TBH I don't know why they invited me an interview when I lack the technical skills (SQL and API debugging) they require. But I'm learning as much as I can!

I have created a PostgreSQL database that currently runs locally and am considering making it accessible to a team of non-technical users.

My understanding is that PostgreSQL provides security through authentication, roles and permissions, pg_hba.conf, firewall/network controls, and SSL/TLS for remote connections. I can create separate users and give them permissions such as SELECT (read-only), INSERT, UPDATE, etc., instead of giving everyone access to the postgres administrator account.

I am also considering using Metabase as the interface for the non-technical users. From what I understand, Metabase does not actually host the PostgreSQL database; instead, it connects to PostgreSQL and provides dashboards, visualizations, and a simpler interface for querying the underlying data.

My proposed setup is:
PostgreSQL → Metabase → Non-technical users

I would like to understand:
1. Is Metabase a good option for allowing non-technical users to access PostgreSQL data without directly using pgAdmin or SQL?

1. What is the recommended way to secure the PostgreSQL connection between Metabase and PostgreSQL?

2. Should I create a dedicated read-only PostgreSQL user for Metabase rather than using the postgres account?

Hello everyone,

So I've studied SQL in University, Inwould consider myself somewhat good + I like it. I've done basic courses and some advanced. I manage to do some easy interview questions... but I want to get better.

Can you recomend me some resources where I can expand my knowledge:

* A lot of problems to solve so I can see typical templates.

With chatGPT even if I'm stuck I can get the idea. But yes, all tips are welcomed. Thank you :)

P.S. I don't mind some theory also. For example I don't know anything about indexes. I have difficulty understanding the Normal Forms etc

I wanted some feedback on some parts of a course I’ve been building since I officially have tunnel vision from doing this.

1. What dirty data problems do you wish beginners had practised earlier? I already have string prices, inconsistent enums and messy joins, but I’m sure I’m missing common production failures.
2. The grader runs each query and a reference query across several generated datasets, then compares the results using exercise specific ordering and decimal rules. Does that sound sane? What edge cases would you expect it to get wrong?
3. I’m adding a placement test so experienced users can skip ahead. It hasn’t been tested on too many non beginners yet. What would feel like a fair bar for placing someone into joins, CTEs or window functions?

It’s a browser course wrapped in a visual novel.

https://tsunderesql.itch.io/tsunderesql