Android database storage formats appropriate for JavaScript access -

-

i'm developing android application, typically small database (hundreds thousand or main entries, plus similar order of magnitude in joined tables) populated user. there file associated each main entry, kept separate, , not part of question.

in current prototype, structured data stored in sqlite database in usual way, , synced between devices uploading file application folder on google drive. allows me avoid having provide user storage, hope stick to.

storing files here has happy side effect can access them via javascript code in web page using google drive api. javascript interacting remote sqlite file incredibly ugly thing attempt. (downloading database server-side , handling there option sounds not great either.) wondering if has recommendations of best practice approach here, given have web-based version of app accessing same data.

the obvious sensible idea seems be

exporting sqlite other structured format xxx (like xml, json, csv, ...) first, uploading xxx file google drive, javascript can straightforwardly interact it, , on sync reimporting xxx data sqlite.

though i'm happy hear criticisms/improvements on idea.

i'm interested in best-practice recommendations of efficient ways approach these problems. question: what file format xxx good; , have recommended methods (a) exporting , importing in java sqlite xxx, (b) interacting in preferably client-side javascript remote google drive file in format xxx? (if maintaining server-side code interact xxx substantially better practice say.)

it depends on how many clients app manage

exporting sqlite other structured format xxx (like xml, json, csv, ...) first, uploading xxx file google drive, javascript can straightforwardly interact it, , on sync reimporting xxx data sqlite.

imho, quite bad idea quite few reasons:

  1. if multiple users try change data @ same time, have tough problem managing data entries , possible conflicts
  2. providing direct access data layer bad idea since client can wipe out data

if have few users or making personal project, can stick sqlite.

kripken, developer of emscripten (the c/c++ javascript llvm compiler) has compiled sqlite library javascript make sql.js library. can find on github. there's demo page of sql.js

but if have lot of users, might want use firebase google. gives database , rest api use it. there libraries access firebase different programming languages too.

cheers!


Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more