SQL Database first Data's

#1 · June 27, 2021, 3:26 pm

Hi to all,

I would like to made a Migraine dB App for Windows.

Now my first problem, the Medical List are change always.

I found to download but extracted to the xml File are over 1GB space.

In to the SQLite some 100MB.

My Question now, how to solve something really easy also to the User.

Second question, how about if the User delete the first SQLite dB. (Originally SQLite dB)

Idea, to copy from AppData to the effective dB destination if the "User dB" is delete. (Document Folder or else App Folder)

third question how about update the dB, like a Query Script or else a NEW SQLite dB ?

So i can reduce the Space over web and on the Disk before the UpDate.

Thanks for any Input to solve my little problems

Kind regards

Christian

#2 · June 28, 2021, 7:22 pm

Perhaps this post will be useful.

take a look of this:

my 0.01,

David de Argentina

Christian Schaer has reacted to this post.

#3 · June 28, 2021, 11:46 pm

Thanks to your Post, possible to find this ZIP File anywhere ?

The Links on the Archiv Page are no longer valid.

Very nice to test it.

Kind regards

Christian

#4 · June 29, 2021, 12:10 am

Hi Christian,

here is the attached zip

note there are a file called Sample.db3, that has 10000 rows and a simple query is executed at 0.2 secs

tell me if the system is working for you,

Greeting from Buenos Aires,

David de Argentina

Uploaded files:

emo has reacted to this post.

SQL Database first Data's - Forum