frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

OrioleDB Patent: now freely available to the Postgres community

https://supabase.com/blog/orioledb-patent-free
184•tosh•3h ago

Comments

hardwaresofton•3h ago
Supabase consistently delivering massive value to the postgres ecosystem
916c0553e164269•3h ago
from the blog: "The patent is intended as a shield, not a sword, to protect Open Source from hostile IP claims."

vs. the current license:

  "IF ANY LITIGATION IS INSTITUTED AGAINST SUPABASE, INC. BY A LICENSEE OF THIS SOFTWARE, THEN THE LICENSE GRANTED TO SAID LICENSEE SHALL TERMINATE AS OF THE DATE SUCH LITIGATION IS FILED."
( https://github.com/orioledb/orioledb/blob/main/LICENSE )

imho: the current wording might discourage state organisations, since even a trivial lawsuit (e.g. a minor tax delay) could terminate the licence - perhaps a narrower patent-focused clause would work better (or an OSI-approved licence?).

cwillu•3h ago
Or litigation from a future license violation
giancarlostoro•3h ago
Sounds like the MS-PL which Microsoft used to use but switched to MIT. MS-PL is basically MIT but cover your butt against patent litigation.
yellow_lead•3h ago
A shield for Supabase, not for us
Reubend•3h ago
So what? I don't see any conflict between what they said and what the license says. As they stated, it's being used as a shield. If you're suing them, you probably don't deserve a free license to their patented tech.
graemep•2h ago
The difference is that the license is terminated by ANY litigation against Supabase - e.g. if you sue them for breach of contract completely unrelated to the software.

Use as a shield would mean limiting it to patent litigation against a user of the software.

It also only covers litigation against Supabase - it does not provide a shield against litigation against OrioleDB users.

916c0553e164269•2h ago
Apache 2.0 has a better patent clause - against hostile IP claims, so tax dispute is not terminate the OrioleDB license:

"If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed."

https://opensource.org/license/apache-2-0

crote•21m ago
It also seems a lot less strict on what is being terminated.

On violation the Apache 2.0 license terminates the patent license. I might be mistaken, but that reads an awful lot like you're still allowed to use the software provided you do so in a way which doesn't violate the patent.

On the other hand, the OrioleDB license seems to terminate the entire license - so the way I read this it would include parts of the software which aren't covered under the patent itself.

kiwicopple•2h ago
(Supabase ceo)

I’ll revisit this with legal to try make it clearer.

Our intentions here are clear - if people have examples that we can follow we will do what we can to make this irrevocable (even to the extent of donating the patent if/when the community are ready to bear the cost of the maintainance)

gobdovan•2h ago
Can you acquire atlasgo too, or is that still on the secret roadmap?
kiwicopple•2h ago
we will have something to announce in this space within a few months

(if the atlasgo team are reading this feel free to reach out too)

jacquesm•30m ago
This is highly unprofessional.
916c0553e164269•2h ago
Appreciate the intent!

For practical adoption, especially in larger orgs, OSI-approved licences are much easier to get through legal review than custom ones.

kiwicopple•2h ago
The current license is PostgreSQL (which is OSI approved)

We could also change to MIT/Apache but we feel PostgreSQL is more appropriate given our intentions to upstream the code

crote•29m ago
> The current license is PostgreSQL

That's just not true. Your license[0] adds a clause to the Postgresql license[1]. This makes it a different license, which by extension also means it isn't OSI approved.

It's the same with the BSD licenses[2]: the 4-clause one is OSI-approved, whereas the 3-clause one is not. Turns out that one additional "all advertising must display the following acknowledgement" clause was rather important - and so is your lawsuit clause.

[0]: https://github.com/orioledb/orioledb?tab=License-1-ov-file

[1]: https://github.com/postgres/postgres?tab=License-1-ov-file

[2]: https://en.wikipedia.org/wiki/BSD_licenses#4-clause_license_...

limagnolia•11m ago
The PostgreSQL license does not have a termination clause, you added that. I see that you are trying to use the PostgreSQL license as the basis and simply add the patent clause onto it, but it fundamentally changes the license.

I hope you can look at the Apache 2 patent grant as a better clause- or even adopt something like Google's Additional IP License found here- https://www.webmproject.org/license/additional/, which doesn't modify the open source license but instead adds an additional grant as a separate license.

Supabase is doing great work, thank you!

tux3•1h ago
Google has a strong patent shield situation with AV1. Despite burning interest from patent trolls, no one is going after AOMedia members directly.
oefrha•36m ago
Facebook famously dropped Patents from their BSD + Patents for React and a bunch of other projects, and went MIT unencumbered.

https://engineering.fb.com/2017/09/22/web/relicensing-react-...

0xb0565e486•3h ago
I did not know you could patent data structures like that.
psychoslave•2h ago
That's juridiction dependent. Europe didn't allow such a thing last time I checked. But lobbying to do so as been recurrent on this topic, just like putting governmental backdoor everywhere. They will try until it passes. There should be legal penality for such a stubborn will to destroy civil liberty. At least in this case they can't play the card "think of the children, nazi pedophiles use this".
wokkel•2h ago
You can in the US. Not so much in the rest of the world.
jonathaneunice•2h ago
IP owners often play the game of “patent what you can, threaten with the rest.” So you might not be able to strictly patent the way data is laid out, but specific, novel algorithms that update or manipulate that layout and improve what was possible before? Those can be understood as key steps of an “innovative process”—and courts have been willing to uphold process claims, especially when tied to what they understand are genuine technical improvements. Fighting even a marginal patent usually means a long, expensive slog with plenty of downside risk.

IANAL nor a patent judge, but this is my understanding after watching the space for some years.

monadoid•2h ago
Love you supabase
8cvor6j844qw_d6•2h ago
Is OrioleDB just PostgreSQL but with some underlying modifications for cloud environments?

How does it compare with Neon DB?

LtdJorge•2h ago
It’s a different storage engine for Postgres
boxed•2h ago
The "cloud environments" part sounds like marketing fluff. "The cloud" is just someone else's servers after all. There's nothing special about it.
pbronez•2h ago
In this case, it seems to refer to their support for S3-compatible object storage as for persistence.
IgorPartola•2h ago
That’s like saying a chair is just a tree that has been modified. Technically true, practically there are some very specific differences.
throwaway894345•1h ago
What are the relevant differences? I’m not as cynical as the parent commenter, but I’m also unclear about what OrioleDB is doing that is meaningfully “CloudNative”. From skimming the main page, it seems like it’s just doing storage differently, but so far I’ve seen nothing to suggest that difference is “leveraging cloud services” or anything else.
916c0553e164269•2h ago
"The differences between OrioleDB and Neon" ( June 20, 2025 )

https://www.orioledb.com/blog/orioledb-neon-differences

boxed•2h ago
The graphs for OrioleDB looks very impressive. Can someone give a counter argument to switching to this?
wwizo•2h ago
Oreole is not a plug-and-play yet. From their docs ( https://www.orioledb.com/docs ) > OrioleDB currently requires a set of patches to PostgreSQL to enhance the pluggable storage API and other PostgreSQL subsystems. All of these patches have been submitted to the PostgreSQL community and are under review.
Sesse__•2h ago
You get basically most of the advantages of a B-tree-oriented table, but also most of the disadvantages AFAIK. In particular, any index lookup/scan is going to take twice as long (index blocks don't point to the place on disk, they just contain the primary key and then you need to go lookup _that_ in the actual table).
akorotkov•1h ago
This is generally true, but there are some additional aspects.

1. With PostgreSQL heap, you need to access the heap page itself. And it's not for free. It goes all through the buffer manager and other related components.

2. In OrioleDB, we have a lightweight protocol to read from pages. In-memory pages are connected using direct links (https://www.orioledb.com/docs/architecture/overview#dual-poi...), and pages are read lock-less (https://www.orioledb.com/docs/architecture/overview#page-str...). Additionally, tree navigation for simple data types skips both copying and tuple deforming (https://www.orioledb.com/blog/orioledb-fastpath-search).

According to all of the above, I believe OrioleDB still wins in the case of secondary key lookup. I think this is indirectly confirmed by the results of the TPC-C benchmark, which contains quite a lot of log of secondary key lookups. However, this subject is worth dedicated benchmarking in the future.

Sesse__•1h ago
It would be interesting to see how OrioleDB does with more OLAP-like loads. From when I spent a lot of time benchmarking this, the indirect index design was _the_ main reason why MySQL+InnoDB was losing significantly to Postgres on TPC-H (well, DBT-3).[1] There was a lot of working around it with covering indexes etc..

Of course, the flip side of the coin is that if you do an UPDATE of a row in the presence of a secondary index, and the UPDATE doesn't touch the key, then you don't need to update the index(es) at all. So it really depends on how much you update rows versus how often you index-scan them IME.

[1] TPC-H doesn't have difficult enough queries to really stress the planner, so it mattered comparatively less there than in other OLAP work.

akorotkov•1h ago
Thank you, that would be on the TODO list.
jitl•1h ago
That’s how regular Postgres b-tree indexes work too.
Sesse__•1h ago
I'll take a [citation needed] on that one.
akorotkov•1h ago
Yep, regular PostgreSQL indexes point to a heap location (block number + offset). And it is the same for primary and secondary indexes.
pbronez•2h ago
OrioleDB is new to me.

According to the docs, it “uses Postgres Table Access Method (TAM) to provide a pluggable storage engine for PostgreSQL. […] Pluggable Storage gives developers the ability to use different storage engines for different tables within the same database. Developers will be able to choose a storage method that is optimized for their specific needs: some tables could be configured for high transactional loads, others for analytics workloads, and still others for archiving.”

https://www.orioledb.com/docs

fuzzy_biscuit•2h ago
I strongly dislike the idea of patenting data structures.
kiwicopple•2h ago
fwiw, this is not our m.o. - oriole was under development before we took on the maintenance/development.

Our goal now is to ensure that it’s as F/OSS as possible given the pre-existing conditions

dkhenry•2h ago
I am super bullish on OrioleDB. It really seems like the next logical progression for scaling Postgres for 99% of all databases out there. I have been following their development for a while and running benchmarks to see if their performance claims are legitimate, and so far it has been amazing

https://airtable.com/app7jp5t0dEHyDpa8/shr00etqywoDW2N6N

kiwicopple•2h ago
Thanks for verifying the benchmarks. We’re close to a full RC, aiming for December

Just to add: if anyone wants to contribute (beyond code) benchmarking and stress-testing is very helpful for us

Sesse__•2h ago
I assume you get this a lot, but how much patching is left in PG 18?
kiwicopple•2h ago
We are tracking the patches here:

https://www.orioledb.com/docs#patch-set

The actual storage engine is written as an extension - these patches are mostly to improve the TAM API. If these are accepted by the community then it should be simpler for anyone to write their own Storage extensions.

I think (correctly) it will take a lot longer to upstream the extension - the PG community should take a “default no” attitude with big changes like this. Over time we will prove its worthiness (hopefully beyond just supabase - it would be good to collaborate with other Postgres providers)

Sesse__•1h ago
OK, so basically no big change with PG 18, and for the time being, one needs to basically your own Postgres?

Would be really nice with a pgdg package, as this is definitely the kind of thing I would want to test in a separate cluster :-)

btown•1h ago
Based on the README [0] and discussion [1] it seems like it might especially shine on high-write-volume workflows, with the implementation of anti-bloat measures. Do you have a sense for whether it would shine even further where those rows have large text/JSONB fields that might be TOASTed?

And more generally, curious if you have any sense for what might make up the "1%" of workflows this wouldn't be advisable for? Any downsides to be aware of?

[0] https://github.com/orioledb/orioledb?tab=readme-ov-file#orio...

[1] https://news.ycombinator.com/item?id=30462695 (2022)

jitl•1h ago
> OrioleDB implements default 64-bit transaction identifiers

RDS support when

awaseem•1h ago
Honestly so amazing! Supabase doing great work as always
gethly•1h ago
Software patents is such an americanism. In this case, I prefer Chinese approach to ignoring patent law altogether.
navigate8310•1h ago
That simply kills innovation and dries up funding for research.
henry700•59m ago
It's what I think too, BUT curiously is not the case for China. Imagine if the DeepSeek breakthroughs were patented and closed instead of published in the open. And here we are, and they're not patented and not built on patented technology.
Zetaphor•42m ago
China is far ahead of the US in many sectors, notably electric cars and solar panels which are two industries whose progress heavily depend on research and innovation.
throw0101d•6m ago
> China is far ahead of the US in many sectors, notably electric cars and solar panels which are two industries whose progress heavily depend on research and innovation.

Ahead in production. Did China research/innovate/develop those industries, or were they 'just' fast followers? (Early in its history the US used the same 'tactics' relative to the UK and other European countries.)

dangoodmanUT•1h ago
> OrioleDB tables don't support SERIALIZABLE isolation level.

This is an unfortunate limitation to be aware of when evaluating

https://www.orioledb.com/docs/usage/getting-started#current-...

btown•1h ago
For what it's worth, this does appear to be just a temporary situation, as mentioned in that linked document and in code comments e.g. https://github.com/orioledb/orioledb/blob/7f3b3a9a8e195ba31f...
MrHamdulay•15m ago
that message was put there 2 years ago. soon may not be coming.
samlambert•52m ago
This is not an open source license and it's untrue to say it's an open source project when it's licensed this way.

"IF ANY LITIGATION IS INSTITUTED AGAINST SUPABASE, INC. BY A LICENSEE OF THIS SOFTWARE, THEN THE LICENSE GRANTED TO SAID LICENSEE SHALL TERMINATE AS OF THE DATE SUCH LITIGATION IS FILED."

This is a poison pill. At best the licensing is naive and blocks even customers of Supabase from using OrioleDB, at worst it's an attempt for Supabase to provide themselves unlimited indemnity through the guise of a community project. It means the moment you sue Supabase for anything. Contract dispute, IP, employment, unrelated tort you lose the license. They could lose your data and if you try do anything about it they can immediately counter sue for a license violation. Using the brand of the postgres license to slip this in is pretty wild.

OrioleDB looks like a promising project and undoubtedly an great contribution from Supabase but it's not open source or really usable by anyone with this license.

jitl•49m ago
I recall Facebook had a similar rider on the React license for many years until eventually removing it. It’s visually similar to the Apache2 patent clause but not scoped to just the licensed software use
seveibar•24m ago
Isn’t this just Apache 2-style permissive licensing?
samlambert•15m ago
lol no they both read as permissive on the surface. apache 2 doesn't include a termination clause that broadly protects an entity against any litigation. this is incredibly broad and not community safe.
victorbjorklund•31m ago
Non go when it includes a poison pill.
iam_saurabh•16m ago
Open-sourcing a patent in the database space is rare. Do you think this signals a shift where companies will realize that open ecosystems drive adoption faster than closed IP walls?

OrioleDB Patent: now freely available to the Postgres community

https://supabase.com/blog/orioledb-patent-free
193•tosh•3h ago•67 comments

I replaced Animal Crossing's dialogue with a live LLM by hacking GameCube memory

https://joshfonseca.com/blogs/animal-crossing-llm
659•vuciv•12h ago•138 comments

Kerberoasting

https://blog.cryptographyengineering.com/2025/09/10/kerberoasting/
59•feross•3h ago•20 comments

Pontevedra, Spain declares its entire urban area a "reduced traffic zone"

https://www.greeneuropeanjournal.eu/made-for-people-not-cars-reclaiming-european-cities/
407•robtherobber•5h ago•465 comments

iPhone Air

https://www.apple.com/newsroom/2025/09/introducing-iphone-air-a-powerful-new-iphone-with-a-breakt...
828•excerionsforte•20h ago•1689 comments

Guy running a Google rival from his laundry room

https://www.fastcompany.com/91396271/searcha-page-seekninja-diy-search-engines
82•coloneltcb•1h ago•59 comments

Show HN: CrabCamera – Cross-platform camera plugin for Tauri desktop apps

https://crates.io/crates/crabcamera
21•MKuykendall•3d ago•2 comments

E-paper display reaches the realm of LCD screens

https://spectrum.ieee.org/e-paper-display-modos
523•rbanffy•21h ago•170 comments

Rendering flame fractals with a compute shader (2023)

https://wrighter.xyz/blog/2023_08_17_flame_fractals_in_comp_shader
32•ibobev•2d ago•6 comments

NASA finds Titan's lakes may be creating vesicles with primitive cell walls

https://www.sciencedaily.com/releases/2025/08/250831112449.htm
208•Gaishan•15h ago•53 comments

Knowledge and memory

https://www.robinsloan.com/lab/knowledge-and-memory/
51•zdw•3d ago•24 comments

Infracost (YC W21) Is Hiring First Product Manager to Shift FinOps Left

https://www.ycombinator.com/companies/infracost/jobs/ukwJ299-senior-product-manager
1•akh•3h ago

Claude now has access to a server-side container environment

https://www.anthropic.com/news/create-files
603•meetpateltech•1d ago•316 comments

US High school students' scores fall in reading and math

https://apnews.com/article/naep-reading-math-scores-12th-grade-c18d6e3fbc125f12948cc70cb85a520a
446•bikenaga•1d ago•801 comments

All clickwheel iPod games have now been preserved for posterity

https://arstechnica.com/gaming/2025/09/all-54-lost-clickwheel-ipod-games-have-now-been-preserved-...
174•CharlesW•1d ago•47 comments

We all dodged a bullet

https://xeiaso.net/notes/2025/we-dodged-a-bullet/
774•WhyNotHugo•1d ago•430 comments

Some thoughts on personal Git hosting

https://shkspr.mobi/blog/2025/09/some-thoughts-on-personal-git-hosting/
50•ColinWright•3d ago•43 comments

R-Zero: Self-Evolving Reasoning LLM from Zero Data

https://arxiv.org/abs/2508.05004
79•lawrenceyan•13h ago•32 comments

PKM apps need to get better at resurfacing information

https://ankursethi.com/blog/pkm-apps-need-to-get-better-at-resurfacing-information/
27•GeneralMaximus•3d ago•17 comments

Children and young people's reading in 2025

https://literacytrust.org.uk/research-services/research-reports/children-and-young-peoples-readin...
54•GeoAtreides•8h ago•47 comments

YouTube is a mysterious monopoly

https://anderegg.ca/2025/09/08/youtube-is-a-mysterious-monopoly
316•geerlingguy•1d ago•410 comments

Tarsnap Is Cozy

https://til.andrew-quinn.me/posts/tarsnap-is-cozy/
37•hiAndrewQuinn•2h ago•24 comments

Memory Integrity Enforcement

https://security.apple.com/blog/memory-integrity-enforcement/
449•circuit•20h ago•208 comments

Axial twist theory

https://en.wikipedia.org/wiki/Axial_twist_theory
161•lordnacho•3d ago•39 comments

Hypervisor in 1k Lines

https://1000hv.seiya.me/en
109•lioeters•15h ago•11 comments

Tomorrow's emoji today: Unicode 17.0

https://jenniferdaniel.substack.com/p/tomorrows-emoji-today-unicode-170
187•ChrisArchitect•21h ago•299 comments

Show HN: Bottlefire – Build single-executable microVMs from Docker images

https://bottlefire.dev/
139•losfair•3d ago•21 comments

Building a DOOM-like multiplayer shooter in pure SQL

https://cedardb.com/blog/doomql/
227•lvogel•1d ago•35 comments

Semantic Line Breaks

https://sembr.org
40•Bogdanp•3d ago•33 comments

Show HN: Ark v0.5.0 – A Minimal, High-Performance Entity Component System for Go

https://github.com/mlange-42/ark
8•mlange-42•38m ago•0 comments