DuckDB - anyone tried ?

[aeric]

Just https://www.b4x.com/android/forum/threads/duckdb-anyone-tried.162155/post-994686

Comparison : https://db-engines.com/en/system/DuckDB;SQLite

It's initial release was in 2018. It just hit version 1.0.0 on last month, June 2024.

 

[amorosik]

Just https://www.b4x.com/android/forum/threads/duckdb-anyone-tried.162155/post-994686

Comparison : https://db-engines.com/en/system/DuckDB;SQLite

Yes, I had already tried the comparison
Which seems to me to go in favor of Sqlite due to the availability of the triggers (which however I assume are also available on DuckDb)
This is why I asked, why prefer DuckDb over the classic Sqlite, it seems to me there are no substantial differences

 

[aeric]

I made a first test using JDBC.

'Non-UI application (console / server application)
#Region Project Attributes
    #CommandLineArgs:
    #MergeLibraries: True
    #AdditionalJar: duckdb_jdbc-1.0.0
#End Region

Sub Process_Globals
    Private SQL As SQL
End Sub

Sub AppStart (Args() As String)
    Example
    StartMessageLoop
End Sub

Sub Example
    Try
        SQL.Initialize("org.duckdb.DuckDBDriver", "jdbc:duckdb:")
        Dim rs As ResultSet = SQL.ExecQuery("SELECT current_timestamp")
        Do While rs.NextRow
            Log(rs.GetString2(0))
        Loop
    Catch
        Log(LastException)
    End Try
End Sub

Note:
duckdb_jdbc-1.0.0.jar is 63.2MB
sqlite-jdbc is around 12.8MB

Release jar of the above example = 63MB took 45 seconds to compile on my machine.
Similar jar using SQLite in-memory = 12MB took 6 seconds to compile.

 

[peacemaker]

SELECT * FROM read_json('https://support.oneskyapp.com/hc/en-us/article_attachments/202761627')

Works !

p.s. Compiled .jar is indeed 63 MB ! (sic!)

 

[peacemaker]

Under Android JDBC example:

Caused by: java.lang.IllegalStateException: Unsupported system architecture

So, curious by online-requests, but huge and non-universal for B4X.

 

[Daestrum]

it only has these OS's in it