Can I write to a database?

[omar]

Can I write to a database everytime I run some code?
Like on a website?
How about locally? I can't think of how this could be done.

I have some code. Everytime it's used, it appends some information at the end of a file.
Today the code ran and the damn file got corrupted.
I feel like crying. I didn't have a backup.

For the writing part, I used some ready made AHK code - I was told that this would be more robust.
Something went wrong. Wrong data was received. The data is a CSV file. The first column got wiped out.
I just can't believe it.

Assuming writing to a DB will be more secure?

Thanks.

[swagfag]

https://github.com/AHK-just-me/Class_SQLiteDB

[AHKStudent]

Can I write to a database everytime I run some code?
Like on a website?
How about locally? I can't think of how this could be done.

I have some code. Everytime it's used, it appends some information at the end of a file.
Today the code ran and the damn file got corrupted.
I feel like crying. I didn't have a backup.

For the writing part, I used some ready made AHK code - I was told that this would be more robust.
Something went wrong. Wrong data was received. The data is a CSV file. The first column got wiped out.
I just can't believe it.

Assuming writing to a DB will be more secure?

Thanks.

backup often to the cloud, databases get corrupted too

[gwarble]

Try opening your now corrupt file with a hex editor, might not all be gone

[Gio]

Can I write to a database everytime I run some code?
Like on a website?
How about locally? I can't think of how this could be done.

Yes, you can. I have been using ADOSQL() by VxE for a long time now to run a multi-user multi-instance logistics system. The DataBase is SQLServer. No big problems thus far.

Assuming writing to a DB will be more secure?

Yes, it is (most of the time). I never had any problems such as the ones you mentioned with my SQL Server DataBase. However, a regular backup is always a plus.