[android-developers] sqllite database with data
I want to develope an android aplication with sqllite database. and I want to prepare database with data before publising. is it possible? How can I do it? -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Yes, it is possible. You have to keep the database in the asset folder of your application. Then copy the db to application directory. If you google out you view many samples for this Reference http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/ Regards, Jovish On Sat, Dec 1, 2012 at 5:28 PM, Salih Gündüz gunduz.sa...@gmail.com wrote: I want to develope an android aplication with sqllite database. and I want to prepare database with data before publising. is it possible? How can I do it? -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Their is possible to do it.But it is supported only CRUD operations ,light weight database and it is local for single user. If you are maintain single database(common for every one)for all user you will maintain server and you can use web services in android project.(Here Client and Server relation). -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.comwrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Either you will create a custom .slite db and add it to your assets and on the first install you will copy it (programmatically) to a new SQLite Database, or you will use web services and download the sqlite content only once, or when the text is updated. It is pretty easy and fast. On Sat, Dec 1, 2012 at 3:01 PM, Salih Gündüz gunduz.sa...@gmail.com wrote: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.comwrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
I'm developping an app where I need it too. It's a basic quotes app, so it has two tables: quotes and authors. What I did: created two xml with the data and, when I create the database, I read the xml and populate it. Just simple. Now I have to discover some way to discover if the app was updated and, then, delete and recreate the database. ;-) Best regards. Em 01/12/2012 11:08, Salih Gündüz gunduz.sa...@gmail.com escreveu: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.comwrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
thank you very much ;) On Sat, Dec 1, 2012 at 4:17 PM, Παύλος-Πέτρος Τουρνάρης p.tourna...@gmail.com wrote: Either you will create a custom .slite db and add it to your assets and on the first install you will copy it (programmatically) to a new SQLite Database, or you will use web services and download the sqlite content only once, or when the text is updated. It is pretty easy and fast. On Sat, Dec 1, 2012 at 3:01 PM, Salih Gündüz gunduz.sa...@gmail.comwrote: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.com wrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Something I forgot: there are two xml with the data for each language, of course. And, for now, it's only Portuguese and English. Em 01/12/2012 12:20, Mário César Mancinelli de Araújo mandaproma...@gmail.com escreveu: I'm developping an app where I need it too. It's a basic quotes app, so it has two tables: quotes and authors. What I did: created two xml with the data and, when I create the database, I read the xml and populate it. Just simple. Now I have to discover some way to discover if the app was updated and, then, delete and recreate the database. ;-) Best regards. Em 01/12/2012 11:08, Salih Gündüz gunduz.sa...@gmail.com escreveu: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.com wrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Mario check this out. String versionName = getPackageManager(). getPackageInfo(getPackageName(), 0).versionName; You will programmatically check for the equality of this and an old one that you have saved either using sharedpreferences or any other way you would like. On Sat, Dec 1, 2012 at 4:22 PM, Mário César Mancinelli de Araújo mandaproma...@gmail.com wrote: Something I forgot: there are two xml with the data for each language, of course. And, for now, it's only Portuguese and English. Em 01/12/2012 12:20, Mário César Mancinelli de Araújo mandaproma...@gmail.com escreveu: I'm developping an app where I need it too. It's a basic quotes app, so it has two tables: quotes and authors. What I did: created two xml with the data and, when I create the database, I read the xml and populate it. Just simple. Now I have to discover some way to discover if the app was updated and, then, delete and recreate the database. ;-) Best regards. Em 01/12/2012 11:08, Salih Gündüz gunduz.sa...@gmail.com escreveu: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.com wrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] sqllite database with data
Thanks, man! It will do the job. :-D Best regards, Mario Cesar M. de Araujo Em 01/12/2012 12:30, Παύλος-Πέτρος Τουρνάρης p.tourna...@gmail.com escreveu: Mario check this out. String versionName = getPackageManager(). getPackageInfo(getPackageName(), 0).versionName; You will programmatically check for the equality of this and an old one that you have saved either using sharedpreferences or any other way you would like. On Sat, Dec 1, 2012 at 4:22 PM, Mário César Mancinelli de Araújo mandaproma...@gmail.com wrote: Something I forgot: there are two xml with the data for each language, of course. And, for now, it's only Portuguese and English. Em 01/12/2012 12:20, Mário César Mancinelli de Araújo mandaproma...@gmail.com escreveu: I'm developping an app where I need it too. It's a basic quotes app, so it has two tables: quotes and authors. What I did: created two xml with the data and, when I create the database, I read the xml and populate it. Just simple. Now I have to discover some way to discover if the app was updated and, then, delete and recreate the database. ;-) Best regards. Em 01/12/2012 11:08, Salih Gündüz gunduz.sa...@gmail.com escreveu: Web service is a good solution.But I want user can read the text when they are offline. My apllication will show some text and user can search in this text. On Sat, Dec 1, 2012 at 2:11 PM, sree android android.sreeni...@gmail.com wrote: will maintain server -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] SqlLite Database
How can one go about creating an SQLLite Database on a PC then to transfer the database file to the tablet's application data directory? I have managed to create a database on a tablet copy it off, and then back on. But Now I would like to be able to create it and then just upload it. Also what are the differences between MySQL files and SqlLite files Thanks in advance -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] Sqllite database join query
Hi, I already use getContentResolver().query(uri, null, null, null, null) to do a query. What if I have two databases, and I want to do one query on two databases and get one data set back? Thanks. -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
[android-developers] SQLlite database
I was just trying to make a SQL lite database in Android, I will show you my first try... SQLiteDatabase database = SQLiteDatabase.create(null); database.execSQL(CREATE TABLE gps(longtitude Char(50),latitude Char (50))); database.execSQL(INSERT INTO gps(54.555, 54.544)); database.execSQL(SELECT * FROM gps); String[] kolommen = {longtitude, latitude}; Cursor data = database.query(gps, kolommen, null, null, null, null, null); Log.i(result, data.getColumnNames().toString()); But it isn't working... is there anyone who can say what I'm doing wrong? -- You received this message because you are subscribed to the Google Groups Android Developers group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en