Search the Community
Showing results for tags 'mysql sqlite'.
-
Hi, I have no experience in databases at all. I will use a free web hosting service (I dont know if I can place the link, readed the forum's rules, but better to ask first. I will link it if it's needed and allowed). The host support mysql and sqlite. To manage mysql, the host include the phpMyAdmin tool (I have no experience in PHP neither. As far as I understand, I will not need to learn it, since the UDF will handle the database, but if it's needed, I will try to learn it). I didn't find a native tool on the server to manage the sqlite. I'm trying to build a client for 5-10 users with autoit, the client need to read and write the database. Looking in the forum, I found this UDF for mysql '?do=embed' frameborder='0' data-embedContent>> I don't need to create tables or fields with the client, I did that with the tools of the server, I just need to read and rewrite the values inside the table. My questions are: 1) The UDF SQLite included with autoit can use a file when the file is on the server? (with mysqludf I see its designed to make a connection to a database on a server, but reading the sqlite udf functions , it looks like it open a local file) 2) If the SQLite database need to be on local machine so the udf works, it's good idea (and possible) to download the file from the server, rewrite it, and upload it again? 3) Should I use the mysqludf to avoid those problems, or simply im missunderstanding how the databases really work? 4) Any advise for a database begginer? If something have no sense, let me know, since my english can be horrible. THANKS