frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

Show HN: The current sky at your approximate location, as a CSS gradient

https://sky.dlazaro.ca
425•dlazaro•7h ago•86 comments

The Lethal Trifecta

https://simonwillison.net/2025/Aug/9/bay-area-ai/
184•vismit2000•6h ago•58 comments

Debian 13 "Trixie"

https://www.debian.org/News/2025/20250809
316•ducktective•2h ago•121 comments

The Framework Desktop is a beast

https://world.hey.com/dhh/the-framework-desktop-is-a-beast-636fb4ff
18•lemonberry•1d ago•6 comments

A CT scanner reveals surprises inside the 386 processor's ceramic package

https://www.righto.com/2025/08/intel-386-package-ct-scan.html
102•robin_reala•3h ago•19 comments

Long-term exposure to outdoor air pollution linked to increased risk of dementia

https://www.cam.ac.uk/research/news/long-term-exposure-to-outdoor-air-pollution-linked-to-increased-risk-of-dementia
200•hhs•8h ago•65 comments

OpenFreeMap survived 100k requests per second

https://blog.hyperknot.com/p/openfreemap-survived-100000-requests
286•hyperknot•7h ago•65 comments

Caligra Workbench

https://caligra.com/workbench/
10•phanimahesh•3d ago•2 comments

Quickshell – building blocks for your desktop

https://quickshell.org/
198•abhinavk•4d ago•29 comments

Stanford to continue legacy admissions and withdraw from Cal Grants

https://www.forbes.com/sites/michaeltnietzel/2025/08/08/stanford-to-continue-legacy-admissions-and-withdraw-from-cal-grants/
122•hhs•8h ago•210 comments

"The Hollow Men" at 100

https://prufrock.substack.com/p/the-the-hollow-men-at-100
3•flanged•28m ago•0 comments

How AI is upending the software development industry

https://www.reuters.com/lifestyle/bootcamp-bust-how-ai-is-upending-software-development-industry-2025-08-09/
23•wglb•3h ago•32 comments

ESP32 Bus Pirate 0.5 – A Hardware Hacking Tool That Speaks Every Protocol

https://github.com/geo-tp/ESP32-Bus-Pirate
75•geo-tp•6h ago•14 comments

Synchronizing Clocks by Leveraging Local Clock Properties

https://www.usenix.org/conference/nsdi22/presentation/najafi
3•fanf2•34m ago•0 comments

Isle FPGA Computer: creating a simple, open, modern computer

https://projectf.io/isle/fpga-computer.html
21•pabs3•3d ago•1 comments

MCP overlooks hard-won lessons from distributed systems

https://julsimon.medium.com/why-mcps-disregard-for-40-years-of-rpc-best-practices-will-burn-enterprises-8ef85ce5bc9b
185•yodon•6h ago•105 comments

The current state of LLM-driven development

http://blog.tolki.dev/posts/2025/08-07-llms/
60•Signez•4h ago•31 comments

Testing Bitchat at the music festival

https://primal.net/saunter/testing-bitchat-at-the-music-festival
44•alexcos•3d ago•29 comments

Mexico to US livestock trade halted due to screwworm spread

https://www.usda.gov/about-usda/news/press-releases/2025/07/09/secretary-rollins-takes-decisive-action-and-shuts-down-us-southern-border-ports-livestock-trade-due
223•burnt-resistor•6h ago•173 comments

Ratfactor's Illustrated Guide to Folding Fitted Sheets

https://ratfactor.com/cards/fitted-sheets
102•zdw•9h ago•15 comments

Did California's fast food minimum wage reduce employment?

https://www.nber.org/papers/w34033
36•lxm•11h ago•83 comments

Installing a mini-split AC in a Brooklyn apartment

https://probablydance.com/2025/08/04/installing-a-mini-split-ac-in-a-brooklyn-apartment/
30•ibobev•3d ago•57 comments

The mystery of Alice in Wonderland syndrome

https://www.bbc.com/future/article/20230313-the-mystery-of-alice-in-wonderland-syndrome
16•amichail•3d ago•8 comments

Accessibility and the Agentic Web

https://tetralogical.com/blog/2025/08/08/accessibility-and-the-agentic-web/
18•edent•4h ago•6 comments

Ask HN: What toolchains are people using for desktop app development in 2025?

46•lincoln20xx•4h ago•54 comments

Jan – Ollama alternative with local UI

https://github.com/menloresearch/jan
155•maxloh•11h ago•65 comments

End-User Programmable AI

https://queue.acm.org/detail.cfm?id=3746223
31•tosh•5h ago•1 comments

A brief history of the absurdities of the Soviet Union

https://laurivahtre.ee/empire-of-the-absurd/
102•Maro•5h ago•150 comments

Who got arrested in the raid on the XSS crime forum?

https://krebsonsecurity.com/2025/08/who-got-arrested-in-the-raid-on-the-xss-crime-forum/
4•todsacerdoti•3d ago•0 comments

A Simple CPU on the Game of Life (2021)

https://nicholas.carlini.com/writing/2021/unlimited-register-machine-game-of-life.html
4•jxmorris12•3d ago•0 comments
Open in hackernews

SQLite offline sync for Android quick start

https://github.com/sqliteai/sqlite-sync/tree/main/examples/android-integration
45•marcobambini•5d ago

Comments

xiphias2•2d ago
Looks nice but not open source
notrealyme123•2d ago
https://litesync.io/ seems very decent
vincnetas•2d ago
"The full version of LiteSync is released under a Commercial License."
notrealyme123•2d ago
My bad! Thanks for pointing it out.
marcobambini•2d ago
It is open-source: https://github.com/sqliteai/sqlite-sync
vincnetas•2d ago
It's "source available", but for commercial use : "For production or managed service use, please contact SQLite Cloud, Inc for a commercial license."

So not open source.

marcobambini•2d ago
Yes, you are formally right, it is source available.
vincnetas•2d ago
"technically correct is the best kind of correct" ;)
steventhedev•2d ago
Elastic license, so many people refer to this as source available rather than open source
marcobambini•2d ago
We chose to adopt the Elastic License 2 primarily because of the significant investment we've made in developing this technology, including a robust cross-platform network layer that enables users to implement offline-first functionality with just two lines of code. This license also helps protect our work from being forked and commercially exploited by larger tech companies.
0xferruccio•2d ago
Looks really cool! Congrats on the launch
woadwarrior01•2d ago
̶L̶o̶o̶k̶s̶ ̶l̶i̶k̶e̶ ̶y̶o̶u̶’̶r̶e̶ ̶i̶n̶f̶r̶i̶n̶g̶i̶n̶g̶ ̶o̶n̶ ̶t̶h̶e̶ ̶S̶Q̶L̶i̶t̶e̶ ̶a̶u̶t̶h̶o̶r̶’̶s̶ ̶t̶r̶a̶d̶e̶m̶a̶r̶k̶.̶

Edit: Thanks for clarifying that. It'd be great if you can add it to your README, because the name looks very suspicious at first glance. If you have the rights to use it, explicitly mention it.

marcobambini•2d ago
This is not true. We are also backed by Dr. Richard Hipp, the creator of SQLite, and we have all the rights to use the SQLite name in our products.
anty•2d ago
Very cool, I'm working on something similar!

Naturally I have some questions:

1. I don't see any examples for foreign key constraints (ON DELETE and ON UPDATE) or UNIQUE constraints. Are constraints still supported? 2. How is row-level privacy implemented? Are "forbidden" rows not synced by the server logic, or are they encrypted?

marcobambini•2d ago
1. Good point, we are going to publish more details about constraints in the repo within a few days 2. We have implemented row-level security, so you are free to easily implement any privacy role you want: https://docs.sqlitecloud.io/docs/rls. The "forbidden" rows are not synced

About encryption: all communications are over TLS.

anty•2d ago
Thanks for the clarification. Looking forward to see your solutions to the constraint problems.
mjadobson•2d ago
Does this have any relation to: https://github.com/vlcn-io/cr-sqlite ?

Some of the API naming is similar (db_version, site_id, seq, commit_alter, etc), although the project source is very different (C rather than Rust, different feature set).

crsqlite is no longer maintained so I might be interested in migrating.

marcobambini•2d ago
API naming looks similar, probably because we are based on the same scientific paper: https://munin.uit.no/bitstream/handle/10037/24430/article.pd...
baobun•2d ago
Looks like the "embedded networking" and therefore all network-related syncing is tightly coupled to the closed SaaS running at https://sqlitecloud.io.

It would be cool if the server-side sync API was also documented and versioned, which would allow the possibility of independent compatible self-hostable backend implementations to offset the vendor-lock-in concern.