search

niteshmourya / app-inventor-for-android

Automatically exported from code.google.com/p/app-inventor-for-android
Apache License 2.0
2 stars 0 forks source link

Support for 'SQLiteDatabase' type of structures #39

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently tinyDB only supports storage of field or column. Can AI support more 
complex database, functions and queries to support more wholly SQLiteDatabases.

Original issue reported on code.google.com by Gemeniano on 10 Sep 2010 at 5:06

GoogleCodeExporter commented 9 years ago 
That would be much better then my current hack using tinywebdb + PHP + MySQL 
given the database is remote.

I would love a local SQLiteDatabase.

Original comment by shivalw...@gmail.com on 10 Sep 2010 at 8:52

GoogleCodeExporter commented 9 years ago 
i agree with this.
but let do step by step.
let the most important feature in first.
example:
1. table creation
2. 3 data type, string, numeric and date
3. able to download and upload the table.

Original comment by tripleze...@gmail.com on 21 Sep 2010 at 1:50

GoogleCodeExporter commented 9 years ago 
The current lack of SQLite support is the one reason why I will eventually have 
to port my app to Java (==hell). I suppose this applies to virtually any 
data-centric application.
I believe the Blocks Editor is already very well positioned to provide the kind 
of query wizard MS Access or OpenOffice Base have.

Original comment by maxporta...@gmail.com on 24 Sep 2010 at 3:07

GoogleCodeExporter commented 9 years ago 
Would be very nice to SELECT from every local SQLite database on the phone (in 
/data/data). And to SELECT/UPDATE/INSERT into a own SQLlite database.

Original comment by bastiaa...@gmail.com on 28 Sep 2010 at 9:57

GoogleCodeExporter commented 9 years ago 
We'll consider this.

Original comment by sha...@google.com on 7 Oct 2010 at 9:16

GoogleCodeExporter commented 9 years ago 
Thanks for the consideration! I look forward to teaching the kids about 
programming, but being able to add basic Database concepts to the program will 
enable the kids to do some amazing things...who knows where the kids will take 
the Android platform!

Original comment by manny.m...@gmail.com on 7 Oct 2010 at 10:22

GoogleCodeExporter commented 9 years ago 
Database support, together with indirect adressing (request 197) would allow 
for dynamically composed SQL statements. That would keep the kids off the 
street indefinately...

Original comment by Geert.Sn...@gmail.com on 9 Dec 2010 at 10:52

GoogleCodeExporter commented 9 years ago 
This would be so helpful to create both offline and online apps. Most commonly 
when field collectors while capturing data may be in bad signal areas without 
internet, ability to store lot of that information locally into a sqllite 
database would be so useful.

Original comment by ditt...@gmail.com on 18 Jan 2011 at 1:29

GoogleCodeExporter commented 9 years ago 
Having this feature would be great!

Original comment by Flippi...@gmail.com on 19 Jan 2011 at 1:20

GoogleCodeExporter commented 9 years ago 
If we got SQLLite I would hope we could get access any DBs on the phone like 
the Bookmark db.

sqlite3 /data/data/com.android.browser/databases/browser.db "SELECT * FROM 
bookmarks;"

I've requested a BookmarkPicker feature as well #1232 but no apparent interest 
in this.

Original comment by cyberp...@gmail.com on 17 Feb 2011 at 12:46

GoogleCodeExporter commented 9 years ago 
I really hope to see something like this happen, maybe as how it was described 
in comment two above.

Original comment by davidmca...@gmail.com on 28 Feb 2011 at 5:47

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
I'd like to see support for SQlite in general. 
We all know that the push for cloud based computing is up on the rise, but 
let's face it. Not every one has access to the net all the time. The ability to 
store data to a local database and access it later is a must. If not for 
performance reasons, then security.

Original comment by nathan.F...@gmail.com on 13 Apr 2011 at 3:22

GoogleCodeExporter commented 9 years ago 
I'm looking forward to see SQLite support, without it this tool is useless for 
me.

Original comment by arthur.k...@gmail.com on 28 Apr 2011 at 12:12

GoogleCodeExporter commented 9 years ago 
I'm looking forward for a database support.  So I can do away with the paper 
strips I use to randomly ask my students questions.  I'll just put all the 
questions with the corresponding answers in the database.  Voila!

Original comment by eleanorc...@gmail.com on 8 Jun 2011 at 7:06

GoogleCodeExporter commented 9 years ago 
I'm looking forward to see SQLite support...

Original comment by plinio.s...@gmail.com on 9 Jun 2011 at 1:22

GoogleCodeExporter commented 9 years ago 
Any news on the SQLite feature for App Inventor ??? Thanks

Original comment by fx2...@gmail.com on 20 Jul 2011 at 10:31

GoogleCodeExporter commented 9 years ago 
I'd love to see appinventor supporting sqlite.

Original comment by frango...@gmail.com on 20 Aug 2011 at 2:11

GoogleCodeExporter commented 9 years ago 
I too feel that lack of SQLite support is a great impediment to AI

Original comment by fleminga...@gmail.com on 9 Sep 2011 at 4:23

GoogleCodeExporter commented 9 years ago 
Dear Google, we need a solution for this.

Original comment by moust...@banbouk.com on 12 Dec 2011 at 7:41

GoogleCodeExporter commented 9 years ago 
Please add sqlite support.

Original comment by brucetho...@gmail.com on 3 May 2012 at 3:51

GoogleCodeExporter commented 9 years ago 
I hope to see a sqlite support...

Original comment by nicolape...@gmail.com on 18 Sep 2012 at 11:02

GoogleCodeExporter commented 9 years ago 
Please add sql support

Original comment by ronnielu...@gmail.com on 25 Sep 2012 at 3:11

GoogleCodeExporter commented 9 years ago 
Dear MIT, close this huge hole in AI design - please, ADD SQLITE component ASAP.

Original comment by frederic...@gmail.com on 18 Oct 2012 at 9:11

GoogleCodeExporter commented 9 years ago 
Dear MIT, close this huge hole in AI design - please, ADD SQLITE component ASAP.

Original comment by frederic...@gmail.com on 18 Oct 2012 at 9:11

GoogleCodeExporter commented 9 years ago 
Hi all,

the final open source announcement was done today, please have a look at:
https://groups.google.com/group/app-inventor-announcements/browse_thread/thread/
955f0041db1bce7d

Anyone should be able to add a sqlite component now.

Enjoy!

Original comment by josmasfl...@gmail.com on 22 Oct 2012 at 6:49

GoogleCodeExporter commented 9 years ago 
In the App Inventor Open Source Group Hossein presented his very nice SQLite 
enhancement for App Inventor, which offers access to the local SQLite database 
on Android devices for App Inventor apps.

However, it has been said: the primary target audience for App Inventor are 
people with little or no programming experience. And let me add something to 
make that a little bit clearer: there is no secondary target audience!
Which means, Hossein's SQLite enhancement in its current form will never make 
it into MIT App Inventor.

Therefore I now invented the SQLite helper app, which enables App Inventor apps 
to access the local SQLite database using the Activity Starter. This helps App 
Inventor projects to use a relational database with all its advantages (where 
clause, group by, order by, references between tables just to name a few) 
without need to have internet access!

see here http://puravidaapps.com/sqlite.php
Taifun

Original comment by taifunb...@gmail.com on 22 May 2013 at 5:34

GoogleCodeExporter commented 9 years ago 
One question, (sorry for my English), is very interesting SQLite application, 
I've tried but would like to know where I can find the part database is created 
where in the android directory is created the same. Thanks for your help.
Andres

Original comment by ayep...@gmail.com on 29 May 2013 at 2:39