protech_systems Posted March 6, 2008 Share Posted March 6, 2008 Hello all, I am building an money exchange system as a project...basically like Paypal, but it will be different in many ways. The important part right now is getting a viable solution for tracking and updating account balances and handling transactions. It will run on a clustered MySQL or PostgreSQL database, and one of my Java programming buddies suggested that I create "robots/drones" ie multiple instances of a single handler script to update the database. My question is how should I approach adding and subtracing from account balances? I am trained as a database admin, so have that side down pretty well, but I need some suggestions on how to make the script perform this function. Any ideas, musings, etc are welcome and appreciated. Link to comment https://forums.phpfreaks.com/topic/94748-building-exchange-system-need-help-building-worker-drone/ Share on other sites More sharing options...
cooldude832 Posted March 6, 2008 Share Posted March 6, 2008 you shouldn't write it in mysql because the volume of work is outside the acceptable limits of mysql. Oracle or somethign else is better Link to comment https://forums.phpfreaks.com/topic/94748-building-exchange-system-need-help-building-worker-drone/#findComment-485120 Share on other sites More sharing options...
protech_systems Posted March 7, 2008 Author Share Posted March 7, 2008 oracle might work...I'm pretty open to database options. My main concern right now is getting a production ready transaction handler. Are there any scripts available that might be adapted to do this? Scalability is priority 1. Thanks! Link to comment https://forums.phpfreaks.com/topic/94748-building-exchange-system-need-help-building-worker-drone/#findComment-486082 Share on other sites More sharing options...
cooldude832 Posted March 7, 2008 Share Posted March 7, 2008 your asking for a random script that will manage million of dollars that you can trust from some random person. I think you need to rethink your idea Link to comment https://forums.phpfreaks.com/topic/94748-building-exchange-system-need-help-building-worker-drone/#findComment-486104 Share on other sites More sharing options...
protech_systems Posted March 10, 2008 Author Share Posted March 10, 2008 :PNot really. Im just trying to get an idea how the handler would look and work. I can modify it for security. However, you're probably right in that I'll probably have to hire someone competent rather than try to depend on community hacks. Link to comment https://forums.phpfreaks.com/topic/94748-building-exchange-system-need-help-building-worker-drone/#findComment-488430 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.