libbncsql

libbncsql is a sql multi-database connection api.

www.blacknoise.at

http/https Proxy

Client-A open a connection to server https://bncsql.foobar.com and verfiy, if configured, the server cert fingerprint ( e.g. 2e:e2:b1... ).
The server reject this connection if the client cert is unknown or the cert it not signed with the server-ca, thereby manage user/group/other access.
After a successful handshake the client is connected via (bi-directional) websocket to the database server.
Like openvpn, libbncsql is working with client/server tls-certificate, no other vpn setup is necessary and can considered as secure as your vpn.
Use the apache virtualhost setup, one internet-ip can serve for multi database connections, e.g.

• https://orders.mycustomer.com -> postgres
• http://report.xyz.com -> mysql
• https://bncsql.foobar.com -> mssql,mysql

Using http/https Proxy, a license is required for the bncsql-apache modul, developed by blacknoise.at, handling database connections.

Main Features

• data transfer from, e.g. ms-sql to postgresql
• simpler than odbc to configure
• fast C++ API with classes mapped from table
• python wrapper
• blob - binary data up to 4GB
• data sources: mysql, ms-sql, xls-read
• coming soon: oracle, postgres, unix-odbc
• coming soon: java wrapper
• open source, licensed under the apache license, version 2.0

Optional Services

• supported setup, e.g. secure tls connetions with your server, contact us here
• supported app development
• development training

Donate

support this project with your donation, please donate via PayPal or contact us here

Download

Android

• coming soon

iPhone, iPad

• coming soon

OS X 10.9 or later

• coming soon

Windows 7, 8, 10 (32/64 bit)

• coming soon

Linux

• libbncsql-1.0.1-linux-x86_64.tar.gz

Source Code

• libbncsql-1.0.1.tar.gz

SHA1

66f759210972185b3c419dd0564e5846c0c7c144 libbncsql-1.0.1-linux-x86_64.tar.gz
1c7dda1e72d3cc9d142c9b99cea7f1839c21d5b9 libbncsql-1.0.1.tar.gz

LICENSE

Copyright 2017-2018 blacknoise.at

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

bncSQLRSync.cpp, bncSQLRSync.h, bnplugincrt.h, bnpluginpy.cpp
bncSQLRSyncApp.py, bncSQLRSyncCrt.py ,bnplugin.py
Copyright 2017-2018 blacknoise.at

You may use this file WITHOUT CHANGES according to Apache License, Version 2.0.
Modifications of this file is NOT allowed without prior written permission.
For written permission, please contact us via http://www.blacknoise.at/?Contact

LICENSE NOTICE

"blacknoise.at bncsql" ( http://www.blacknoise.at/?bncsql )
Copyright 2017-2018 blacknoise.at

1. The names "bncsql/libbncsql" and "blacknoise.at bncsql/libbncsql" must not be used to
   endorse or promote products derived from this software without prior written permission.

2. Products derived from this software may not be called "bncsql/libbncsql"
   nor may "bncsql/libbncsql" appear in their names without prior written permission.

3. Any Logo from blacknoise.at must not be used without prior written permission.

4. Submitted code will be considert as donation, licensed to "blacknoise.at bncsql/libbncsql" without prior written permission.

For written permission, please contact us via bncsql@blacknoise.at

bncsql

simple business data, image viewer via SQL.
www.blacknoise.at

Main Features

• host your data on your own local systems, e.g. web-server
• display up to 4 tables, charts and images
• data sources: mysql, ms-sql, xls-read
• coming soon: oracle, postgres, unix-odbc
• open source, licensed under the apache license, version 2.0

Optional Services

• supported setup, e.g. secure tls connetions with your server
• customized version with your own logo, brand
• data hosting

Donate

support this project with your donation, please donate via PayPal or contact us here

Download

Google Play

Android (>= 2.2, with OpenGL ES 2)

• bncsql-1.0.1.2.apk

iPhone, iPad

• coming soon

OS X 10.9 or later

• bncsql-1.0.1-osx-x86_64.dmg

Windows 7, 8, 10 (32/64 bit)

• bncsql-1.0.1-windows-x86_64.exe
• bncsql-1.0.1-windows-i686.exe

Linux

• bncsql-1.0.1-linux-x86_64.tar.gz coming soon
• bncsql-1.0.1-linux-x86_64-minimal.tar.gz without Python, Kivy
• bncsql-1.0.1-linux-i686-minimal.tar.gz coming soon
• bncsql-1.0.1-linux-i686.tar.gz coming soon

Source Code

• bncsql-1.0.1.tar.gz
• bncsql-1.0.1-1.0.1.1.patch.gz
• bncsql-1.0.1-1.0.1.2.patch.gz
• libbncsql-1.0.1.tar.gz

SHA1

0b09e5faf7c087ecf9433def297330d788e218d6 bncsql-1.0.1-linux-x8664-minimal.tar.gz
a7ca2fdcb88088caa6e76454841af95172a47d0f bncsql-1.0.1-osx-x8664.dmg
bf6c1c794825a525b32f479e1474f1be81d9276c bncsql-1.0.1-windows-i686.exe
e6a49584db901e1cc9c7bac2cbbe76c6932b76f4 bncsql-1.0.1-windows-x86_64.exe
2947aaf7dcb73011c65c237320cd34d6075968e0 bncsql-1.0.1.apk
d02c83611cbf7f385cb433547e7a175e2d8da33d bncsql-1.0.1.tar.gz
fbee1dd7c0783e6288c25a9eecfaed6f0acbc9a2 bncsql-1.0.1-1.0.1.1.patch.gz
3bc416435cf6ad467151ee097eb621723b79434e bncsql-1.0.1-1.0.1.2.patch.gz
1c7dda1e72d3cc9d142c9b99cea7f1839c21d5b9 libbncsql-1.0.1.tar.gz

LICENSE

Copyright 2017-2018 blacknoise.at

Licensed under the Apache License, Version 2.0 (the License);
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an AS IS BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

bncSQLRSync.cpp, bncSQLRSync.h, bnplugincrt.h, bnpluginpy.cpp
bncSQLRSyncApp.py, bncSQLRSyncCrt.py ,bnplugin.py
Copyright 2017-2018 blacknoise.at

You may use this file WITHOUT CHANGES according to Apache License, Version 2.0.
Modifications of this file is NOT allowed without prior written permission.
For written permission, please contact us via http://www.blacknoise.at/?Contact

LICENSE NOTICE

blacknoise.at bncsql ( http://www.blacknoise.at/?bncsql )
Copyright 2017-2018 blacknoise.at

1. The names bncsql/libbncsql and blacknoise.at bncsql/libbncsql must not be used to
   endorse or promote products derived from this software without prior written permission.

2. Products derived from this software may not be called bncsql/libbncsql
   nor may bncsql/libbncsql appear in their names without prior written permission.

3. Any Logo from blacknoise.at must not be used without prior written permission.

4. Submitted code will be considert as donation, licensed to blacknoise.at bncsql/libbncsql without prior written permission.

For written permission, please contact us via bncsql@blacknoise.at