First I want to thank everyone for the input and thoughts! Bounaberdi. As to your question of "-what would be the benefits you can see in using postgresql/python in this part too ?" The answer is, at the beginning of the Micro Computer Revolution, I managed to build my own Software and Hardware House. We wrote everything in Basic, and we built our own Database Management System. I have been out of the computer world for about 15 or years now, and I am learning my way back, but everything has changed. We have GUI's and all kinds of wonderful stuff today that we didn't have then, but I want to build a business by programming the applicable portions of this new creation I have in mind between existing applications. To do this, I only want to learn one language, one database, one operating system, one server, etc. I don't want to waste time duplicating learning time in different languages, etc, instead of increasing my specialization investment in a single language or database, etc. skill. So, I sat down and studied this new world over looking for things familiar to me from my knowledge of trends and what did and did not work, and thus, using my experience of the past to help me decide where to put my TIME INVESTMENT in learning the tools I would use. I decided to learn Linux, thus a linux webserver will be used. Similarly, after researching different programming languages, while Ruby looked promising, I decided to put my money on the Python horse for winning the future, and again, also, I decided that PostgresQL was much more reliable and safer to use than MySQL and had many design advantages over the same. Now, another element of the equation is, I want to be able to be the only person employed by my business, and that means I need to be able and skilled enough to do all the things necessary to build and maintain my business from a computer stand point. Now, since existing applications are only a part of the software I need for this business, to me, that means one language, one database, one operating system. Now, obviously, I don't want to write the Accounting or Shopping Cart applications since they already exist, but if they are written in "my" specialization language, I have more security in being able to make any changes or additions or fixes or in stitching the two applications together and to my own programmed application. One never knows what they need for sure in the programming game until they are hip deep in things, and at that point, knowing the language of the apps one is using, has just got to give one the best advantage toward being able to complete what one started, and also be able to implement the best solution. So, while I am looking to pull this off as easily as possible, with as little programming and splicing as possible, and to get into business as soon as possible, I am also looking to give myself the best skills position if I have to go under the hood, while spending as little time in developing skills as possible. As to why not have MySql and PostgresQL on the same computer, I am sure one can, but one would have to remember the differences in programming around them, and probably within the same operations, but, beyond that, it just seems to me better to have one process running rather than two....call it a gut feeling.
I hope this answers your question. I have a question of my own for you: As to having to sync to a second computer......My situation is a bit....different....in that I am virtually continually traveling. I really need to have everything on one dedicated server so that the business functions without me and my traveling computer. Do you feel TinyERP has security weaknesses itself, if it is exposed to the web? Or, are you speaking from the standpoint of not having a dedicated server and other "residents" of a shared server exposing you to potential security problems? P.S. If anyone reading this happens to get upset about my choices, I apologize, really am not trying to start a flame war over languages, etc. It's just that I don't have all the time in the world to learn different repeats of creating the wheel and I chose my choices based off of what I recognized from my ancient beginnings as familiar....I'm not saying I am right, just hoping to be comfortable with my choices. Ha! Remember, i missed everything that happened since that time, because I was completely out of the computer world. sm. I am REALLY interesting in your company's solution! When you are ready to show it, would you post another reply to this thread letting me know the URL to check it out? eSquat. Thanks. I will take a peek at it. obioma. Thanks. I will look at it. If it tastes right, I won't mind doing the interface myself. I should have mentioned that I won't be doing any invoicing or shipping. My products for sale are all going to be downloads at the time of purchase. I just want my books kept up to date automatically. So, it would help if the Shopping Cart can handle downloads as a product, but, for the right Cart, I would consider writing the download capability myself. Who knows. Python might have something already worked up that could be stitched in! I really appreciate the time you've all taken for me. If anyone has any more ideas or thoughts, please feel free to expound!!! :D :D :D _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
