Encerrado

Simple object proxy using Poco

I need to execute mysql queries on the client side (Win32 c++ app) aginst a mysql database. I could connect directly to the database using standard mysql libraies executing queries, and then process the resulting recordset on the client as usual.

But I need some blocking behavoiur to some queries, eg. one query inititated from a client should wait to finish another query inititated from another one.

To achieve this insted of 2 tier architecture I need a 3 tier architecture, in other worlds I need a so called lockproxy between the client and the database...

Each query intantiated from the client against the lockproxy will have a lockid(int32), and before executing each query the lockproxy will check it's internal list of the actually running querries and if one found with the same lockid, it waits to finish it before executing other querries

I've found Poco ([url removed, login to view]) libriary is ideal for the server side locking architecture using it's built in remoting mechnism and database classes.

So the client app will use poco to connect to the server and passing an sql query string to together with a lockid. The server is also implemented using poco, checks for lockid, and if no other running process found with the same lockid, it executes the query against the database and returns the resulting recordset to the client using remoting...

Habilidades: Programação C, Engenharia, Linux, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: win32 programming, proxy server simple, object in programming, object c programming, php is object, worlds, tier one, simple query, proxy server connect, php check proxy, recordset, sql win32, poco http, php connect sql server, http proxy server list, mysql object, connect using, server proxy list, win32 http, poco server, object mysql, poco, poco client server, connect query mysql, proxy server client

Acerca do Empregador:
( 6 comentários ) Ramaputyra, Hungary

ID do Projeto: #2958806

2 freelancers estão ofertando em média $425 para este trabalho

engmalaa

See private message.

$425 USD in 14 dias
(21 Comentários)
4.3
strgazer

See private message.

$425 USD in 14 dias
(4 Comentários)
3.9