This repository holds a simple list of options for connecting to 4D's SQL Server via the 4D SQL Networking Protocol from various programming environments.
The 4D SQL Networking Protocol is defined on sources.4d.com and is available here
This is a list of Implementations for the 4D SQL Networking Protocol:
---
back to top
Open Database Connectivity (ODBC) drivers are provided by 4D for Windows and MacOS.
4D does not provide an ODBC driver for Linux.
Download the ODBC drivers from the official 4D download page.
http://www.4d.com/downloads/products.html
---
back to top
P4D is a Python database module for the 4D database system. It is written by Israel Brewster using the SQLlib_4D
https://github.com/ibrewster/p4d
---
back to top
PDO_4D is a driver for the PHP Data Objects (PDO) interface to enable access from PHP to 4D databases.
Main distribution: http://sources.4d.com/trac/4d_pdo4d
PECL:
http://pecl.php.net/pdo_4d
Docs:
http://php.net/pdo_4d
http://php.net/pdo
Original SVN repository:
http://svn.php.net/repository/pecl/pdo_4d/
Notable Forks on github:
https://github.com/famsf/pecl-pdo-4d
<?php
$dsn = '4D:host=localhost;port=19812;charset=UTF-8';
$user = 'Administrator';
$pswd = 'test';
$db = new PDO($dsn, $user, $pswd);
$db->exec('CREATE TABLE IF NOT EXISTS myTable(id INT NOT NULL, value VARCHAR(100))');
unset($db);
echo 'done'; // if you see this then the code ran successfully
?>
---
back to top
SQL library for 4D written in C:
https://github.com/4D/SQLlib_4D
Notable Forks on github:
https://github.com/ibrewster/SQLlib_4D
---
back to top