frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Paging Through a Parquet File in DuckDB: File_row_number or Offset?

https://rusty.today/blog/paging-parquet-duckdb-file-row-number-vs-offset/
16•rustyconover•1h ago

Comments

matharmin•8m ago
I'd assume it's common knowledge that you cannot paginate using OFFSET + LIMIT unless you use ORDER BY on an unique set of columns, no matter what database you're using. The only exception is when the database provides an explicit order guarantee without the ORDER BY, such as the case with `preserve_insertion_order = true` here.

Gemini Robotics 2 brings whole body intelligence to robots

https://deepmind.google/blog/gemini-robotics-2-brings-whole-body-intelligence-to-robots/
99•ai2027•48m ago•61 comments

Paging Through a Parquet File in DuckDB: File_row_number or Offset?

https://rusty.today/blog/paging-parquet-duckdb-file-row-number-vs-offset/
16•rustyconover•1h ago•1 comments

SDL_GPU minimal, single-header, high-performance 2D graphics painting library

https://github.com/n67094/sdl_gp
26•n67094•1h ago•6 comments

Launch HN: Prized (YC S26) – Let non-engineer staff build secure internal tools

https://prized.dev
35•marinoseliades•2h ago•19 comments

Hacker Public Radio

https://hackerpublicradio.org/
39•bmacho•1h ago•3 comments

The Economic Benefit of Refactoring

https://martinfowler.com/articles/exploring-gen-ai/refactoring-economic-benefit.html
18•javaeeeee•53m ago•7 comments

RFC 8890 – The Internet is for End Users (2020)

https://mnot.net/blog/2020/for_the_users
54•notarobot123•2h ago•16 comments

Ron Gilbert started production on Thimbleweed Park 2

https://www.grumpygamer.com/twp2_announce/
161•alberto-m•7h ago•74 comments

Physicists Solve a Muon Mystery. Now, Old Results Don't Add Up

https://www.quantamagazine.org/physicists-solve-a-muon-mystery-now-old-results-dont-add-up-20260729/
7•ibobev•41m ago•0 comments

Upper stage impacting the moon on 2026 August 5

https://www.projectpluto.com/25010d.htm
31•ryannevius•2h ago•9 comments

Gpiozero Flow

https://bennuttall.com/blog/2026/07/gpiozero-flow/
103•benn_88•5h ago•33 comments

Why Don't People Use Formal Methods? (2019)

https://www.hillelwayne.com/post/why-dont-people-use-formal-methods/
78•Thom2503•3h ago•55 comments

Why Is Everyone Trying to Build a Solid-State Battery?

https://www.construction-physics.com/p/why-is-everyone-trying-to-build-a
78•crescit_eundo•3h ago•83 comments

Mbodi AI (YC P25) Is Hiring Robotics/Research Engineers

https://www.ycombinator.com/companies/mbodi-ai/jobs
1•chitianhao•4h ago

RCade: The Arcade Cabinet with CI/CD Deployment, Custom Graphics Card for CRT [video]

https://www.youtube.com/watch?v=W-OpIbLUOU0
6•evakhoury•19h ago•0 comments

Trusted URLs via Cryptographic Signatures

https://blog.certisfy.com/2026/04/trusted-urls-via-cryptographic.html
8•Edmond•1h ago•6 comments

Building a native C# implementation of CEL engine

https://bsid.io/writing/building-a-cel-engine-for-net
19•jackedEngineer•2d ago•2 comments

Are We Stuck with Lean?

https://mathoverflow.net/questions/513742/are-we-stuck-with-lean
51•jjgreen•4h ago•18 comments

The Alice and Bob After Dinner Speech (1984)

https://hex.ooo/library/alicebob.html
19•kamma4434•3d ago•3 comments

Go LLM SDK for streaming, tool-calling AI backends (plus frontend React lib)

https://github.com/grafana/ai-sdk
35•matryer•4h ago•13 comments

3D Pinball for Windows (1995)

https://98.js.org/programs/pinball/space-cadet.html
43•mushstory•4h ago•22 comments

The Glass Famine

https://edconway.substack.com/p/the-glass-famine
77•baud147258•3d ago•34 comments

CosmosEscape: Taking over Every Database in Azure Cosmos DB

https://www.wiz.io/blog/cosmosescape-taking-over-every-database-in-azure-cosmos-db
35•uvuv•3h ago•8 comments

The Lost Civic Life of Movie Rental Stores

https://thereader.mitpress.mit.edu/the-lost-civic-life-of-movie-rental-stores/
40•facundo_olano•1h ago•41 comments

Azulejo

https://en.wikipedia.org/wiki/Azulejo
125•Amorymeltzer•1d ago•39 comments

You can't solve computer use by ignoring the interface

https://steelmanlabs.com/blog/computer-use-is-far-from-solved
40•mpavlov•4h ago•19 comments

Google will expand age checks on Android worldwide till the end of the year

https://android-developers.googleblog.com/2026/07/google-play-age-signals-api-safer-experiences.html
251•dmantis•5h ago•281 comments

The first watch featuring computer functions

https://by.seiko-design.com/140th/en/topic/58.html
67•stefanv•4d ago•27 comments

Why DNA damage from smoking and UV rays cause cancer in some but not others

https://www.cam.ac.uk/research/news/study-reveals-why-dna-damage-from-smoking-and-uv-rays-may-cau...
43•gmays•1h ago•62 comments

AI's top startups are barely publishing their research

https://www.science.org/content/article/ai-s-top-startups-are-barely-publishing-their-research
570•YeGoblynQueenne•18h ago•302 comments