You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vcl.apache.org by Brian Bouterse <bm...@ncsu.edu> on 2009/03/09 21:49:18 UTC
VCL Database Abstraction Layer
Does the VCL architecture contains a database abstraction layer in its
architecture? I'm curious what it would take to make VCL generalized
to work with multiple database backends other than mySQL.
Brian
Brian Bouterse
Secure Open Systems Initiative
Re: VCL Database Abstraction Layer
Posted by Josh Thompson <jo...@ncsu.edu>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Matt,
Almost all of my database experience has been with php and mysql, and it's
almost all been self-taught. I'm not familiar with what you mean by "CRUD
operations" or "auto-commit operations". Can you explain that a little
further?
Thanks,
Josh
On Wednesday March 11, 2009, Matt Hogstrom wrote:
> The real issue is the locking model on the CRUD operations. Are there
> any transactions in VCL beyond auto-commit operations ?
>
> I'll sniff at the code but if there are multiple locks obtained you
> really need ot abstract to a data access model rather than simple
> database abstraction.
>
> On Mar 10, 2009, at 8:55 AM, Josh Thompson wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > The web code is using php's built in support for mysql. So, it
> > would probably
> > take quite a bit of effort to convert it all to be abstracted.
> >
> > Josh
> >
> > On Tuesday March 10, 2009, Aaron Peeler wrote:
> >> Not yet - on the perl side it shouldn't be too difficult since it's
> >> using
> >> DBI.
> >>
> >> Josh can comment more on the php code - but in my opinion it would
> >> difficult/time-consuming to convert queries.
> >>
> >> Aaron
- --
- -------------------------------
Josh Thompson
Systems Programmer
Virtual Computing Lab (VCL)
North Carolina State University
Josh_Thompson@ncsu.edu
919-515-5323
my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFJuWxuV/LQcNdtPQMRAm06AJ490bVVw6Bywz32Qm1d9A1yYwGPFwCbBSSA
OK3BYef4olKODyxfT2hHpcI=
=/bER
-----END PGP SIGNATURE-----
Re: VCL Database Abstraction Layer
Posted by Matt Hogstrom <ma...@hogstrom.org>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The real issue is the locking model on the CRUD operations. Are there
any transactions in VCL beyond auto-commit operations ?
I'll sniff at the code but if there are multiple locks obtained you
really need ot abstract to a data access model rather than simple
database abstraction.
On Mar 10, 2009, at 8:55 AM, Josh Thompson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> The web code is using php's built in support for mysql. So, it
> would probably
> take quite a bit of effort to convert it all to be abstracted.
>
> Josh
>
> On Tuesday March 10, 2009, Aaron Peeler wrote:
>> Not yet - on the perl side it shouldn't be too difficult since it's
>> using
>> DBI.
>>
>> Josh can comment more on the php code - but in my opinion it would
>> difficult/time-consuming to convert queries.
>>
>> Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
iEYEARECAAYFAkm4LIEACgkQMsHW7w8UO8EZ4wCgmnyLh6168Eoj0Ur5CFpmg1bX
wHYAnAogVqCJHESm2E7BvMl/GeOXsneM
=TDHH
-----END PGP SIGNATURE-----
Re: VCL Database Abstraction Layer
Posted by Josh Thompson <jo...@ncsu.edu>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The web code is using php's built in support for mysql. So, it would probably
take quite a bit of effort to convert it all to be abstracted.
Josh
On Tuesday March 10, 2009, Aaron Peeler wrote:
> Not yet - on the perl side it shouldn't be too difficult since it's using
> DBI.
>
> Josh can comment more on the php code - but in my opinion it would
> difficult/time-consuming to convert queries.
>
> Aaron
>
>
>
>
> --On March 9, 2009 4:49:18 PM -0400 Brian Bouterse <bm...@ncsu.edu>
>
> wrote:
> > Does the VCL architecture contains a database abstraction layer in its
> > architecture? I'm curious what it would take to make VCL generalized to
> > work with multiple database backends other than mySQL.
> >
> > Brian
> >
> >
> > Brian Bouterse
> > Secure Open Systems Initiative
>
> Aaron Peeler
> OIT Advanced Computing
> College of Engineering-NCSU
> 919.513.4571
> http://vcl.ncsu.edu
- --
- -------------------------------
Josh Thompson
Systems Programmer
Virtual Computing Lab (VCL)
North Carolina State University
Josh_Thompson@ncsu.edu
919-515-5323
my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFJtmNaV/LQcNdtPQMRAk6cAJ4sA0a6DwIbc1Inlux4K+IhT0OpywCeJPa2
rX6wTCK3kx9gJiYLp0KOPrc=
=hBje
-----END PGP SIGNATURE-----
Re: VCL Database Abstraction Layer
Posted by Aaron Peeler <aa...@ncsu.edu>.
Not yet - on the perl side it shouldn't be too difficult since it's using
DBI.
Josh can comment more on the php code - but in my opinion it would
difficult/time-consuming to convert queries.
Aaron
--On March 9, 2009 4:49:18 PM -0400 Brian Bouterse <bm...@ncsu.edu>
wrote:
> Does the VCL architecture contains a database abstraction layer in its
> architecture? I'm curious what it would take to make VCL generalized to
> work with multiple database backends other than mySQL.
>
> Brian
>
>
> Brian Bouterse
> Secure Open Systems Initiative
>
>
>
Aaron Peeler
OIT Advanced Computing
College of Engineering-NCSU
919.513.4571
http://vcl.ncsu.edu