Wich database do you use

[Wingens]

I want to create a program/script wich uses a database to store it's data.

Now I am puzzeled by wich database server/type I should use.

 

Can you guys help me?

 

The program/script I want to create is used for multiple computers, where the insert data en read/modify it afterwords.
There is going to be adding files to a share and the links as data in de database.

[Earthshine]

i know a lot of people that like sqlite

you have to write your own code though. We can help you, but first you have to help yourself. and it's not wich, it's which. I've noticed this a lot on forums lately.... sigh

Edited September 24, 2018 by Earthshine

[Wingens]

sqlite ok, I will look into that one.

Thank you and off course I will write my own code first if I get stuck I will ask for help.

Sorry for my grammar error, my native language is Dutch. Will try to remember which instead of wich.

[Earthshine]

no worries, i figured. it's the english speaking folks I see it from most, and it really concerns and saddens me. What are they teaching the US kids? you should see the spelling atrocities, yours is like awesome by comparison, I just wanted you to know the correct word.

 

so, with sqlite, get both the 32 and 64 bit downloads, because if you do a script in 32 I think you need the 32 bit dll and 64 bit dll for 64 bit autoit scripts

Edited September 24, 2018 by Earthshine

[jchd]

I second that about both which (albeit I'm French) and SQLite (I'm big fan).

Just a note: SQLite is an embedded RDBMS, not a client-server design. You could possibly hit some issues if your context implies a serious load under multiple concurrent accesses over a network. This is due to remote file locking bugs in almost all common OSses.

What you can do if your expected write concurrency is only minimal is develop your application using SQLite which is very easy to install (it's just one DLL) and debug things. Try it in real context and if you experience some problems you can switch to Postgres which is essentially compatible from the SQL point of view.

If you have little experience with SQL I can guide you somehow to design the DB and the queries you need.

As a first step, download and install a 3rd-party SQLite manager (I warmly recommend SQLite Expert personal edition). It allows you to create/fine tune your DB and run queries without having to write any extra code. Once the design is settled and queries run satisfactorily, start developping code.