Stack Overflow
Stack Overflow

Questions tagged [lovefield]

Lovefield is a relational database for web apps from Google. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Lovefield is a relational database for web apps from Google. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Lovefield is used in Inbox by Google and Google Play Movies & TV.

Some Features

  • SQL-like API
  • ACID transactions
  • Advanced sorting
  • Joins, Group-by, Limits
  • Parameterized Queries
  • Observable Queries, Query Analyzer

Supported Storage Layers

  • IndexDB
  • Firebase Realtime Database
  • MemoryDB
11 questions
6
votes
2 answers

How to configure Angular-CLI-generated project to include a SharedWorker

What are the specific steps to add a SharedWorker to an @angular/cli >1.2-generated project. I would like the SharedWorker to be defined in TypeScript (with full/correct type-definitions editor support), to share interfaces with the main project,…
CalvinDale
  • 9,005
  • 5
  • 29
  • 38
6
votes
0 answers

How does Lovefield stand out from other in-browser JavaScript databases?

Lovefield is a new cross-browser, SQL-like RDBMS in JavaScript. What are its advantages over existing client-side JS database libraries, like: YDN-DB - github.com/yathit/ydn-db TaffyDB - taffydb.com HTML5SQL.JS - html5sql.com AlaSQL.js -…
Andrei
  • 61
  • 1
4
votes
2 answers

Distributing an AngularJS module which uses external Javascript/jQuery libraries

I am developing a reusable component (module) for AngularJS which can be used to enable offline features of applications built with AngularJS. To achieve client side storage features without re-inventing the wheel, I decided to use this good library…
Chaya Sandamali
  • 657
  • 9
  • 22
1
vote
1 answer

Groupby in Lovefield

hello i tried to use innerjoin in lovefield and tried to use groupBy like this: var userCompanies = '', company = ''; user = db.getSchema().table('user'); userCompanies = db.getSchema().table('userCompanies'); …
123bbuingbbuing
  • 47
  • 9
1
vote
1 answer

Exception on connect promise with lovefield

the exception thrown: lovefield.js:2113 Uncaught NotFoundError: Failed to execute 'transaction' on 'IDBDatabase': One of the specified object stores was not found. Ello folks, I've been fighting with Lovefied for quite some time attempting to get my…
Terrance
  • 11,764
  • 4
  • 54
  • 80
1
vote
0 answers

Async flux store operations

I am using the Flux library to provide a dispatcher and stores. However, I am using Google's Lovefield as a means of being an in memory bank. The problem is that Lovefield's APIs are entirely async, therefore I can not emit changes or perform…
jshthornton
  • 1,284
  • 11
  • 29
0
votes
1 answer

The state of Google Lovefield

Google Lovefield is a JS relational database layer on top of IndexedDB: https://github.com/google/lovefield In their FAQ, it is said to be (or have been) in use by gmail. It seems to no longer be developed and hardly maintained, and while the docs…
obe
  • 7,378
  • 5
  • 31
  • 40
0
votes
3 answers

List last messages of chats

CREATE TABLE message (`id` int, `from_user_id` text, `to_user_id` text, `created` datetime, `message` text) ; INSERT INTO message (`id`, `from_user_id`, `to_user_id`, `created`, `message`) VALUES (1, 'a', 'b', '2013-01-14 00:00:00',…
bsr
  • 57,282
  • 86
  • 216
  • 316
0
votes
1 answer

Count items and group by a datetime unit

I'm trying to organize a query which should print a count of items ordered by a time unit such as a hour, a day etc. My limitation is that I'm using LovefieldDB javascript library and complex queries are limited. I have a table of Units where the…
Chriss
  • 1
  • 3
0
votes
2 answers

Javascript database on browser hard-drive

Background: We're writing an HTML5 offline first application for Chrome Browsers. We are targeting specifically Chrome Browsers, and we don't want to make an extension to serve the functionality of the app. Our HTML application also makes to a…
David Mawer
  • 137
  • 1
  • 9
-1
votes
1 answer

Is there any client side Db library that supports partial text search?

I am going thru IndexDB or lovefield but so far could not find way to search partial text like we do in SQL queries via LIKEkeyword. Can someone guide me how could it be achieved?
Volatil3
  • 14,253
  • 38
  • 134
  • 263