Any alternative to Fusion Tables?

53 views
Skip to first unread message

Blacktea

unread,
Nov 19, 2017, 1:26:42 PM11/19/17
to MIT App Inventor Forum
Hi, because i'm stuck with creating a new table by an App user via API ( Take a look here ) i'd like to know if there is any alternative to Fusion Table.

What i need is :

- Free hosted database on web
- User can create, delete, modify tables by himself via API
- User can manage at least 5 tables

Thank you for help in advance.

Andrea

SteveJG

unread,
Nov 19, 2017, 4:08:54 PM11/19/17
to MIT App Inventor Forum
There is no simple alternative to a FusionTable  if the user must create the database online using an AI app and the database must be 'free '


Try the Experimental FirebaseDB    https://docs.google.com/document/d/17OGJF8VwbOYkXCual8I1JIBLCHhnCcgHj6N_Cfnlb4A/edit#heading=h.37rrxtruvui0   . The  FirebaseDB is an online noSQL database.  Firebase works similar to how a TinyDB works on the device itself.  That means there is no SQL capability; the developer must write with blocks the routines needed to manipulate, sort, find and otherwise change the data.  Store and retrieve information as JSON Lists.  Is it easy?  No, it involves a lot of programming.

Alternatively, stay with a FusionTable.   Perhaps the ultimate user creates their FusionTable  with their PC  https://support.google.com/fusiontables/answer/2571232?hl=en .  Once the table is created, the app user can access and manipulate the Table from the App once the table ID is placed in the app possibly using a TinyDB to remember the table id.  The user(s)  can create as many FusionTables as they want and, it you program the routines, manipulate it from your app.  Creating a FusionTable from the App Inventor app, even if it could be done, would be very awkward compared to creating the table using the Google FusionTable site.

Regards,
Steve

Abraham Getzler

unread,
Nov 19, 2017, 5:57:21 PM11/19/17
to MIT App Inventor Forum
Here's a link to how Fusion Tables work internally,
if you want to build your own ...

Abg

Blacktea

unread,
Nov 20, 2017, 12:13:01 PM11/20/17
to MIT App Inventor Forum
Thank you all for answers. I think i will use Fusion Tables without creating tables from app.
I will follow what SteveJG said ... at the moment user will have to create the table from pc and manage it from app.
Hope that Google will simplify the use of Fusion Tables for us users ... i think Fusion Tables is too complicated to use even if you do not share the tables.

Let's see if they will surprise us :-)

Andrea
Reply all
Reply to author
Forward
0 new messages