Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.989.537 Times

picoSQL 2.0.4a

  Date Added: May 13, 2010  |  Visits: 884

picoSQL

Report Broken Link
Printer Friendly Version


Product Homepage
Download (81 downloads)

picoSQL project is the first Italian Open Source relational database management system. The project of picoSQL was born in 1995. It was an ODBC driver for COBOL indexed files. It consisted of a DLL written in C++ on Windows 3.1 operating system. In the beginning the main effort was made in order to obtain a good compatibity with existing front-end (mainly the MS-Access, MS-Query and VisualBasic) and in order to see COBOL files as a normalized relational DB. The obtained success concurs to develop ulteriorly the product, refining the query optimizer and implementing an extended SQL, to exclusion of the DDL (Data Description Language). A later version, called PicoDB, were devoloped on UNIX system in client/server architecture. PicoSql is released under GPL license; it derives from PicoDB (that remains a Picosoft proprietary product) with the addition of some SQL-DDL statement (CREATE/DROP TABLE(INDEX) and excluding COBOL files compatibility). The C/C++ library that allow the database access from C/C++ programs using the ODBC 2.5 API is released under LGPL license; this allows to link the library with programs that are not under GPL. PicoSQL can be used from Windows applications (like MS-ACCESS, MS-Query, VB etc.) in client/server modality using the ODBC driver picoSQLNet. It can moreover be used from appropriate Java programs through the JDBC driver comprised in the distribution. Finally it can be used from programs written in C and C++ through its set of ODBC 2.5 compliant API. PicoSQL lacks at the moment of some common characteristics to the most common RDBMS (like the schema and catalogue concepts and the management of the user permissions who can be obtained anyway using the permissions of the host operating system) but they are just these lacks to make it particularly simple to install and to use and fast in the logons and the queries. Installation: The installation is particularly simple: if you have the binary distribution, is sufficient to extract the compressed files in one directory ( under Windows NT/2000/XP) and execute: startTestDb.sh (Unix/Linux) PicoSQL consists fundamentally in a program, picosqld, to activate through inetd (or xinetd) or picoserv. In such a way it becomes a net service binded to a port, that is to a entire number comprised between 1 and 65535; this number (as an example 6789) must always be specified on the command line of picosqld. As an example: picosqld 6789 For the activation with inetd (or xinetd), you must see the relative documentation. picoserv is a simple program that replaces inetd, mainly for scopes of test or debugging: its usage is the following: picoserv [-f] commandLine portNumber In our case the activation of picosqld can be obtained with the following command line: picoserv "picosqld 6789" 6789 To notice as the port number is specified two times, as an argument of picosqld and as an argument of picoserv. When picosqld receive a connection request, it reads a configuration file to find the necessary informations. This file is a text file on Unix/Linux systems. # Unix/Lunixthe file read for configuration is $HOME/.picosql.ini or, if this file is missing /etc/picosql.ini The file consists of sections and parameters. A section begins with the name of the section in square brackets and continues until the next section begins. Sections contain attributes of the form name=value The file is line-based - that is, each newline-terminated line represents either a comment, a section name or a parameter. Section and parameter names are not case sensitive. Only the first equals sign in a parameter is significant. Any line beginning with a semicolon (;) or a hash (#) character is ignored, as are lines containing only whitespace. Each section corresponds to a database and comprises information like user, password and DB location. In the following example there are two database declared, the former called picoSqlTest, is accessible by anyone while the latter, called rubrica is accessible only by user pico giving the appropriate password. [picoSqlTest] DataDirectory=/home/test.db [rubrica] DataDirectory=/home/rubrica.db User=pico Password=soft PicoOdbcTrace=NO SuspensiveLock=YES ; for picosql client only server=localhost port=6789 Whats New in This Release: - This version fixes a problem on authentication and a bug when the connection fails..

Requirements: No special requirements
Platforms: Linux
Keyword: Client Server Cobol Database Database Servers File Odbc Picosql Rdbms Section Sql System User
Users rating: 0/10

License: Freeware Size: 2.9 MB
PICOSQL RELATED
Libraries  -  Client / Server Communications Library for Visual Basic 6.1
CSC (MarshallSoft Client / Server Communications Library) is a DLL component library useful for client/server programs which can communicate across any TCP/IP network including the Internet. for WindowsAll
 
Server Tools  -  Zolsoft Office Server Free Edition 2011.1012
Zolsoft Office Server is an office automation package consisting of a Web server, a client server, an FTP server, an SMTP server and a POP3 server. A hot application is network drives. It can divide users by workgroups and create workgroup...
14.28 MB  
Puzzles  -  Online Cardgame System 0.9.0
Online Cardgame System project is a client-server system for playing card games over the net. OCS is a client-server cardgame system, similar to those found at Yahoo! Games and elsewhere. The server is portable and has been tested under Linux,...
 
Miscellaneous Communications Tools  -  Shared Calendar Alpha-1
Shared Calendar is a client/server calendar program that enables multiple users (especially in the same organization) to schedule meetings and the use of shared resources. The server runs on Linux (RedHat 7.2) and the client runs on Windows 4.x or...
30.72 KB  
Database Tools  -  SQL Server to SQL Server Compact Edition Database Copy 1.0
SQL Server to SQL Server Compact Edition Database Copy: The purpose of this utility to to provide a mechanism to copy Microsoft SQL Server databases to a SQL Server Compact Edition database. I developed this tool because I was unable to find a...
34 KB  
Database Tools  -  sqlWebArchitect 0.9a 1.0
sqlWebArchitect is a Web-Based Open Source SQL Server and MSDE Database Administration tool. It is built with Microsoft .NET Framework 2.0 and released under GPL License. Main features: validator for mandatory fields, ATLAS support in every page,...
 
FTP Clients  -  FSFS 0.1.1
FSFS is a user space client-server distributed file system that exports encrypted files and directories securely over the network; most of the cryptography is left to the clients, letting users store and retrieve data in a secure, scalable and...
245.76 KB  
Text Chat Clients  -  Akeni Instant Messaging IM - Pro 1.2.75
Akeni Instant Messaging - Pro is a client/server instant messaging platform that allows companies to host their own secured private IM system. The client has an user interface similar to AIM, ICQ, or MSN Messenger. It supports all the standard IM...
3.1 MB  
Backup Utilities  -  afbackup 3.5.7
afbackup project is a client-server backup system offering several workstations a centralized backup to special backup servers. The backup on the clients can be started automatically using cron-jobs on the clients, but the more...
1.15 MB  
Libraries  -  csoap 1.1.0
csoap is a SOAP client/server library in pure C. csoap is a fast and easy way to embed a SOAP client or a SOAP server into an application written in C. It is built on top of libxml2 and supports SSL and HTTP Basic authentication. Howto use...
849.92 KB  
NEW DOWNLOADS IN NETWORK & INTERNET, SERVER TOOLS
Network & Internet  -  Free WiFi Hotspot 3.3.1
Free WiFi Hotspot is a super easy solution to turn your laptop or notebook into a portable Wi-Fi hotspot, wirelessly sharing your internet connections like DSL, Cable, Bluetooth, Mobile Broadband Card, Dial-Up, etc. through the built-in wireless...
1.04 MB  
Network & Internet  -  Easy Uploads 1.8
Easy uploads is a file storage media streaming application designed by Filestreamers that allows you to upload, store, and stream your files from their virtually unlimited file storage server. Easy Uploads can backup,share, and stream your files...
615.97 KB  
Network & Internet  -  IPv6 CARE 3.2b
IPv6 CARE, "IPv6 Compliant Automatic Runtime Environment", is a Linux tool able to patch ipv6-agnostic programs on-the-fly ('patch' mode). It can also generate a diagnosis about the IPv6 compliance of an application ('check' mode).
409.6 KB  
Network & Internet  -  PacketFence ZEN 3.1.0
PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) system. Boosting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, 802.1X...
1024 MB  
Network & Internet  -  django-dbstorage 1.3
A Django file storage backend for files in the database.
10.24 KB  
Server Tools  -  GAdmin-OpenVPN-Server 0.1.6
GAdmin-OpenVPN-Server is an easy to use GTK+ client for the OpenVPN server in Bridge mode. A GUI for OpenVPN Multi-Client Server bridge. It can generate and use a total of 5 signed certificates and keys including...
245.76 KB  
Server Tools  -  Dual DHCP DNS Server 6.84
DHCP Server alots the IP addresses to computers, while DNS server resolves them. You need DHCP Server if you do not want to manually maintain IP Addresses or you have less IP Addresses than number of machines you have, as dynamic DHCP...
655.36 KB  
Server Tools  -  Localhost Indicator 0.0.1
Localhost Indicator is a simple and highly Ubuntu 10.04 integrated localhost web server indicator of Apache2 status, which takes advantages of the indicator-applet.
20.48 KB  
Server Tools  -  Open DHCP Server 1.45
DHCP Server Open Source Freeware. MultiSubnet DHCP Server supports Dynamic, Static Leases, Relay Agents, BOOTP, PXEBOOT, Options can be Global, Range Specific and Client Specific. Supports filtering of ranges on Mac Address, Vendor and User Class.
30.72 KB  
Server Tools  -  GAdmin-HTTPD 0.1.5
GAdminHTTPD project is an easy to use gtk+ user interface for the Apache HTTPD webserver. Featuring: Default server and multi-vhosting management. User management. Module management. Configuration imports and creations, manual editing,...
481.28 KB