Hacker News Reader

xarici_ishleron Ask HN: What are you working on? (April 2025)

Thanks for the feedback! I updated the form

xarici_ishleron Ask HN: What are you working on? (April 2025)

This comment is still (surprisingly!) gaining traction, so leaving this here

xarici_ishleron Ask HN: What are you working on? (April 2025)

https://dequery.io :) Added a little signup form (with possibility of providing additional feedback)

xarici_ishleron Ask HN: What are you working on? (April 2025)

Thanks for the motivation to finish this as soon as possible :) I'm working on a basic landing page with screenshots/videos and a "get notified" button right now – shoot me an (empty, if you want) email (in profile) and I'll ping you as soon as it's ready

xarici_ishleron Ask HN: What are you working on? (April 2025)

Thanks for the suggestion! I am using https://github.com/tobymao/sqlglot, which magically supports most SQL dialects. And yes, support for DuckDB is also in future plans

xarici_ishleron Ask HN: What are you working on? (April 2025)

You're onto the original idea I started out with! Unfortunately it's very difficult to correlate input SQL to an output query plan – but possible. It's definitely in future plans

xarici_ishleron Ask HN: What are you working on? (April 2025)

What database are you using? I'd be happy to hear about your usecases and hopefully help you, shoot me an email (in profile)

xarici_ishleron Ask HN: What are you working on? (April 2025)

Thank you, nice to get some idea validation from folks in the industry. For sure data warehouses are the top priority on my TODO list, I picked PG first because that's what I'm familiar with.

I can ping you via email when the debugger is ready, if you're interested. My email is in my profile

xarici_ishleron Ask HN: What are you working on? (April 2025)

Thanks! Would you mind sharing what would be your use cases?

At my job, all of our business logic (4 KLOC of network topology algorithms) is written in a niche query language, which we have been migrating to PostgreSQL. When an inconsistency/error is found, tracking it can take days, manually commenting out parts of query and looking at the results.

xarici_ishleron Ask HN: What are you working on? (April 2025)

For now, yes, but I'll start working on adding support for all other DBs (especially OLAP) as soon as possible. The geberal approach is the same, I just have to handle all the edge cases of the SQL dialects

xarici_ishleron Ask HN: What are you working on? (April 2025)

The first ever SQL debugger – runs & visualizes your query step-by-step, every clause, condition, expression, incl. GROUP BY, aggregates / windows, DISTINCT (ON), subqueries (even correlated ones!), CTEs, you name it.

You can search for full or partial rows and see the whole query lineage – which intermediate rows from which CTEs/subqueries contributed to the result you're searching for.

Entirely offline & no usage of AI. Free in-browser version (using PGLite WASM), paid desktop version.

No website yet, here's a 5 minute showcase (skip to middle): https://www.loom.com/share/c03b57fa61fc4c509b1e2134e53b70dd

xarici_ishleron Ask HN: Nicknames for Computer Science Books?

It's probably better if you provide a bit more context: "boar" is "kabanchik" in Russian

xarici_ishleron Complexity theory puts limits on performance of gradient descent

https://www.youtube.com/watch?v=oX9aPNF6_h8

This is a great video explaining Brouwer's theorem and its (theoretical) application to stirring a cup of water.

xarici_ishleron Launch HN: Awesomic (YC S21) – Get design tasks done with 24-hour turnaround

I'm from a CIS country (Azerbaijan) and I applaud you for taking on the challenge of empowering the local workforce and exposing them to foreign markets. There's a lot of untapped talent in ex-USSR countries that can produce outstanding work for a fraction of the cost of their western colleagues, while earning a pretty high (relative to local) income. I for one am working for a foreign startup for $23/h and am living a quite comfortable, even luxurious life, while saving a good chunk of my income.

One question in my head was left unanswered while I read through your post and website: who is responsible for finding and connecting with clients? How do you do that (or how are you planning to scale your current approach)?

xarici_ishleron Do countries get the list of every passenger that's transiting their airspace?

That's a common misconception. Telegram private chats are by default not e2e encrypted (but you can create a separate "secret chat", which will be).