D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] C++ Questions?

 

At Thu 19 Mar 2009 09:38:41 UTC, Tom Potts  
<tompotts@xxxxxxxxxxxxxxxxxxxx> wrote:

> <startflamewar>

:-)

> anything enterprise level should be done
> through stored procedures so the db can be changed without touching the
> GUI

I agree that it can be useful to separate the GUI from the business  
logic if the GUI is widely deployed and accesses a central database.  
Stored procedures is one option, but there are others:

* have the GUI auto-upgrade, so the GUI always has the latest logic
* Use a web-based UI and keep the logic in the web backend (e.g. Java  
Servlets)
* Use RPC mechanisms to call server-side code from the GUI
* Code the GUI as part of the database (e.g Oracle Forms)

SQLite is great for local databases (however large), and though it can  
handle multiple concurrent accesses to the same db you probably want  
to go for a "proper" client-server database if there are lots of users  
or the apps run on a separate machine from the db.

Anthony
-- 
Anthony Williams
Author of C++ Concurrency in Action | http://www.manning.com/williams
just::thread C++0x thread library   | http://www.stdthread.co.uk
Custom Software Development         | http://www.justsoftwaresolutions.co.uk
Just Software Solutions Ltd, Registered in England, Company Number 5478976.
Registered Office: 15 Carrallack Mews, St Just, Cornwall, TR19 7UL, UK



-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html