RE: Which SQLite DBD To Use
-Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: I am about to ask someone to install DBI and DBD-SQLite on a platform. I noticed there are a number of related repos on CPAN: DBD-SQLite, DBD-SQLite2, DBD-SQLite-Amalgamation. Is DBD-SQLite the right one to get? Yes. Thanks for the info. Also, the DBD-SQLite package has a funny description: Self-contained RDBMS in a DBI Driver. This doesn't mean that DBD-SQLite re-implements all of SQLite, does it? No. It doesn't reimplement it, it just bundles it. Or does it just mean that it is the Driver for the Self-contained RDBMS of SQLite? No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. Interesting. In embedded systems there is often a lot of fighting over flash space, and if people are using SQLite then it has already been installed somewhere. Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? -Will
RE: Which SQLite DBD To Use
-Original Message- From: David Nicol [mailto:davidni...@gmail.com] amalgamation includes the optional Full Text Search Engine module, which is extremely cool if you need it. Thanks, I'll keep that in mind. -Will
RE: Which SQLite DBD To Use
-Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? Almost certainly yes. Thanks for the help. -Will
Re: Which SQLite DBD To Use
Will Rutherdale (rutherw) wrote: -Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: Is DBD-SQLite the right one to get? Yes. No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. Interesting. In embedded systems there is often a lot of fighting over flash space, and if people are using SQLite then it has already been installed somewhere. Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? Yes, you can. Look at the source of the Makefile.PL, http://cpansearch.perl.org/src/ADAMK/DBD-SQLite-1.30_01/Makefile.PL , for information on how to do that. The ability to use a system-installed SQLite is present, but disabled by default for casual users, because you could be more likely to run into problems due to potential version incompatibilities and so forth or other build system complexities. You enable it by setting the USE_LOCAL_SQLITE and optionally the SQLITE_LOCATION environment variables. Moreover, you have to change the indicated if(0) to if(1) in the Makefile.PL. -- Darren Duncan
Which SQLite DBD To Use
Hi. I am about to ask someone to install DBI and DBD-SQLite on a platform. I noticed there are a number of related repos on CPAN: DBD-SQLite, DBD-SQLite2, DBD-SQLite-Amalgamation. Is DBD-SQLite the right one to get? Also, the DBD-SQLite package has a funny description: Self-contained RDBMS in a DBI Driver. This doesn't mean that DBD-SQLite re-implements all of SQLite, does it? Or does it just mean that it is the Driver for the Self-contained RDBMS of SQLite? -Will
Re: Which SQLite DBD To Use
On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: I am about to ask someone to install DBI and DBD-SQLite on a platform. I noticed there are a number of related repos on CPAN: DBD-SQLite, DBD-SQLite2, DBD-SQLite-Amalgamation. Is DBD-SQLite the right one to get? Yes. Also, the DBD-SQLite package has a funny description: Self-contained RDBMS in a DBI Driver. This doesn't mean that DBD-SQLite re-implements all of SQLite, does it? No. It doesn't reimplement it, it just bundles it. Or does it just mean that it is the Driver for the Self-contained RDBMS of SQLite? No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern. __/ | http://www.hjp.at/ |-- Wolfram Heinrich in desd signature.asc Description: Digital signature
Re: Which SQLite DBD To Use
amalgamation includes the optional Full Text Search Engine module, which is extremely cool if you need it. -- question doubt
Re: Which SQLite DBD To Use
On 2010-03-17 10:27:45 -0500, Will Rutherdale (rutherw) wrote: -Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: Also, the DBD-SQLite package has a funny description: Self-contained RDBMS in a DBI Driver. This doesn't mean that DBD-SQLite re-implements all of SQLite, does it? No. It doesn't reimplement it, it just bundles it. Or does it just mean that it is the Driver for the Self-contained RDBMS of SQLite? No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. Interesting. In embedded systems there is often a lot of fighting over flash space, and if people are using SQLite then it has already been installed somewhere. Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? Almost certainly yes. In fact on Debian, libdbd-sqlite3-perl doesn't contain another copy of libsqlite3.so but reuses the lib from libsqlite3-0. If it isn't obvious how to do that from DBD::SQLite you may want to have a look at the Debian package. hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern. __/ | http://www.hjp.at/ |-- Wolfram Heinrich in desd signature.asc Description: Digital signature
