PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV Mobile 2024 → Which is best to use HFSQL or SQLite in Android apk?
Which is best to use HFSQL or SQLite in Android apk?
Iniciado por Indic Software, set., 28 2014 4:03 PM - 3 respostas
#1
Publicado em setembro, 28 2014 - 4:03 PM
In an application that I need to develop there is a need to download a data from internet and store all master data (not updated frequently) locally and load other data (updated frequently) from remote database. I am using Php4WM to access data remotely and it is working well.

What I need to know it what is better to store data locally on an Android device - HFSQL or SQLite?

Please advise.

Thanks,

Indic
#2
Publicado em setembro, 29 2014 - 11:46 AM
Hi

there is no definitive answer...

HF will limit you to devices with android version 3.x and higher,
sqllite will not.

HF will increase the size of your apk by quite a few MB..

SQLLite will force you to code some alter table statements each time you
modify your analysis, HF support hmodifystructure.

If any of these statements is a show stopper for you, then you have your
answer, otherwise, you can choose whatever you prefer

Best regards


--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International

NOUVEAU: WXReplication, votre système de réplication open source est
disponible sur mon site web !!!
WXShowroom.com : Montrez vos projets !
Plus d'information sur http://fabriceharari.com

On 9/28/2014 8:03 AM, Indic Software wrote:
In an application that I need to develop there is a need to download a
data from internet and store all master data (not updated frequently)
locally and load other data (updated frequently) from remote database. I
am using Php4WM to access data remotely and it is working well.

What I need to know it what is better to store data locally on an
Android device - HFSQL or SQLite?

Please advise.

Thanks,

Indic
#3
Publicado em outubro, 01 2014 - 1:17 PM
So I take it that both will perform well on large database with around 40k rows in more than one table.

Are there any instance where there have been corruption in HFSQL data files due to size?

Thanks,

Indic
#4
Publicado em outubro, 01 2014 - 3:24 PM
Hi again


On 10/1/2014 5:17 AM, Indic Software wrote:
So I take it that both will perform well on large database with around
40k rows in more than one table.


BIG databases on android may not be very fast, no matter the DB you
choose. It all depends of course of what you are doing on the database.


Are there any instance where there have been corruption in HFSQL data
files due to size?

No

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

NEW: WXReplication, your open source replication system is available on
my web site!!!
WXShowroom.com: Show your projects!
More information on http://www.fabriceharari.com

Thanks,

Indic
→ Voltar para WINDEV Mobile 2024