What database? what methods?

[ciginfo]

Hello,
I have to make an app that recency several interest points in a region. These points of interest are referenced by their name, address, GPS coordinates and photographs.
These references are updated in a database on a server, then my app has to load the database and use it with SQL.
Questions:
1) What is the format of the database more suitable for use on the server side? (CSV, Acces, Excel, SQL?)
2) What method to download the database from the server to the application in the device.
3) What method to convert the database to be usable by SQLLite
Thank you

 

[Informatix]

Hello,
I have to make an app that recency several interest points in a region. These points of interest are referenced by their name, address, GPS coordinates and photographs.
These references are updated in a database on a server, then my app has to load the database and use it with SQL.
Questions:
1) What is the format of the database more suitable for use on the server side? (CSV, Acces, Excel, SQL?)
2) What method to download the database from the server to the application in the device.
3) What method to convert the database to be usable by SQLLite
Thank you

1) XML, JSON, SQL DDL or a SQlite database. Zipped on the server to reduce the downloading time.
2) HTTPUtils2
3) If the downloaded file is a SQLite DB, you have nothing to convert. It depends on how many data you want to transfer (a full database? a delta of a few records?)

 

[ciginfo]

Than you. I do'nt know how to unzip. Is there a method with B4A?
And If I use XML or CSV how can I convert to SQL?

 

[Informatix]

Than you. I do'nt know how to unzip. Is there a method with B4A?
And If I use XML or CSV how can I convert to SQL?

Forget CSV. This format is deprecated.
To unzip: Archiver library.
To parse a XML file: XMLSax library (standard).

 

[ciginfo]

With XLMSax I think I cannot easyly sort elements from XLM file as SQL. For example I think I cannot use "order by". I have to convert XLM File to SQl and I don't Know how to do this.

 

[Informatix]

With XLMSax I think I cannot easyly sort elements from XLM file as SQL. For example I think I cannot use "order by". I have to convert XLM File to SQl and I don't Know how to do this.

Please explain what you're trying to do. That will be easier to answer you.
Do you transfer all data every time? Do you want to update or replace an existing database?

 

[ciginfo]

I have to make an app that recency several interest points in a region. These points of interest are referenced by their name, address, GPS coordinates and photo.
The user of the application must know the points of interest near his location. the points of interest are to be sorted according to their latitude and longitude and I can do with SQL. The database must be updated regularly.
I have a bad english, it is difficult for me to explain. Do you understand?

 

[Erel]

This tutorial might be relevant: Connect Android to MySQL Database Tutorial

 

[Informatix]

I have to make an app that recency several interest points in a region. These points of interest are referenced by their name, address, GPS coordinates and photo.
The user of the application must know the points of interest near his location. the points of interest are to be sorted according to their latitude and longitude and I can do with SQL. The database must be updated regularly.
I have a bad english, it is difficult for me to explain. Do you understand?

I already read that in your first post.
I asked you three questions (post #2 and #6) and still wait for answers. Let me be more precise:
What do you have on your server (an existing database? an existing software to manage your data?) ?
What volume of data are you going to transfer (a full database? only a few records? what size for the data? what type?) ?
What do you want to do on the client side: replacing the user DB? updating it?

 

[ciginfo]

1°) What do you have on your server (an existing database? an existing software to manage your data?) ?
2°) What volume of data are you going to transfer (a full database? only a few records? what size for the data? what type?) ?
3°)What do you want to do on the client side: replacing the user DB? updating it?

1°) I still have not database, I search the best format to create one. No matter to manage it.
2°) Few records probably. Five or six fields per record.
3°) No, just extract data from particular field, sort in a particular order and type of fields (ex by latitude and longitude) and display them in a listview.

 

[Informatix]

1°) I still have not database, I search the best format to create one. No matter to manage it.
2°) Few records probably. Five or six fields per record.
3°) No, just extract data from particular field, sort in a particular order and type of fields (ex by latitude and longitude) and display them in a listview.

1) So you have the choice. Examples of free DBMS: MySQL, SQLite, PostgreSQL, SQL Server Express...

2) You can transmit either the data (XML, JSON) or a SQL command (DML) to update the data (XML or JSON). Your choice depends on what you're going to build on the server side. Are you going to extract the data with a custom tool, a PHP script, a DB function?

3) You update the user database, then you sort the data before querying them for display. The update is done with the contents of the transmitted file.

The link given by Erel is relevant in your case.