New Posts  All Forums:Forum Nav:

Point of Sales

post #1 of 6
Thread Starter 
Hey Guys!

I'm thinking about developing a point of sale software for a store chain with a couple of locations (each with lets say 10 POS), I was thinking a software with SQLite for local operation (in case of network failure) so it can continue to work standalone, and then some sort of consolidation at the end of the day with the server (to update inventory and that kind of things). What would be your approach for this scenario? Is SQLite enough for this? I'm guessing about 1000 transactions per day (easily). Is sort of an update for the current system. One of the reason I considered SQLite instead of Microsoft SQL Compact is for a Linux - Java based system.
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
post #2 of 6
Might be easier to run something more heavy duty like MySQL or PostgreSQL and use their replication features to keep your remote sites in sync.
post #3 of 6
Quote:
Originally Posted by NorCa View Post

Hey Guys!

I'm thinking about developing a point of sale software for a store chain with a couple of locations (each with lets say 10 POS), I was thinking a software with SQLite for local operation (in case of network failure) so it can continue to work standalone, and then some sort of consolidation at the end of the day with the server (to update inventory and that kind of things). What would be your approach for this scenario? Is SQLite enough for this? I'm guessing about 1000 transactions per day (easily). Is sort of an update for the current system. One of the reason I considered SQLite instead of Microsoft SQL Compact is for a Linux - Java based system.

SQLite is not good for this. If the network is down, tough cookies. Well, not really.

You have a couple of options:

1. Microsoft SQL Server - seriously, replication with SQL Server + Windows Server is excellent. But you want Linux + Java so...
2. Replication with MySQL.... or PostgreSQL like Plan the man suggests.
3. A combination of 1 or 2, and a separate web service or other interface that the frontend interacts with (because I always believe its better a frontend communicate with a service rather than the database itself).
4. Buy something already developed and tested.
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
Ol' Sandy
(28 items)
 
"Zeus"
(12 items)
 
Elite Preview
(6 items)
 
CPUMotherboardGraphicsRAM
Intel Xeon E3-1230v3 Gigabyte GA-Z97X-UD5H-BK MSI Gaming GTX 980 Kingston 32GB (4x8) 
Hard DriveHard DriveHard DriveHard Drive
Plextor PX-256M5S 256GB Samsung EVO 1TB Hitachi HDS721010CLA332 Hitachi HDS723020BLA642 
Hard DriveHard DriveHard DriveOptical Drive
Hitachi HDS723020BLA642 Hitachi HUA722010CLA330 WDC WD10EARS-00Z5B1 TSSTcorp CDDVDW SH-S223B 
CoolingCoolingOSMonitor
Phanteks PH-TC14PE with TY-140's Lamptron FCv5 (x2) Windows 8 Pro 64-bit Dell U2412M 
MonitorMonitorMonitorKeyboard
Dell U2412M Dell U2212HM Dell U2713HM Topre Realforce 87UB | Ducky DK9087 G2 Pro 
PowerCaseMouseMouse Pad
Corsair AX-750 Corsair Obsidian 650D Logitech G700 XTRAC Ripper XXL 
AudioAudioAudioAudio
Beyerdynamic DT-770 Pro 250ohm Schiit Bifrost DAC Schiit Asgard 2 HiVi Swan M50W 2.1 
CPUMotherboardRAMHard Drive
Intel Xeon E5-2620 Super Micro X9SRL-F-B 128GB 1333MHz LSI 9271-8i 
OSPowerCase
VMware ESXi 5.5 SeaSonic SS-400FL2 Fractal Define R3 
CPUMotherboardGraphicsRAM
Intel Core i5-3437U HP EliteBook Folio 9470m  Intel HD Graphics 4000  16GB DDR3 SDRAM 
Hard DriveOS
256GB SSD Windows 10 Insider Preview 
  hide details  
Reply
post #4 of 6
Thread Starter 
Thank you both!

I guess I'll check MariaDB or PostgreSQL. I may start with windows but I'm inclined in developing with Java so I can move later to linux, licenses - virus - antivirus are more and more important. We are currently using a software we bought, but is really bad, expensive, and their support is not getting better. So my idea is we develope our own solution. Is a long term project and we should be ok doing it (developing wise), they just need the right people thumb.gif
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
Atroc.V3.2
(16 items)
 
Home Server
(9 items)
 
 
CPUMotherboardGraphicsRAM
i5 2500k [Asrock] Z77E-ITX [EVGA] GTX 770 [Samsung] 8GB 30nm 
Hard DriveCoolingCoolingOS
[Crucial] M4 64Gb [Silverstone] NT06-PRO [Gelid] 120mm PWM Windows 7 Ultimate x64 
MonitorKeyboardPowerCase
[Samsung] 22" [Microsoft] Sidewinder X4 [Silverstone] SFX450w [Silverstone] SG05 
MouseAudioOtherOther
[Microsoft] Sidewinder [Shure] SRH-840 [Shiit] Magni [Schiit] Modi 
CPUMotherboardRAMHard Drive
[AMD] Athlon X3 450 [Asus] M4A785TD-V Evo [Corsair] 4GB XMS3 DDR3 [Western Digital] 200Gb 
Hard DriveOptical DriveOSPower
[Western Digital] 2Tb [Acer] DVD RW ArchLinux [CoolerMaster] Elite 460w 
Case
[NZXT] Gamma 
  hide details  
Reply
post #5 of 6
If you want to develop a pos that stores the pos data on each local machine i would suggest using background threads that syncronise with the server database every x minutes to update the data, background so it doesn't disturb any sales activities going on at the same time.
.
It's very much possible and might be the way to go to prevent network failures but of course it makes things more complicated.

Bare in mind that you will not only have to update the pos sales data to the server but also the other way around, from server to each pos client, for example to update product prices, the store manager might be updating the prices on the server while sales are happening.

You will also have to keep track of how each customer payed, some might pay cash, or creditcard, or cheque or a combination of several types; and generally store owners here (don't know how things are where you live) want to be able to count the cash in each cashregister at the end of the day to check.
So you need to have data for cashdrawers too, and making it possible to change what is in each cashdrawer at the start or end of a sales day.

And then the salespeople have problems like not having enough cash and asking another to get money from their cashdrawer; all that has to be possible in the software.
Extremepc
(18 items)
 
The Duke
(18 items)
 
 
CPUMotherboardGraphicsRAM
Core I7 2600 Asus P8P67 deluxe Asus GTX 570 Kingston DDR3 16 gb (4x4) 
Hard DriveHard DriveHard DriveHard Drive
Revodrive x2 240 ST31500341 ST32000641AS HD103UJ 
Optical DriveCoolingOSMonitor
BH10LS30 Scythe mugen 2 Windows 7 Ultimate Yamakasi Q270 SE 
MonitorKeyboardPowerCase
Samsung 2443 BW Logitech K800 Coolermaster 850 watt  Coolermaster Haf-x 
MouseOther
Logitech performance mx 2 x hauppauge HVR 2200 tuner card 
  hide details  
Reply
Extremepc
(18 items)
 
The Duke
(18 items)
 
 
CPUMotherboardGraphicsRAM
Core I7 2600 Asus P8P67 deluxe Asus GTX 570 Kingston DDR3 16 gb (4x4) 
Hard DriveHard DriveHard DriveHard Drive
Revodrive x2 240 ST31500341 ST32000641AS HD103UJ 
Optical DriveCoolingOSMonitor
BH10LS30 Scythe mugen 2 Windows 7 Ultimate Yamakasi Q270 SE 
MonitorKeyboardPowerCase
Samsung 2443 BW Logitech K800 Coolermaster 850 watt  Coolermaster Haf-x 
MouseOther
Logitech performance mx 2 x hauppauge HVR 2200 tuner card 
  hide details  
Reply
post #6 of 6
offtopic.gif

I think you should refer to it other that POS... http://www.urbandictionary.com/define.php?term=pos tongue.gif
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming