SQLite or other Database

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

SQLite or other Database

Postby aziziti » Mon Apr 27, 2009 6:22 pm

Hi everyone, I am new to Android and I have many questions.
I am currently developing an application of social network with geolocation.
Certainly, it would create a database to contain information about a user (personal information) and information about groups, events, etc..
I checked some documents and I found that the database SqlLite is a database for some data and it will be saved in the device. So should I use an other database?

I hope I was clear. And thank you in advance.
aziziti
Freshman
Freshman
 
Posts: 8
Joined: Mon Apr 27, 2009 4:30 pm

Top

Postby nmc » Mon Apr 27, 2009 7:35 pm

depends on what you want to do... 8)

I use sqlite databases with 50.000 - 100.000 entries in 20+ tables, stored on sd-card for easy syncing with the pc.

The engine works stable and very fast with this amount of data (using insert/update/delete/select operations [including join/union]).

So if your concern was about "some data" (but noch too much) or about "in the device" (but not on external media), then just ignore those comments and enjoy sqlite :)
nmc
Senior Developer
Senior Developer
 
Posts: 154
Joined: Thu Nov 27, 2008 8:30 pm
Location: Germany

Postby aziziti » Mon Apr 27, 2009 7:44 pm

Thanks nmc for the reply.
Actually, my concern is about an external database. :(
aziziti
Freshman
Freshman
 
Posts: 8
Joined: Mon Apr 27, 2009 4:30 pm

Postby WarrenFaith » Mon Apr 27, 2009 8:31 pm

Than you should think about Client-Server-Architecture... but if you need a lot of database action, you should think about the local sqlite
WarrenFaith
Moderator
Moderator
 
Posts: 227
Joined: Fri Mar 13, 2009 10:59 am
Location: Berlin, Germany

Postby aziziti » Sat May 09, 2009 11:22 pm

Thanks a lot guys!!!
aziziti
Freshman
Freshman
 
Posts: 8
Joined: Mon Apr 27, 2009 4:30 pm

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: Google [Bot] and 2 guests