Live data from Hacker News

Lovefield – A relational database for web apps

google.github.io

21–30 of 60 posts

Re: Lovefield – A relational database for web apps

#23
Interesting. At first I was thinking this might be part of their cross-platform (iOS/Android/web) architecture that they use for Inbox, Sheets, and a few other things.

E.g. they assert that, despite having pure-native views (e.g. no Swing-style "one UI for all platforms"), they share ~70% of the client-side code across iOS/Android/web.

Which to me insinuates the reused code is probably things like the domain models, validation rules, and also online/offline data storage/sync logic.

E.g. maybe Lovefield was part of that cross-platform client-side storage architecture. But probably not since it's Javascript. (Which is fine, Google is a big place/lots of different apps/needs.)

Re: Lovefield – A relational database for web apps

#28
post #11
post #8

Earlier quoted context omitted.

Why couldn't Firefox use SQLite?

There's a W3C rule, that each browser needs their own implementation. If everybody uses the same code, it's considered a Monoculture security risk [1]. 1. https://www.schneier.com/blog/archives/2010/12/software_mono...

Thanks, that's a great article. May be worth a repost since it's been 5 years since it was last posted (according to my cursory searches).

Somebody posted it: https://news.ycombinator.com/item?id=10199163

Re: Lovefield – A relational database for web apps

#29
From the first 1 minute and 15 seconds of the video:

> "With WebSQL being deprecated, and IndexedDB not providing structured queries, web developers need a tool to satisfy their structured query needs."

> "Web app developers need structured queries to work in the mobile world."

> "With IndexedDB ... there's a steeeep learning curve to make it useful for your app. Moreover, IndexedDB does not provide structured queries."

> "IndexedDB does not offer structured query features, such as sorting by multiple columns, or joining the results of multiple tables."

As someone that looked forward to WebSQL, this is painful to hear. Many of us realized the above from the beginning. Yet, some in the standards committee found a way to shoot down WebSQL, w/vague rationale such as "we don't feel it's the best path for the web".

Well, thank you. Instead of giving us one of the most well tested SQL implementations (SQL Lite) that addresses all of the above, and much more, we were shoved a harder to use, more verbose, and less powerful alternative (IndexedDB). And as a result, we're having to implement our own relational databases. In JavaScript. 4-5 years later.

No offense to Lovefield, but it represents everything wrong w/the decision to deprecate WebSQL and implement IndexedDB instead. It was also the single-most decision that made me lose faith in the standards committee.

Re: Lovefield – A relational database for web apps

#30
post #11
post #8

Earlier quoted context omitted.

Why couldn't Firefox use SQLite?

There's a W3C rule, that each browser needs their own implementation. If everybody uses the same code, it's considered a Monoculture security risk [1]. 1. https://www.schneier.com/blog/archives/2010/12/software_mono...

ffs
Post reply on HN