😌 SELECT 😌

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://abilenetechguy.com/sqlite_admin.zip

🧪 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.

I built SQL Mocker, an AI tool that helps users write SQL from natural-language questions using only schema metadata - tables, columns, data types, and relationships.

It can also test queries against dummy data and explain or improve existing SQL, without accessing your real data.

I’d appreciate honest feedback: would this be useful in your work?

https://www.sqlmocker.com

I built SQL Mocker, an AI tool that helps users write SQL from natural-language questions using only schema metadata - tables, columns, data types, and relationships.

It can also test queries against dummy data and explain or improve existing SQL, without accessing your real data.

I’d appreciate honest feedback: would this be useful in your work?

https://www.sqlmocker.com

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.

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 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...

My team is migrating multiple AI applications and currently evaluating Lakebase.
I wanted to understand if we create a branch fr testing schema/data changes, are the vector indices isolated as well, or do we need to have an strategy to avoid rebuilding them repeatedly?
Also, any performance/operational things you ran into that might help.
Love to hear from anyone.

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

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 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! 😊

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 ?

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,

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