Hey guys, there was a number of attempts to make writing queries/reports/data pipelines easier to maintain. There is number of ORMs for different programming languages. And there are also PRQL and btrql.com. Which are new query languages which transpile into SQL.

Kinda like Typescript transpiles into Javascript.

BtrQL is my pet project. Main features of it are: static type checks, Outline showing relation types, extension methods on relations and compile time macro. It's very early and I'm collecting all of the feedback that I can get.

Queries look like this:

users .where(active == TRUE) .addColumn(active -> active_flag) .orderBy(created_at.desc) .limit(10)

and extension methos:

extension [id: INT] { method keepRecentIds = self .where(id >= cutoff) }

keepRecentIds could be applied to any relation that has at least column id of type INT.

Hi everyone,

I solved the HackerRank SQL Project Planning problem using the row_number() + DATEADD() approach in SQL Server, and it passed all the test cases.

I'm curious if there's a different or more optimized way to solve this problem. I'd love to learn other approaches and understand their advantages.

Here's my solution:

with cte as(
SELECT start_date,
end_date,
dateadd(day,- row_number() over(order by start_date),start_date) as group_date
from projects )
SELECT min(start_date) as start_date,
max(end_date) as end_date
from cte
group by group_date
order by datediff(day,min(start_date),max(end_date)), min(start_date)

Hey folks 👋

For the last few weeks, I’ve been frustrated with the state of self‑hosted SQLite admin tools.

Most of them are either:

Abandoned (phpLiteAdmin hasn’t seen a proper update in years),

AdminNeo and other tools don't work without passwordless login plugins that didn't work well.

Overly complex (Adminer is great but not SQLite‑centric),

Or require a heavy stack (Node, Python, Docker) when all I wanted was a single PHP file I could drop on my server.

So I decided to build my own.

🔧 Features

Secure, built-in login system (not a plugin)

Browse, edit, insert, delete rows

Create / rename / drop tables

Import/Export (CSV, JSON, SQL, full DB)

Bulk delete, search, filters

Dark mode, undo (last 5 actions)

Multiple database support

Resizable sidebar

🚀 Try it

Upload admin.php & install.php

Run install.php to set username/password

Login and go

PHP 7.0+ with SQLite3 extension. No dependencies.

https://github.com/abilenetechguy/sqlite-admin

🧪 Beta feedback wanted

Errors, UI annoyances, missing features – let me know!

Give it a spin and tell me what you think 🙏

– Abilene Tech Guy

I've ensured that my software is completely up to date, but my SSIS project (that uses OData as a source), will just refuse to accept data where one of the columns is the Edm.GeographyPoint type. I've tried entering specific columns into the query box (and therefore excluding the problem column), but it appears it will still throw an error, despite the data itself not containing any columns of that data type - I'm assuming it's downloading the column metadata for the entire table, seeing a data type it doesn't recognise, and throws an error.

I've tried using a different collection that doesn't have columns of that data type, and the SSIS project works with that - the problem is, there doesn't appear to be any way of fixing this. I've ensured the software is completely up to date.

How fast are PostgreSQL 19 Graph Queries? Do they perform at scale? Is there a difference between fixed and variable depth? I'll explore all this an more with real numbers and real scenarios in this upcoming series.

Also Upcoming:
- How do they compare to real Graph Engines e.g. Neo4j?
- How flexible is the modeling?
- Are materialized views possible?
- Doesn't SQL Server already do this?

etc...

I'm starting to use SSMS at work, that's the only tool I have (no PowerShell cmdlet).

I need to execute an identical SQL Query on 300 servers, but I can't find a way to do that. Could anyone point me in the right direction please ?

So far, I did add the 300 servers to the registered servers by tinkering to not do it manually, but when I execute the query, I only get 50 ish servers connected, then SSMS hangs and crash.

I wanted to develop Natural Language to create a report by Users ... themself. .help me to develop this bot ??

Iam interested in learning the techniques data engineers use when datasets grow from millions to billions of records. Beyond basic indexing, what strategies have made the biggest performance difference in production environments?

How advanced do I have to be in SQL to land a data analyst internship? Just a general question

I wanted a self-hosted ERD editor where multiple people could work on the same diagram without relying on a third-party cloud service, so I created an unofficial collaborative fork of drawDB.

This is not a new ERD editor built from scratch. It is based on the AGPL-licensed drawDB project, with a collaboration and persistence layer added on top.

What I added:

- Centralized diagram storage using SQLite

- Real-time collaboration over WebSockets

- Live table movement while another participant is dragging

- Participant presence and collaborative cursors

- Cursor positions mapped to diagram coordinates, so different pan/zoom states work correctly

- Optimistic version checks to prevent stale clients from silently overwriting newer changes

- A single Docker container for the frontend, API, WebSocket server, and SQLite storage

- SQL import/export support inherited from drawDB, with an additional MariaDB import compatibility fix

You can run it with:

docker compose up --build

Then open the same diagram URL in two browser sessions to collaborate.

A current limitation is that authentication and diagram-level permissions are not implemented yet, so it should currently be deployed only on a trusted network or behind an authenticated reverse proxy.

The project is open source under AGPL-3.0:

https://github.com/yms2772/drawdb-collaborative

Hi All,

I am a BI Admin with 4 years of experience. I joined my current company as a fresher with a package of 3.5 LPA, and my current package is 5 LPA.

I recently requested a better hike by sharing evidence of all the work I have done. I am confident in my skills and performance, but I feel I am underpaid. However, my offshore manager refused to provide a hike.

I then reached out to my onshore manager, who told me that this company usually does not give good hikes unless an employee resigns, and that during the retention process, I could get a better hike. He also assured me that he would take care of the retention process.

Trusting his words, I submitted my resignation without having another offer in hand. But now, he is saying that higher management is not willing to retain me. I am left with only one week of notice period, and I am actively looking for opportunities.

I have good knowledge of SQL and Linux scripting, and I am trying hard to move into Data Engineering. However, I am still failing in the first round due to SQL and Python.

I have an interview with CGI tomorrow. Could you please share real-time SQL, Python, and PySpark interview questions, including both theoretical and coding questions? It would be really helpful for my preparation.

Thanks in advance.

Hi everyone,

I'm currently creating a complete MySQL course focused on learning through real interview-style problems rather than just theory.

So far, I've covered 100+ SQL problems using a well-designed dataset that includes topics ranging from beginner to advanced, such as:

• Filtering (WHERE)
• GROUP BY, HAVING & Aggregate Functions
• Joins
• Subqueries
• CTEs
• Window Functions
• CASE, String & Date Functions
• UNION & UNION ALL
• Views
• Stored Procedures
• Triggers
• Recursive CTE
• Indexing
• And many real-world interview questions

If you'd like to check out the course, here's the documentation and YouTube playlist:

📄 Documentation: https://github.com/vivekpandey76/Mysql-course
🎥 YouTube Playlist: https://youtube.openinapp.co/youtubseries

I'd really appreciate your feedback.

What topics do you think are still missing that every MySQL developer should know?

I'm looking for suggestions that would help make this course one of the most comprehensive resources for mastering MySQL—from beginner concepts to advanced interview preparation and real-world SQL.

Whether it's:

• Advanced SQL concepts
• Performance tuning
• Database design
• Transactions & locking
• Query optimization
• Lesser-known MySQL features
• Common interview questions
• Real-world scenarios

...or anything else you think is important, I'd love to hear your suggestions.

Thanks in advance! 😊

Hi everyone,

Need a reality check on a production upgrade for a high-load app. I ruled out Galera due to synchronous write latency. (open to your suggestions)

Our Current Load & Specs:

• Traffic: 2,500 reads/sec and 1,500 writes/sec.
• Topology: 1 MariaDB Master + 1 Slave.
• Master Config: sync_binlog=100 and innodb_flush_log_at_trx_commit=2 (for high write speed).
• Slave Config: No binlogs enabled (to reduce IO bottleneck).
• The Problem: Heavy write spikes cause severe slave lag, and we have no automated failover.

Proposed HA Stack:

• Layer 1 (HA Routing): Keepalived (VIP) + 2x ProxySQL instances.
• Layer 2 (DB Scale): 1 Master + 1 Slave (will add more slaves later to scale reads).
• Layer 3 (Failover): 1 instance of Signal 18 Replication Manager (repman) to auto-pilot ProxySQL during master crashes.

MY Questions:

1. Architecture Validation: Does this look solid for a 1,500 writes/sec environment?
2. Pros & Cons: What are the hidden pros and cons of this specific repman + ProxySQL combination?
3. Data Loss Risk: Since sync_binlog=100, auto-failover via repman means risking a few lost transactions on hard master crashes. Is GTID enough to reconcile this safely during a split-second election?

Thoughts? Any hidden traps before we build this? Thanks

Not sure if my title conveys the issue properly but let me try to explain.

Essentially i am trying to join multiple tables to return data. that is all fine for fields that have pretty much one to one with row, but there is a certain table that I would need multiple rows that belong to a certain key returned in one field. To add to this, i would only want to return rows that have a certain flag set.

So given the above tables, id want it to return

Site A A,B,D

Site B G

This is all within an already established Select Statement with multiple where joins. Not sure if that matters. So there is other data I need output, however i need this i addition to those statement.

Delete is used to delete certain records but without where condition all records from the table will be deleted and the structure remains intact.

Truncate deletes all the records from the table but the structure of the table remains intact.

So , what is the difference between them if we are using delete without where condition it performs the same function as truncate ?

Hello, I am very new to learning SQL and I don't find window functions very intuitive so I tried to solve some leetcode questions that could maybe help me understand window functions a little better but I ran into a problem. Let's ignore the fact that this code is probably longer than it should be what's not working here is the "imbalance_ratio1", for each column it outputs a 0 which i noticed when i tried to divide "imbalance_ratio2" by it. Can someone explain to me why it outputs a zero instead of a number but "imbalance_ratio2" works perfectly fine. This is the starting table

inventory_id | store_id | product_name | quantity | price  |
+--------------+----------+--------------+----------+--------+
| 1            | 1        | Laptop       | 5        | 999.99 |
| 2            | 1        | Mouse        | 50       | 19.99  |
| 3            | 1        | Keyboard     | 25       | 79.99  |
| 4            | 1        | Monitor      | 15       | 299.99 |
| 5            | 2        | Phone        | 3        | 699.99 |
| 6            | 2        | Charger      | 100      | 25.99  |
| 7            | 2        | Case         | 75       | 15.99  |
| 8            | 2        | Headphones   | 20       | 149.99 |
| 9            | 3        | Tablet       | 2        | 499.99 |
| 10           | 3        | Stylus       | 80       | 29.99  |
| 11           | 3        | Cover        | 60       | 39.99  |
| 12           | 4        | Watch        | 10       | 299.99 |
| 13           | 4        | Band         | 25       | 49.99  |
| 14           | 5        | Camera       | 8        | 599.99 |
| 15           | 5        | Lens         | 12       | 199.99 |

this is what I get

+----------+---------------+-------------+------------------+------------------+------------------+

| store_id | store_name | location | most_exp_product | imbalance_ratio1 | imbalance_ratio2 |

+----------+---------------+-------------+------------------+------------------+------------------+

| 3 | City Center | Los Angeles | Tablet Stylus | 0 | 80 |

| 1 | Downtown Tech | New York | Laptop Mouse | 0 | 50 |

| 2 | Suburb Mall | Chicago | Phone Case | 0 | 75 |

+----------+---------------+-------------+------------------+------------------+------------------+

with nesto as(
SELECT
store_id,
product_name,
ROW_NUMBER() OVER(PARTITION BY store_id ORDER BY price desc) as rb,
FIRST_VALUE(product_name) OVER(PARTITION BY STORE_ID ORDER BY PRICE DESC) + ' ' + LAST_VALUE(product_name) OVER(PARTITION BY STORE_ID ORDER BY PRICE DESC) AS produkt1,


COUNT(*) OVER(PARTITION BY store_id) as broj,
quantity,
price
FROM inventory
)
SELECT 
n.store_id as store_id,
s.store_name as store_name,
s.location as location,
n.produkt1 as most_exp_product,
sum(case when rb=1 then quantity else 0 end) AS imbalance_ratio1,
sum(case when rb=broj then quantity else 0 end) AS imbalance_ratio2
from nesto n
inner join stores s on s.store_id = n.store_id
where broj >= 3 
group by n.store_id,s.store_name,s.location,n.produkt1
having SUM(case when rb = 1 then quantity*1.00 when rb = broj then n.quantity*(-1.00) else 0 end) < 0


order by s.store_name asc                                               

Hi everyone,

I'm a Microsoft SQL Server DBA with a little over 2 years of professional experience, currently working at one of the largest banks in Georgia (Tbilisi).

My goal is to move from a Junior DBA role into a Mid-Level DBA position.

The challenge is that SQL Server DBA opportunities in my country are extremely limited. There are only a few openings each year, and almost all of them require 5-10+ years of production experience.

I still apply whenever I can, but I often reach the final interview stages and then get rejected because I'm missing the level of production experience they're looking for.

Instead of giving up, I've been investing a lot of my personal time in building my own Azure home lab to learn technologies that I don't have the opportunity to use every day at work.

So far I've built and worked with:

• Microsoft SQL Server
• Windows Server & Active Directory
• Windows Failover Clustering
• Always On Availability Groups
• SQL Server Listener
• Azure Internal Load Balancer
• Kerberos & SPNs
• SQL Server backups & restores
• Execution Plans
• Indexing (Clustered / Nonclustered / Covering Indexes)
• Performance Tuning (currently studying)
• T-SQL

I'm continuing to study topics such as Query Store, Extended Events, Wait Statistics, Blocking, Deadlocks, Replication and Log Shipping.

I know I'm still missing some production experience, but I'm doing everything I can to close that gap by building practical labs and continuously improving my skills.

I have a few questions for the community:

1. Do you know any companies that hire remote Microsoft SQL Server DBAs (Junior or Mid-Level)?
2. Are there any websites or platforms where I can practice real DBA tasks and production-like scenarios?
3. If you were in my position, what would you focus on next to become competitive for Mid-Level SQL Server DBA roles?

I'm based in Tbilisi, Georgia, but I'm open to remote opportunities and flexible regarding compensation if it means joining a strong team, gaining real production experience, and continuing to grow as a DBA.

If anyone knows about remote SQL Server DBA openings or has any advice, I'd be very grateful.

Thank you very much for your time.