Sid Vishnoi

@sidvishnoi
22 Followers
99 Following
340 Posts
I do web and software stuff. And post about plants and space.
Websitehttps://sidvishnoi.com
LocationIndia
GitHubhttps://github.com/sidvishnoi

"Eight years of wanting, three months of building with AI" by Lalit Maganti https://lalitm.com/post/building-syntaqlite-ai/

Lots of good advice, and matches a lot of my experience.

Eight years of wanting, three months of building with AI

For eight years, I’ve wanted a high-quality set of devtools for working with SQLite. Given how important SQLite is to the industry1, I’ve long been puzzled that no one has invested in building a really good developer experience for it2. A couple of weeks ago, after ~250 hours of effort over three months3 on evenings, weekends, and vacation days, I finally released syntaqlite (GitHub), fulfilling this long-held wish. And I believe the main reason this happened was because of AI coding agents4. Of course, there’s no shortage of posts claiming that AI one-shot their project or pushing back and declaring that AI is all slop. I’m going to take a very different approach and, instead, systematically break down my experience building syntaqlite with AI, both where it helped and where it was detrimental. I’ll do this while contextualizing the project and my background so you can independently assess how generalizable this experience was. And whenever I make a claim, I’ll try to back it up with evidence from my project journal, coding transcripts, or commit history5.

Lalit Maganti
@codepo8 Is the process revolting?
“That’s an excellent question”
This might be one of the greatest error messages of all time.

📝 New CSS Article!

If you have seen my graph theory demo and wondered how it works, then the article is finally live!

https://frontendmasters.com/blog/two-circles-one-arrow-and-anchor-positioning/

I was playing with two circles and anchor positioning, and ended up creating a shortest path algorithm.

Modern CSS is fun!

#CSS #HTML

If SQL is pronounced "sequel" then surely DNS is pronounced "Dennis"?

#Android is dying.

We all know that #Google wants to kill the “unverified/sideloaded” apps (names carefully selected by Google’s professional gaslighters to give a negative connotation to “apps that are not distributed by Google’s own store”).

We all know that the new “verification process” amounts basically to a ransom where you need to give Google your keys and your money if you want to build apps for Android.

It involves developers handing their signing keys to a user-hostile American company (so they will sign your package for you and will also able to decrypt your secrets) and paying them a $25 fee for each app.

Even if you don’t even use the Play Store to distribute your apps.

This is not a price to pay to get the app distributed through them, nor for using any of their services. It’s a price to pay just because they want to control the whole ecosystem end-to-end, and they know that they can get away with that because you’ll keep using their shitty OS even if you’re outraged at them.

We all know that they got a lot of backlash. And after the backlash they reiterated that they “listened to the community” and would have made a process to still allow people to “sideload apps”.

Well, today that process has been finally unveiled. And it sounds even shittier than I thought.

That’s because Google is currently filled with the best professional enshittificators in the world: the job role of these people is not to build new things, nor to listen to customers and build what they want. No, their job is specifically to find the sweet spot where they can make things as shitty as possible, add as much friction and user frustration as possible to prevent them from doing a certain thing, while still being able to tell regulators “well, it’s not that shitty, you see? We still give users an option - buried under 10 layers of dark patterns”.

In order to install apps external to the Play Store you will have to:

  • Activate the developer settings (the usual “tap the build number 7 times to show the hidden menu” thing)

  • In the developer settings, enable “Allow Unverified Padckages”

  • Confirm that you are not being coerced (seriously, how much malware did they actually see installed by people being coerced or tricked to download and install random APK files?)

  • Restart your device

  • Wait 24 hours

  • Return to the unverified packages settings

  • Scroll past 3-4 additional warnings whose sole purpose is to scare you off

  • Select either “Allow temporarily“ (7 days) or “Allow indefinitely“ (and I’ve got a hunch that the Allow indefinitely option will probably be gradually phased out)

https://arstechnica.com/gadgets/2026/03/google-details-new-24-hour-process-to-sideload-unverified-android-apps/

Google details new 24-hour process to sideload unverified Android apps

The "advanced flow" will be available before verification enforcement begins later this year.

Ars Technica

Google has news on what you will need to do for still being able to sideload apps:

* enable developer options
* confirm that you are not tricked
* restart phone and re-authenticate
* wait one day
* confirm with biometrics that you know what you are doing
* decide if you only want unrestricted installs for 1 week or forever
* confirm that you accept the risks
* enjoy the few apps that still have developers motivated to develop for a user-base willing to put up with this

https://goo.gle/advance-flow

CSS `light-dark()` is about to support images!

https://www.bram.us/2026/03/19/more-easy-light-dark-mode-switching-light-dark-is-about-to-support-images/

Shipping in Firefox 150. Starting tomorrow, available behind a flag in Chromium 148.

More Easy Light-Dark Mode Switching: light-dark() is about to support images!

CSS light-dark() is being extended to support images.

Bram.us

got more acquainted with BigInt after starting this job.
still don't like basis points.
¯\_(ツ)_/¯

https://chenhuijing.com/blog/mathematical-precision-in-javascript/

Mathematical precision in Javascript | Chen Hui Jing

In a world where most people don't read anymore, and content is written by or at least run through AI for edits, I still find writing out my own thoughts…