database server client application help needed

hi all,
been a really long time since i last touched mmf2 dev.
so i'm really out of touch with all the lastest extensions.
last actively used extensions were: mooclick & moogame.
advice, examples & recommendations greatly appreciated.

so here's what i want to create:

some form of database server at HQ that keeps track of stocks available to branch employees who login with a user name/password thru some form of client application at the branch office.

thought of using mooclick of which i'm familiar with, but have no bloody idea on how to setup the database part on the server side.

after doing much browsing thru recent posts, found new objects mentioned like lacewing, is it better than mooclick?

any input greatly appreciated, cheers!

The Moo extensions are outdated, buggy as heck, and not supported anymore.

The new extension that's being developed to replace it is called Lacewing and has all the same features, and more. It's much better ;)

For the database part, you could use any one of the numerous objects that can handle and save/load data. Which one you use depends on your needs and wants. ;)

hi LB,
thks for the update.
:blush:
the only object that i'm familiar with is INI.
but i truly doubt that it's reliable enough for the job.
so, any good recommendation?

Well, there's INI++.

But really, we'd need to know what you need to store and how you intend to handle this information in order to tell you the closest matching object for your needs. ;)

hi LB,
thks again for the fast reply.

basically; i distribute pc parts (processors, ram, etc)
so i want my branches & dealers to be able to keep track of existing stocks & daily confidential dealer prices.

OK, but how does that information need to be stored? Think how you keep track of it currently and then think how you can sue one of the data storage objects like INI++ or Array object to store it. EG think of if there needs to be categories or sub categories, and what information needs to be held.

hi LB,
thks again for the speedy reply,
truly grateful for your sincere help.

example:

main category = processor (clickable button)
sub category A = intel (clickable button)
sub category B = amd (clickable button)

sub category A/B = models with number of stocks & pricing within a boxed listing excel style.

I reckon MySQL Would come in handy for storing the data. And there's an extension for mmf2 for MySQL.
As for the application, should be fairly easy to create :D

hi Jase,
thanks for the input.
mind directing me to the MySQL extension?

cheers

I'd highly recommend MySQL, very fast and can store millions of data easy.

You need to know the commands though to use it.

There are lots of sites with command references, heres one:

webpage

Check the released extension forum for the sql objects, i think there are a few of them.

There is also a SQL Server object that works with Microsoft SQL Server and Microsoft SQL Server Express (free).

Here is the link to the SQL Server object (made by forum user byo):
SQL Server

Another really cool object is the SQLite3 object (also made by byo) that doesn't require an external database engine. Works great!
SQLite 3 for MMF2 Developer
SQLite3 for regular MMF2