Ok now I'm really confused. Both of you guys are saying opposite things lol. I read some stuff on the internet, all of them are saying SQLLite is a very robust database engine. Also, here's a
link to the sqlite website. They claim that it is capable of handling small to medium sized websites, embedded applications and
desktop applications such as financial analysis tools, CAD packages, record keeping programs, and so forth.
rolf wroteIf you go the WAMP way, and need an installer, let me know.
I am currently developing an installer for a WAMP-type application, and I'm working on update functionality.
Another interesting technology for such cases, is Mozilla-PHP, still somewhat experimental but the idea is that you would integrate php into mozilla, without needing apache, which allows you to have a single package containing the browser and php. and distribute that as an application.
Actually the use of PHP appeals to me. I just wish there's an alternative to installing WAMP manually and going through all of this hassle. But if I had to, then I'll go for it. The thing is, I'm new to AIR which is basically very similar to Flex (which I'm very familiar with) but is packed inside an installer file and deployed locally. There are also classes which are exclusive to AIR which allow it to interact with databases using SQL syntax. It works like a charm. The best part of it is that it works across platforms, you wouldn't have to worry about Linux or Windows or Mac... etc. But anyway, what exactly does your installer do? I'm interested to know...
rahmu wroteNow that I think of it, what your relative is asking for is an ERP system. It is going to be hell to develop, and there are some open source ones available that will do the trick.
I do not think an ERP system is what I should build... I just want a small sized system that does the job. All it needs to do is the following:
- Maintain the stock when a sale is made or upon new data entries.
- It should be able to keep track of the sales, orders, invoices, profit/loss.
- Basic records of clients and suppliers
Yeah I guess that's all about it... I do not need any charting or financial analysis/projection capabilities. Stock management is the core functionality of the application. The others are only "add-ons" or enhancements. I would like to build it myself for the experience purpose. I'm not even going to charge him for it. :)