php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bilo at mit dot it
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Mon May 12 09:01:27 2025 UTC