Hi,
I just wonder if there is another equivalent to sqlite, that php can handle...
TIA! -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Der Resetschalter. Weil Windows brauche es.
On Thu, Aug 24, 2006 at 01:38:33PM -0400, Rodolfo Alcazar wrote:
I just wonder if there is another equivalent to sqlite, that php can handle...
Like, say, sqlite?
No, really -- what do you mean by equivalent, and what do you mean by handle, and what's wrong with sqlite?
On Thu, 2006-08-24 at 14:16 -0400, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 01:38:33PM -0400, Rodolfo Alcazar wrote:
I just wonder if there is another equivalent to sqlite, that php can handle...
Like, say, sqlite?
Yep. Sorry for not being enough explicit:
No, really -- what do you mean by equivalent,
* simple * which can store structure and data on a file, without running a dbms (dont want a network-oriented server)...
and what do you mean by handle,
php seems to handle sqlite, but in FC5 by default does not work:
[Thu Aug 24 11:59:49 2006] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function sqlite_open() in /var/www/html/www/lecac/plg/bookdb.php on line 23, referer: http://localhost/www/lecac/index.php?pg=meta/
Then I searched for php-sqlite. Found ONLY an older version in:
http://womensfooty.com/fedora/core/5/RPMS/i386/
After installing:
[Thu Aug 24 12:47:55 2006] [error] [client 127.0.0.1] PHP Warning: sqlite_open() [<a href='function.sqlite-open'>function.sqlite-open</a>]: file is encrypted or is not a database in /var/www/html/www/lecac/plg/bookdb.php on line 25, referer: http://localhost/www/lecac/index.php?pg=meta/
Yes. It is there. Yes, it is a sqlite database, but version=3. That last rpm handles just version=2.
and what's wrong with sqlite?
Cant make it work with php.
Now, again, is there another equivalent to sqlite, that php in FC5 can handle?
TIA! -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Die Zeit für Experimente ist vorbei......
You could write to flat files then open and parse. That is what I did back in the day before MySQL made my life much easier.
Or xml would work.
-fastfish
On 8/24/06, Rodolfo Alcazar rodolfo.alcazar@padep.org.bo wrote:
On Thu, 2006-08-24 at 14:16 -0400, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 01:38:33PM -0400, Rodolfo Alcazar wrote:
I just wonder if there is another equivalent to sqlite, that php can handle...
Like, say, sqlite?
Yep. Sorry for not being enough explicit:
No, really -- what do you mean by equivalent,
- simple
- which can store structure and data on a file, without running a dbms
(dont want a network-oriented server)...
and what do you mean by handle,
php seems to handle sqlite, but in FC5 by default does not work:
[Thu Aug 24 11:59:49 2006] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function sqlite_open() in /var/www/html/www/lecac/plg/bookdb.php on line 23, referer: http://localhost/www/lecac/index.php?pg=meta/
Then I searched for php-sqlite. Found ONLY an older version in:
http://womensfooty.com/fedora/core/5/RPMS/i386/
After installing:
[Thu Aug 24 12:47:55 2006] [error] [client 127.0.0.1] PHP Warning: sqlite_open() [<a href='function.sqlite-open'>function.sqlite-open</a>]: file is encrypted or is not a database in /var/www/html/www/lecac/plg/bookdb.php on line 25, referer: http://localhost/www/lecac/index.php?pg=meta/
Yes. It is there. Yes, it is a sqlite database, but version=3. That last rpm handles just version=2.
and what's wrong with sqlite?
Cant make it work with php.
Now, again, is there another equivalent to sqlite, that php in FC5 can handle?
TIA!
Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Die Zeit für Experimente ist vorbei......
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
php seems to handle sqlite, but in FC5 by default does not work:
Ah. See: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=148960
Cant make it work with php. Now, again, is there another equivalent to sqlite, that php in FC5 can handle?
I'm pretty sure there is not. Getting sqlite to work with FC5 is probably the best direction in which to work. Or failing that (and more likely to get Fedora developer attention since this would be a new feature) FC6.
On Thu, 2006-08-24 at 14:40 -0400, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
php seems to handle sqlite, but in FC5 by default does not work:
Ah. See: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=148960
Good. Using PDO instead of php-sqlite. This works fine:
$db=new PDO('sqlite:/var/www/html/bookdb.db'); foreach($db->query("select * from table") as $res) print_r($res);
Now, to learn PDO.
Thanks! -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Murphy's laws apply to Murphy's laws, too
On Thu, Aug 24, 2006 at 03:24:39PM -0400, Rodolfo Alcazar wrote:
Ah. See: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=148960
Good. Using PDO instead of php-sqlite. This works fine: $db=new PDO('sqlite:/var/www/html/bookdb.db'); foreach($db->query("select * from table") as $res) print_r($res); Now, to learn PDO. Thanks!
You're welcome. From the ten minutes I looked at it, it looks pretty straightforward. Better than learning a new mechanism for each database.
On Thu, 24 Aug 2006, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
I'm pretty sure there is not. Getting sqlite to work with FC5 is probably the best direction in which to work. Or failing that (and more likely to get Fedora developer attention since this would be a new feature) FC6.
He could try to compile the sqlite module. It's a pain, but good for learning. :-D
-- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------
On Thu, 2006-08-24 at 18:01 -0300, Martin Marques wrote:
On Thu, 24 Aug 2006, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
I'm pretty sure there is not. Getting sqlite to work with FC5 is probably the best direction in which to work. Or failing that (and more likely to get Fedora developer attention since this would be a new feature) FC6.
He could try to compile the sqlite module. It's a pain, but good for learning. :-D
Its no pain. But need standardized/simple install/update procedures. On my laptop, no problem. But not ever on a server.
Thanks anyway. Grüß! -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Linux. Ich bin doch nicht blöd.
On Thu, 24 Aug 2006 19:16:25 -0400, Rodolfo Alcazar rodolfo.alcazar@padep.org.bo wrote:
On Thu, 2006-08-24 at 18:01 -0300, Martin Marques wrote:
On Thu, 24 Aug 2006, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
I'm pretty sure there is not. Getting sqlite to work with FC5 is
probably
the best direction in which to work. Or failing that (and more likely
to get
Fedora developer attention since this would be a new feature) FC6.
He could try to compile the sqlite module. It's a pain, but good for learning. :-D
Its no pain. But need standardized/simple install/update procedures. On my laptop, no problem. But not ever on a server.
Do you change versions of PHP frequently on your servers? That's a very bad idea. You could end up with php scripts that don't work.
If they are security upgrades, then the same module will work with any of them.
-- --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------
On Fri, 2006-08-25 at 09:16 -0300, Martin Marques wrote:
On Thu, 24 Aug 2006 19:16:25 -0400, Rodolfo Alcazar rodolfo.alcazar@padep.org.bo wrote:
On Thu, 2006-08-24 at 18:01 -0300, Martin Marques wrote:
On Thu, 24 Aug 2006, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
I'm pretty sure there is not. Getting sqlite to work with FC5 is
probably
the best direction in which to work. Or failing that (and more likely
to get
Fedora developer attention since this would be a new feature) FC6.
He could try to compile the sqlite module. It's a pain, but good for learning. :-D
Its no pain. But need standardized/simple install/update procedures. On my laptop, no problem. But not ever on a server.
Do you change versions of PHP frequently on your servers? That's a very bad idea. You could end up with php scripts that don't work.
Many prefer upgrading, many do not. You prefer not to upgrade, be my guest (If that could be my focus, i would use Debian, SUSE, Ubuntu, which are more static, few-upgrades-needing distros). This was already discussed: https://www.redhat.com/archives/fedora-list/2005-November/msg03933.html
Bye! -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- Maugham's Thought: Only a mediocre person is always at his best.
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
and what's wrong with sqlite?
Cant make it work with php.
So, update: install the php-pdo subpackage ("yum install php-pdo"), and you'll get the pdo_sqlite extension, which is designed to work with sqlite 3. I did a rudimentary test (on rawhide/FC6, not FC5, but the current FC5 package looks very similar) and it appears to work just fine.
Now, again, is there another equivalent to sqlite, that php in FC5 can handle?
That "again" just seems so hostile I feel obligated to poke at it again. It's usually most helpful if you ask a question based on what you actually want, rather than a side-question based on what you think you want.
If someone were to just answer your original question, all you would have gotten is a "not really".
Instead, the above information should be what you need.
On Thu, 2006-08-24 at 15:17 -0400, Matthew Miller wrote:
On Thu, Aug 24, 2006 at 02:28:37PM -0400, Rodolfo Alcazar wrote:
and what's wrong with sqlite?
Cant make it work with php.
So, update: install the php-pdo subpackage ("yum install php-pdo"), and you'll get the pdo_sqlite extension, which is designed to work with sqlite 3. I did a rudimentary test (on rawhide/FC6, not FC5, but the current FC5 package looks very similar) and it appears to work just fine.
I had it installed already, works fine.
Now, again, is there another equivalent to sqlite, that php in FC5 can handle?
That "again" just seems so hostile I feel obligated to poke at it again. It's usually most helpful if you ask a question based on what you actually want, rather than a side-question based on what you think you want.
Ok, I thought sqlite support was removed, but I was wrong.
If someone were to just answer your original question, all you would have gotten is a "not really".
Well, seems there is no other. Thanks!
On Thu, 24 Aug 2006, Rodolfo Alcazar wrote:
On Thu, 2006-08-24 at 14:16 -0400, Matthew Miller wrote:
- simple
- which can store structure and data on a file, without running a dbms
(dont want a network-oriented server)...
Berkley DB.
and what do you mean by handle,
php seems to handle sqlite, but in FC5 by default does not work:
[Thu Aug 24 11:59:49 2006] [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function sqlite_open()
You don't have sqlite support on your php. I'm not an sqlite user, but with other RBDMs you have to install the shared module in order to be able to use it within php (php-pgsql for instance).
-- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------
On Thu, 2006-08-24 at 17:57 -0300, Martin Marques wrote:
On Thu, 24 Aug 2006, Rodolfo Alcazar wrote:
On Thu, 2006-08-24 at 14:16 -0400, Matthew Miller wrote:
- simple
- which can store structure and data on a file, without running a dbms
(dont want a network-oriented server)...
Berkley DB.
I'll give it a try. Thanx. -- Rodolfo Alcazar - rodolfo.alcazar@padep.org.bo Netzmanager Padep, GTZ 591-70656800, -22417628, LA PAZ, BOLIVIA http://otbits.blogspot.com -- If it's not in the computer, it doesn't exist.
On Thu, Aug 24, 2006 at 07:19:48PM -0400, Rodolfo Alcazar wrote:
- which can store structure and data on a file, without running a dbms
(dont want a network-oriented server)...
Berkley DB.
I'll give it a try. Thanx.
Berkley DB uses key-value pairs, so it may become complicated to store some data structures in it. But if you're basically using data in that form, it's fine.
On Thu, 24 Aug 2006, Rodolfo Alcazar wrote:
Hi,
I just wonder if there is another equivalent to sqlite, that php can handle...
What do you mean? BDB, PostgreSQL, MySQL?
-- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------
-
Bazooka Joe -
Martin Marques -
Matthew Miller -
Rodolfo Alcazar Portillo