TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Lovefield – A relational database for web apps

198 点作者 dumindunuwan超过 9 年前

15 条评论

mzarate06超过 9 年前
From the first 1 minute and 15 seconds of the video:<p>&gt; &quot;With WebSQL being deprecated, and IndexedDB not providing structured queries, web developers need a tool to satisfy their structured query needs.&quot;<p>&gt; &quot;Web app developers need structured queries to work in the mobile world.&quot;<p>&gt; &quot;With IndexedDB ... there&#x27;s a steeeep learning curve to make it useful for your app. Moreover, IndexedDB does not provide structured queries.&quot;<p>&gt; &quot;IndexedDB does not offer structured query features, such as sorting by multiple columns, or joining the results of multiple tables.&quot;<p>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&#x2F;vague rationale such as &quot;we don&#x27;t feel it&#x27;s the best path for the web&quot;.<p>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&#x27;re having to implement our own relational databases. In JavaScript. 4-5 years later.<p>No offense to Lovefield, but it represents everything wrong w&#x2F;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.
评论 #10199175 未加载
评论 #10199114 未加载
评论 #10200296 未加载
评论 #10199118 未加载
评论 #10200765 未加载
sgrove超过 9 年前
Another database which has similar characteristics (although not quite sql-like api&#x27;s) that I&#x27;ve had a lot of luck with is <a href="https:&#x2F;&#x2F;github.com&#x2F;tonsky&#x2F;datascript" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;tonsky&#x2F;datascript</a>. Bit of a tangent, but anyone looking for this kind of functionality might be interested.
jdimov9超过 9 年前
What is a browser database and what is it good for? Would you use one instead of a back-end DB or in conjunction with one? How? Why? Why is this on 1st page - what is cool about it?<p>I&#x27;m clearly missing something, but I can&#x27;t be bothered to watch the videos - can someone TL;DR it for me, please.
评论 #10198343 未加载
评论 #10198174 未加载
评论 #10198152 未加载
评论 #10201136 未加载
评论 #10199342 未加载
amelius超过 9 年前
What happens when the user opens two tabs, both of which try to access the same local database?
评论 #10200005 未加载
评论 #10201025 未加载
评论 #10199491 未加载
stephen超过 9 年前
Interesting. At first I was thinking this might be part of their cross-platform (iOS&#x2F;Android&#x2F;web) architecture that they use for Inbox, Sheets, and a few other things.<p>E.g. they assert that, despite having pure-native views (e.g. no Swing-style &quot;one UI for all platforms&quot;), they share ~70% of the client-side code across iOS&#x2F;Android&#x2F;web.<p>Which to me insinuates the reused code is probably things like the domain models, validation rules, and also online&#x2F;offline data storage&#x2F;sync logic.<p>E.g. maybe Lovefield was part of that cross-platform client-side storage architecture. But probably not since it&#x27;s Javascript. (Which is fine, Google is a big place&#x2F;lots of different apps&#x2F;needs.)
评论 #10200031 未加载
rw2超过 9 年前
This is good for people used to sql but I personally find the way that IndexDB stores data to be superior. You just have to get used to the NoSQL way of persisting objects. Making one technology look like another is never efficient for an app.
olegp超过 9 年前
Would be interesting to compare it to AlaSQL (<a href="https:&#x2F;&#x2F;github.com&#x2F;agershun&#x2F;alasql" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;agershun&#x2F;alasql</a>).
emmanueloga_超过 9 年前
The api style looks very similar to JOOQ&#x27;s one.<p>1: <a href="http:&#x2F;&#x2F;www.jooq.org&#x2F;doc&#x2F;3.6&#x2F;manual&#x2F;sql-building&#x2F;sql-statements&#x2F;dsl-and-non-dsl&#x2F;" rel="nofollow">http:&#x2F;&#x2F;www.jooq.org&#x2F;doc&#x2F;3.6&#x2F;manual&#x2F;sql-building&#x2F;sql-statemen...</a>
jpgvm超过 9 年前
The whole saga is very sad. WebSQL was the right move all along. NoSQL turned out to be a fad and people really just want to use SQL to build real apps. Especially newbies, learning SQL is a lot easier than learning how to reimplement it&#x27;s features on top of a document store.
dom96超过 9 年前
Lovefield is still relatively new and immature. When I tried to use it I ran into some strange errors. The situation might have improved now but I personally would still recommend PouchDB instead.
nnq超过 9 年前
Niiice... last time I tried to get something done with IndexedDB it was total pita. If this manages to take away even 20% of IndexedDB&#x27;s pain, it&#x27;s sure worth taking a look at!
wener超过 9 年前
I&#x27;m not a web developer, but this looks great, I want to learn how SQL things work, maybe this is a good start for beginner ? BTW, speaker&#x27;s face is too serious.
评论 #10198583 未加载
评论 #10199411 未加载
dvh超过 9 年前
Then why did they killed websql in chrome packaged apps?
评论 #10198132 未加载
pvaldes超过 9 年前
wow, the landing page of this web is really fast...
moron4hire超过 9 年前
This just goes to prove that what developers really want out of browsers is not a document viewer but a deployment platform. To go to these lengths, someone has to be very concerned about getting one set of code to run on practically any device. You don&#x27;t otherwise end up with something like this.<p>This wouldn&#x27;t have been possible without the work the Chromium team has done to achieve such complete compatibility between desktop and mobile versions. But unfortunately the browser is still stuck in the mentality that it&#x27;s just a document viewer. I think we really need to wake up and make the browser into a proper deployment platform. I applaud efforts like this, even if I don&#x27;t immediately have a need for such a thing, because they are doing the necessary work to push on browser developers to release the right features towards that goal.