php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #18517 PicoSQL access module
Submitted: 2002-07-23 20:01 UTC Modified: 2004-01-10 09:42 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: bilo at mit dot it Assigned:
Status: Closed Package: Feature/Change Request
PHP Version: 4.2.2 OS: Linux, Windows NT, AIX
Private report: No CVE-ID: None
 [2002-07-23 20:01 UTC] bilo at mit dot it
I just want to signal to C skilled (and willing) people
here that there is a new interesting RDBMS server called
picoSQL (www.picosoft.it).

Besides beeing really small (the tarball with server +
client programs + library + jdbc driver + sample db + doc
is ~ 2.8Mb) it's really full-featured and fast. It's
available for Linux and NT, it has a windows ODBC driver
(and JDBC driver, too), and ODBC 2.5 compliant C/C++ API.
It supports transactions, row level locking, BLOBS, sub-
queries and more...

Well: I think it really needs a PHP module !!!

The documentation claims it's distributed under GPL and
I've read that this can be a problem. By the way the
package also contains a Mozilla Public License file.
I've posted a message to PicoSoft asking wether the API client library is under GPL or LGPL. Hope they'll answer
soon.


Regards 

Gabriele Carioli


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-07-24 03:33 UTC] bilo at mit dot it
This is the right link:

http://www.picosoft.it/picosql/

The main page is only in italian!
 [2002-07-24 08:50 UTC] samjam@php.net
I'd like to do this, using swig (www.swig.org)

Sam
 [2002-07-26 04:28 UTC] samjam@php.net
Well, I've done it, if there's no objection I'll add it to CVS.

Someone else (bilo@mit.it ?) will need to write the documentation and see how usable it actually is.

Sam
 [2002-07-26 04:29 UTC] samjam@php.net
I though't I'd add a note on how easy this is with swig-cvs:

# make work directory
mkdir picosql-php
cd picosql-php

# make interface file to depend on picosql .h files
# we could craft our own .i file if we wanted
cat > picosql.i <<END
%module picosql
%{
#include <odbcsql.h>
%}

%include win4unix.h
%include odbcsql.h
END

# generate php module - very easy, need cvs version of swig
swig -php4 -c++ -shadow -phpfull -I/usr/include -withincs odbcsql.h -o picosql_wrap.cpp picosql.i

# compile!
phpize
./configure --with-picosql=/usr
make
make install

# then test the module loading
php php_picosql.php
 [2002-07-26 04:33 UTC] derick@php.net
I think you should make it a PECL package, as this is not really a mainstream database.

Derick
 [2002-08-13 22:03 UTC] kalowsky@php.net
marking as assigned.  
 [2003-04-12 09:20 UTC] imajes@php.net
samjam's email doesn't work, so removing the assigned flag.
 [2004-01-10 09:42 UTC] andrey@php.net
Currently there is a picoSql wrapper in PECL  : 
http://cvs.php.net/cvs.php/pecl/picosql
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 16:01:29 2024 UTC