I like it, easy to embed.HyperSQL
public static void initDB(String dbName, String altdbName,int svrPort) throws ClassNotFoundException{
server = new Server();
server.setSilent(true);
server.setLogWriter(null);
server.setDatabaseName(0, dbName);
server.setDatabasePath(0, "mem:"+dbName);
server.setDatabaseName(1, altdbName);
server.setDatabasePath(1, "file:"+altdbName);
server.setDatabaseName(2, "groovytest");
server.setDatabasePath(2, "mem:groovytest");
server.setPort((int)svrPort);
}SELECT * FROM read_json("glossary.json")
SELECT * FROM read_json('https://support.oneskyapp.com/hc/en-us/article_attachments/202761627')
SELECT * FROM read_csv('flights.csv', delim = '|', header = true, columns = { 'FlightDate': 'DATE', 'UniqueCarrier': 'VARCHAR', 'OriginCityName': 'VARCHAR', 'DestCityName': 'VARCHAR' });
SELECT * FROM 'https://domain.tld/file.extension';
SELECT
*
FROM
users AS u
JOIN read_parquet('s3://test-duckdb/project/9999-12-31/0.gzip.parquet') AS p
ON u.staff_project = p.id_project
Basically it is SQLiteStrange that https://db-engines.com/en/ranking has no PocketBase
a system based on SQLite
Do you use jdbc?When I was trying HSQLDB - I had it open 3 databases - 2 memory and one disk based. Think it took like 10 lines of java.
B4X:public static void initDB(String dbName, String altdbName,int svrPort) throws ClassNotFoundException{ server = new Server(); server.setSilent(true); server.setLogWriter(null); server.setDatabaseName(0, dbName); server.setDatabasePath(0, "mem:"+dbName); server.setDatabaseName(1, altdbName); server.setDatabasePath(1, "file:"+altdbName); server.setDatabaseName(2, "groovytest"); server.setDatabasePath(2, "mem:groovytest"); server.setPort((int)svrPort); }
Do you use jdbc?
Dim driver As String = "org.hsqldb.jdbc.JDBCDriver"
For p = 0 To chk - 1
Dim pp As String = ($"jdbc:hsqldb:hsql://localhost:${serverPort}/"$ & tables(p))
sqlnames(p).Initialize2(driver, pp, user(p), "")
NextWhat is the purpose of random server Port?I had it so the server would use a random port between 20000 and 30000 hence serverPortB4X:Dim driver As String = "org.hsqldb.jdbc.JDBCDriver" For p = 0 To chk - 1 Dim pp As String = ($"jdbc:hsqldb:hsql://localhost:${serverPort}/"$ & tables(p)) sqlnames(p).Initialize2(driver, pp, user(p), "") Next
If I was looking for a database I would start with 3306 - with random port,any client that connects once validated, would get the port number to connect to.What is the purpose of random server Port?
3306 is default port number used by MySQL.If I was looking for a database I would start with 3306 - with random port,any client that connects once validated, would get the port number to connect to.
It was declared the built-in CLI interface.directly create and edit the db
I prefer a GUI app if there exist.It was declared the built-in CLI interface.
H2 is good but not as efficient as SQLite. I’ve used it when I need multiple connections writing at the same time. It does slow down when the database gets big (slower than SQLite).Another good alternative is H2.
Why DuckDB
Why DuckDB There are many database management systems (DBMS) out there. But there is no one-size-fits all database system. All take different trade-offs to better adjust to specific use cases. DuckDB is no different. Here, we try to explain what goals DuckDB has and why and how we try to achieve...duckdb.org
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?