Access directly your SQL databases via HTTP. From all devices. In full security.

1. Connection to a remote database:

string server = "https://www.acme.com/aceql";
string database = "sampledb";

string connectionString = $"Server={server}; Database={database}";
string username = "MyUsername"; // User & Password are hardcoded to simplify our sample...
char[] password = { 'M', 'y', 'S', 'e', 'c', 'r', 'e', 't' };

AceQLConnection connection = new AceQLConnection(connectionString)
{
    Credential = new AceQLCredential(username, password)
};

// Attempt to establish a connection to the remote SQL database:
await connection.OpenAsync();
Console.WriteLine("Successfully connected to database " + database + "!");

2. SELECT on the remote database:

string sql = "select * from customer where customer_id = 1";

using AceQLCommand command = new AceQLCommand(sql, connection);
using AceQLDataReader dataReader = await command.ExecuteReaderAsync();
while (dataReader.Read())
{
    Console.WriteLine();
    Console.WriteLine("customer_id   : " + dataReader.GetValue(0));
    Console.WriteLine("customer_title: " + dataReader.GetValue(1));
    Console.WriteLine("lname         : " + dataReader.GetValue(2));
}

Connection to a remote database:

# URL of the AceQL server, Remote SQL database name authentication info
url = "https://www.acme.com/aceql"

# User & Password are hardcoded to simplify our sample...
username = "user1"
password = "password1"
database = "sampledb"

# Attempts to establish a connection to the remote database:
connection = aceql.connect(url=url, username=username, password=password, database=database)

SELECT on the remote database:

cursor = connection.cursor()
sql = "SELECT CUSTOMER_ID, FNAME, LNAME FROM CUSTOMER WHERE CUSTOMER_ID = ?"
params = (1,)
cursor.execute(sql, params)
row = cursor.fetchone()
print(row)