Databases in AMS?

[n00bz]

hello,

I want to make a basic phonebook with AMS, is that possible? I want to get data with inputs an save them in to a file. Then I want to seach in my "database" for datas and show them. I have a bit mysql expirience, but i want to use an offline database or a text file etc.

A mysql query like like this, how can i do it with AMS? Can i use something else then mysql?


mysql_db_connect("localhost","username","pwd");
mysql_select_db("my_database");

mysql_query("SELECT * FROM foobar...");
or
mysql_query("INSERT INTO foobar...");
)

thanks

PS: I know my english rox :-P

[playmenow]

You can use the SQLite tabase or XML files or anything you want.

[n00bz]

thanks i will try

[TJS]

Here's an example that other users of this forum have worrked up...

http://www.indigorose.com/forums/showthread.php?t=11869&highlight=sqlite+phone

[n00bz]

looks really interesting..I will download it now.


thanks

[Roboblue]

If you have a lot (or just big) of vid-audio-image files, building to an exe may cause performance issues as the whole exe will have to be unzip to a temp folder. I have a decent system and 80-90MB is about all I can stand at runtime.
You can encrypt them, but they will have to be unencrypted to a temp folder and are accessible as long as the project is open, or you call a file delete action in the script. Same with passworded Zip actions.
Renaming the resource (AutoPlay folder) will hide them, but they are still accessible if the user knows how it's done.
You can only make it difficult for a leech to get the files, but you won't stop everyone.
I kinda figure that if someone is going to the trouble above to get my stuff, then I've made a decent application.

[bobbie]

You have to look at the Mysql database as a lot of the servers will not let you connect from outside of the localhost.

[bule]

Yeah.

An there is a guide to connect to an online MYSQL server from APMS somewhere on this board!

[n00bz]

@ Roboblue

My project are only 20-30 MB I think it not matter.
Yes you right, its not a good idea to hide them, because the people can still access them.

@ bobbie, bule

To connect mysql with AMS is not a good idea, because everybody can read the config files and can connect to the database. Thats why I want to use an offline database. SQLite looks interesting, but a bit complex. I need a bit more expirience..

[bule]

Well it's not that complex. It's actually very simple once you get your hands on it. It helps making your application much simpler and cleaner.

[Roboblue]

It's kinda confusing at first, but not as complex as Mysql (hence the name SQLite). I have been using AMS since Version 3 (back in 96-97, I believe) and have always used text files for hard data storage for AMS. Now, I use SQLite for everything.

[bule]

Now, I use SQLite for everything.

True. Except for some minor settings which .ini handles just fine.

[likbez]

It's kinda confusing at first, but not as complex as Mysql (hence the name SQLite). I have been using AMS since Version 3 (back in 96-97, I believe) and have always used text files for hard data storage for AMS. Now, I use SQLite for everything.

what about cyrillic support in that plugin? We are already tired to sort out this question. Could you advise the way how to use it?

[Sakuya]

I prefer JavaScript Object Notation (http://www.indigorose.com/forums/showthread.php?t=27910) but I wouldn't use it for a database.