databases/sqlrelay 1.9.3_1 FreeBSD
Persistent DB connection pooling/proxying/load balancing system
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- LGPL20
- Categories
- databases
- Package size
- 2295.5 KiB, 13366.5 KiB installed
Description
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, Oracle, MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Interbase, Lago and SQLite with C, C++, Perl, Perl-DBD, Python, Python-DB, Zope, PHP, Ruby and Java APIs, command line clients, a GUI configuration tool and extensive documentation. The APIs support advanced database operations such as bind variables, multi-row fetches, client side result set caching and suspended transactions. It is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases and throttling database access.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/sqlrelay | 1.9.3_1 |
| NetBSD | databases/sqlrelay | 1.9.3nb15 |
| DragonFly | databases/sqlrelay | 1.9.3_1 |
Install
Binary package:
pkg install sqlrelay
From the ports tree:
cd /usr/ports/databases/sqlrelay/ && make install clean
To depend on this port in another port's Makefile:
RUN_DEPENDS= sqlrelay>0:databases/sqlrelay
LIB_DEPENDS= libsqlrodbc.so:databases/sqlrelay
Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 1.9.3_1 | 1.9.3_1 | 1.7.0 | 1.9.3_1 | 1.9.3_1 |
| FreeBSD:14:quarterly | 1.9.3_1 | 1.9.3_1 | n/a | 1.9.3_1 | 1.9.3_1 |
| FreeBSD:15:latest | 1.9.3_1 | 1.9.3_1 | n/a | 1.9.3_1 | 1.9.3_1 |
| FreeBSD:15:quarterly | 1.9.3_1 | 1.9.3_1 | n/a | n/a | n/a |
| FreeBSD:16:latest | 1.9.3_1 | 1.9.3_1 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Library 4
librudiments.so: devel/rudimentslibkrb5.so: security/krb5libcurl.so: ftp/curllibiconv.so: converters/libiconv
The full lists below include those, and their dependencies in turn.
Build dependencies 24
- archivers/brotli
- archivers/liblz4
- archivers/zstd
- converters/libiconv
- databases/lmdb0
- databases/openldap26-client
- devel/gettext-runtime
- devel/gmake
- devel/libedit
- devel/libffi
- devel/libunistring
- devel/readline
- devel/rudiments
- dns/libidn2
- dns/libpsl
- ftp/curl
- lang/python312
- math/mpdecimal
- print/indexinfo
- security/cyrus-sasl2
- security/krb5
- security/libssh2
- textproc/expat2
- www/libnghttp2
Run dependencies 23
- archivers/brotli
- archivers/liblz4
- archivers/zstd
- converters/libiconv
- databases/lmdb0
- databases/openldap26-client
- devel/gettext-runtime
- devel/libedit
- devel/libffi
- devel/libunistring
- devel/readline
- devel/rudiments
- dns/libidn2
- dns/libpsl
- ftp/curl
- lang/python312
- math/mpdecimal
- print/indexinfo
- security/cyrus-sasl2
- security/krb5
- security/libssh2
- textproc/expat2
- www/libnghttp2
Required by 1
Configuration
Options name: databases_${SQLRELAY_PORTNAME}
| Option | Default | Description |
|---|---|---|
| DOCS | off | Build and/or install documentation |
| FIREBIRD | off | Firebird (Interbase) database support |
| FREETDS | off | FreeTDS library support |
| MYSQL | off | MySQL database support |
| ODBC | off | ODBC database backend |
| ORACLE | off | Oracle database support |
| PGSQL | off | PostgreSQL database support |
| SQLITE3 | off | SQLite 3 database support |
- USES
- gmake iconv libedit libtool python readline ssl
- Service scripts
- none
Files
Manual pages 11
- sqlr-cachemanager(8)
- sqlr-connection(8)
- sqlr-export(1)
- sqlr-import(1)
- sqlr-listener(8)
- sqlr-pwdenc(8)
- sqlr-scaler(8)
- sqlr-start(8)
- sqlr-status(8)
- sqlr-stop(8)
- sqlrsh(1)
pkg-plist 190
- share/sqlrelay/examples/sqlrelay.conf
- libexec/sqlrelay/sqlrconnection_firebird.so
- libexec/sqlrelay/sqlrconnection_freetds.so
- libexec/sqlrelay/sqlrconnection_mysql.so
- lib/libsqlrodbc.so
- lib/libsqlrodbc.so.7
- lib/libsqlrodbc.so.7.0.0
- libexec/sqlrelay/sqlrconnection_odbc.so
- libexec/sqlrelay/sqlrpwdenc_aes128.so
- libexec/sqlrelay/sqlrconnection_postgresql.so
- libexec/sqlrelay/sqlrconnection_sqlite.so
- @dir etc/sqlrelay
- @dir /var/cache/sqlrelay
- @dir /var/log/sqlrelay
- @dir /var/log/sqlrelay/debug
- @dir /var/run/sqlrelay
- @sample etc/sqlrelay/conf.sample
- bin/sqlr-cachemanager
- bin/sqlr-connection
- bin/sqlr-export
- bin/sqlr-import
- bin/sqlr-listener
- bin/sqlr-pwdenc
- bin/sqlr-scaler
- bin/sqlr-start
- bin/sqlr-status
- bin/sqlr-stop
- bin/sqlrclient-config
- bin/sqlrclientwrapper-config
- bin/sqlrserver-config
- bin/sqlrsh
- etc/rc.d/sqlrcachemanager
- etc/rc.d/sqlrelay
- etc/sqlrelay/sqlrelay.xsd
- include/sqlrelay/private/sqlrexport.h
- include/sqlrelay/private/sqlrexportcsv.h
- include/sqlrelay/private/sqlrexportcsvincludes.h
- include/sqlrelay/private/sqlrexportincludes.h
- include/sqlrelay/private/sqlrexportxml.h
- include/sqlrelay/private/sqlrexportxmlincludes.h
- include/sqlrelay/private/sqlrimport.h
- include/sqlrelay/private/sqlrimportcsv.h
- include/sqlrelay/private/sqlrimportcsvincludes.h
- include/sqlrelay/private/sqlrimportincludes.h
- include/sqlrelay/private/sqlrimportxml.h
- include/sqlrelay/private/sqlrimportxmlincludes.h
- include/sqlrelay/private/sqlrresultsetdomnode.h
- include/sqlrelay/private/sqlrresultsetdomnodeincludes.h
- include/sqlrelay/private/sqlrauth.h
- include/sqlrelay/private/sqlrauths.h
- include/sqlrelay/private/sqlrbindvariabletranslation.h
- include/sqlrelay/private/sqlrbindvariabletranslations.h
- include/sqlrelay/private/sqlrclientincludes.h
- include/sqlrelay/private/sqlrclientwrapper.h
- include/sqlrelay/private/sqlrclientwrapperincludes.h
- include/sqlrelay/private/sqlrconnection.h
- include/sqlrelay/private/sqlrcursor.h
- include/sqlrelay/private/sqlrdirective.h
- include/sqlrelay/private/sqlrdirectives.h
- include/sqlrelay/private/sqlrfilter.h
- include/sqlrelay/private/sqlrfilters.h
- include/sqlrelay/private/sqlrgsscredentials.h
- include/sqlrelay/private/sqlrlistener.h
- include/sqlrelay/private/sqlrlogger.h
- include/sqlrelay/private/sqlrloggers.h
- include/sqlrelay/private/sqlrmoduledata.h
- include/sqlrelay/private/sqlrmoduledata_tag.h
- include/sqlrelay/private/sqlrmoduledatas.h
- include/sqlrelay/private/sqlrmysqlcredentials.h
- include/sqlrelay/private/sqlrnotification.h
- include/sqlrelay/private/sqlrnotifications.h
- include/sqlrelay/private/sqlrparser.h
- include/sqlrelay/private/sqlrpostgresqlcredentials.h
- include/sqlrelay/private/sqlrprotocol.h
- include/sqlrelay/private/sqlrprotocols.h
- include/sqlrelay/private/sqlrpwdenc.h
- include/sqlrelay/private/sqlrpwdencs.h
- include/sqlrelay/private/sqlrqueries.h
- include/sqlrelay/private/sqlrquery.h
- include/sqlrelay/private/sqlrquerycursor.h
- include/sqlrelay/private/sqlrresultsetheadertranslation.h
- include/sqlrelay/private/sqlrresultsetheadertranslations.h
- include/sqlrelay/private/sqlrresultsetrowblocktranslation.h
- include/sqlrelay/private/sqlrresultsetrowblocktranslations.h
- include/sqlrelay/private/sqlrresultsetrowtranslation.h
- include/sqlrelay/private/sqlrresultsetrowtranslations.h
- include/sqlrelay/private/sqlrresultsettranslation.h
- include/sqlrelay/private/sqlrresultsettranslations.h
- include/sqlrelay/private/sqlrrouter.h
- include/sqlrelay/private/sqlrrouters.h
- include/sqlrelay/private/sqlrschedule.h
- include/sqlrelay/private/sqlrschedulerule.h
- include/sqlrelay/private/sqlrschedules.h
- include/sqlrelay/private/sqlrserverconnection.h
- include/sqlrelay/private/sqlrservercontroller.h
- include/sqlrelay/private/sqlrservercursor.h
- include/sqlrelay/private/sqlrserverincludes.h
- include/sqlrelay/private/sqlrshm.h
- include/sqlrelay/private/sqlrtlscredentials.h
- include/sqlrelay/private/sqlrtranslation.h
The first 100 are listed.
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlrelay-1.9.3.tar.gz | 4.903142e+06 | f3f419591af839bf40509a6c2d76de7b2ea188f66e9d606692803bd7fa167b7e |
Master sites 1
- SF
Commit history 0
No commits in the history this site was built from.