# \#database

**URL:** https://discourse.julialang.org/tag/database/823.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [AiresDB: We built a database engine in Julia for our university capstone project](https://discourse.julialang.org/t/airesdb-we-built-a-database-engine-in-julia-for-our-university-capstone-project/139476)

<div class="topic-metadata">

**Author:** [@aires-id](https://discourse.julialang.org/u/aires-id)\
**Replies:** 4\
**Last updated:** [September 16, 2026, 1:46pm UTC](https://discourse.julialang.org/t/airesdb-we-built-a-database-engine-in-julia-for-our-university-capstone-project/139476 "2026-09-16T13:46:58Z")

</div>

Hi everyone! We are three Oil & Gas Engineering students from Institut Teknologi Sumatera (ITERA), Indonesia, and for our university capstone project we decided to do something slightly unusual: build a database engine…

---

## [\[ANN\] SemaDbAPI.jl - Julia Client for SemaDB Vector Database](https://discourse.julialang.org/t/ann-semadbapi-jl-julia-client-for-semadb-vector-database/132372)

<div class="topic-metadata">

**Author:** [@hamza\_souidi](https://discourse.julialang.org/u/hamza_souidi)\
**Replies:** 0\
**Last updated:** [September 14, 2025, 3:38pm UTC](https://discourse.julialang.org/t/ann-semadbapi-jl-julia-client-for-semadb-vector-database/132372 "2025-09-14T15:38:19Z")

</div>

I’m excited to announce SemaDbAPI.jl, a new Julia client package for interacting with SemaDB, a high-performance vector database designed for similarity search and semantic operations. Why SemaDbAPI.jl? Vector databases…

---

## [When is it worth it to setup a database rather than to just organize the data into files?](https://discourse.julialang.org/t/when-is-it-worth-it-to-setup-a-database-rather-than-to-just-organize-the-data-into-files/127539)

<div class="topic-metadata">

**Author:** [@AwesomeQuest](https://discourse.julialang.org/u/AwesomeQuest)\
**Replies:** 2\
**Last updated:** [March 31, 2025, 2:30pm UTC](https://discourse.julialang.org/t/when-is-it-worth-it-to-setup-a-database-rather-than-to-just-organize-the-data-into-files/127539 "2025-03-31T14:30:38Z")

</div>

I’m building a library of example spectra for chemical analysis and I’m wondering what the benefits would be to setting up a database in mySQL or something with these spectra rather than just having files in folders with…

---

## [How do I properly close a DuckDb database?](https://discourse.julialang.org/t/how-do-i-properly-close-a-duckdb-database/100598)

<div class="topic-metadata">

**Author:** [@kobusherbst](https://discourse.julialang.org/u/kobusherbst)\
**Replies:** 20\
**Last updated:** [February 21, 2025, 1:44am UTC](https://discourse.julialang.org/t/how-do-i-properly-close-a-duckdb-database/100598 "2025-02-21T01:44:28Z")

</div>

I cannot run the following code twice in one julia session: using DuckDB using DBInterface db = DuckDB.DB("C:\\\\Temp\\\\test.duckdb") t = DBInterface.execute(db, "SELECT 1") DuckDB.close\_database(db) On the second run …

---

## [Very Slow \`DBInterface.execute\` on large duckdb relative to R](https://discourse.julialang.org/t/very-slow-dbinterface-execute-on-large-duckdb-relative-to-r/121984)

<div class="topic-metadata">

**Author:** [@floswald](https://discourse.julialang.org/u/floswald)\
**Replies:** 4\
**Last updated:** [October 30, 2024, 9:11pm UTC](https://discourse.julialang.org/t/very-slow-dbinterface-execute-on-large-duckdb-relative-to-r/121984 "2024-10-30T21:11:59Z")

</div>

Hi all, I’ve made a clone of @grantmcdermott 's nice workshop on duckdb and polars - adding a chapter on julia and duckdb. He had pointed out some very slow julia timings in his slides, and actually created an issue on …

---

## [\[ANN\] SQLCollections.jl – use Julia data manipulation functions for databases](https://discourse.julialang.org/t/ann-sqlcollections-jl-use-julia-data-manipulation-functions-for-databases/119244)

<div class="topic-metadata">

**Author:** [@aplavin](https://discourse.julialang.org/u/aplavin)\
**Replies:** 31\
**Last updated:** [October 28, 2024, 6:01pm UTC](https://discourse.julialang.org/t/ann-sqlcollections-jl-use-julia-data-manipulation-functions-for-databases/119244 "2024-10-28T18:01:39Z")

</div>

Imagine if you could use the exact same code to manipulate regular Julia collections and SQL tables… SQLCollections.jl is the package to achieve that! There is no shortage of Julia packages that provide convenient int…

---

## [Calling database functions when using Octo.jl](https://discourse.julialang.org/t/calling-database-functions-when-using-octo-jl/114044)

<div class="topic-metadata">

**Author:** [@suvayu](https://discourse.julialang.org/u/suvayu)\
**Replies:** 5\
**Last updated:** [June 13, 2024, 7:18pm UTC](https://discourse.julialang.org/t/calling-database-functions-when-using-octo-jl/114044 "2024-06-13T19:18:14Z")

</div>

I’m trying out Octo.jl with DuckDB. I managed to connect to an existing file and query a table there. julia\> import DataFrames as DF; julia\> using Octo.Adapters.DuckDB julia\> con = Repo.connect(adapter=Octo.Adapters.D…

---

## [Vector Database in Julia: bad idea?](https://discourse.julialang.org/t/vector-database-in-julia-bad-idea/97371)

<div class="topic-metadata">

**Author:** [@gvdr](https://discourse.julialang.org/u/gvdr)\
**Replies:** 19\
**Last updated:** [May 21, 2024, 5:00am UTC](https://discourse.julialang.org/t/vector-database-in-julia-bad-idea/97371 "2024-05-21T05:00:40Z")

</div>

Floating an idea: has anybody tried to build a vector database (think Pinecone or Weaviate) in pure Julia? If not, is there a specific reason why it’s a bad idea?

---

## [Why Is There a Significant Slow-down with DuckDB.jl Bridging?](https://discourse.julialang.org/t/why-is-there-a-significant-slow-down-with-duckdb-jl-bridging/109426)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 1\
**Last updated:** [January 30, 2024, 11:25pm UTC](https://discourse.julialang.org/t/why-is-there-a-significant-slow-down-with-duckdb-jl-bridging/109426 "2024-01-30T23:25:30Z")

</div>

I did an interesting little exploration with DuckDB.jl + bridging to another local database of a different SQL flavor today (SQLite). Here’s what I did: using BenchmarkTools using DBInterface using DuckDB using HealthSa…

---

## [Endatabas: An SQL Document Database with Full History](https://discourse.julialang.org/t/endatabas-an-sql-document-database-with-full-history/109230)

<div class="topic-metadata">

**Author:** [@g-gundam](https://discourse.julialang.org/u/g-gundam)\
**Replies:** 0\
**Last updated:** [January 25, 2024, 2:15am UTC](https://discourse.julialang.org/t/endatabas-an-sql-document-database-with-full-history/109230 "2024-01-25T02:15:37Z")

</div>

I was recently introduced to a new database called Endatabas, and the way it works is so interesting to me. Check their very brief intro video out: My takeaways It has no schema. When you insert data, the…

---

## [Write a table into SQLite and DuckDB in efficient manner](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417)

<div class="topic-metadata">

**Author:** [@sairus7](https://discourse.julialang.org/u/sairus7)\
**Replies:** 24\
**Last updated:** [December 8, 2023, 3:25am UTC](https://discourse.julialang.org/t/write-a-table-into-sqlite-and-duckdb-in-efficient-manner/93417 "2023-12-08T03:25:25Z")

</div>

How can I efficiently populate DB table from very long tables (say, millions rows)? I try to compare SQlite vs DuckDB in this scenario, but I think I’m doing this very inefficiently: using SQLite, DuckDB, Tables con\_sq…

---

## [Connecting Julia to DB2 LUW database](https://discourse.julialang.org/t/connecting-julia-to-db2-luw-database/105770)

<div class="topic-metadata">

**Author:** [@brianhfield](https://discourse.julialang.org/u/brianhfield)\
**Replies:** 4\
**Last updated:** [November 3, 2023, 9:14pm UTC](https://discourse.julialang.org/t/connecting-julia-to-db2-luw-database/105770 "2023-11-03T21:14:28Z")

</div>

Fairly new to Julia. I am trying to determine if it is possible to query a DB2 LUW database directly with Julia and I haven’t found any definitive answers so far. Does anyone here happen to know? Is there a package I …

---

## [\[Call for Collaborators\]: Tool for Extracting Treatment Pathways in Patient Populations Standardized in the OMOP CDM](https://discourse.julialang.org/t/call-for-collaborators-tool-for-extracting-treatment-pathways-in-patient-populations-standardized-in-the-omop-cdm/105704)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 0\
**Last updated:** [November 2, 2023, 2:34pm UTC](https://discourse.julialang.org/t/call-for-collaborators-tool-for-extracting-treatment-pathways-in-patient-populations-standardized-in-the-omop-cdm/105704 "2023-11-02T14:34:34Z")

</div>

Hi folks :wave: This is a call for collaborators for a project I am starting! I’d love collaborators on this work if you are interested in the idea; I’ll be working on it at any rate! Details as follows: Title: Tool f…

---

## [Recommend a parsing library for LibPQ.jl?](https://discourse.julialang.org/t/recommend-a-parsing-library-for-libpq-jl/96023)

<div class="topic-metadata">

**Author:** [@iamed2](https://discourse.julialang.org/u/iamed2)\
**Replies:** 1\
**Last updated:** [March 13, 2023, 10:14pm UTC](https://discourse.julialang.org/t/recommend-a-parsing-library-for-libpq-jl/96023 "2023-03-13T22:14:47Z")

</div>

I’m looking to improve the parsing code in LibPQ and expand support for more data types. PCRE2 is expensive and heavyweight, but it’s a challenge to write each parser from scratch and I don’t want to reinvent the wheel. …

---

## [Save data into mysql database in batch mode on transaction basis](https://discourse.julialang.org/t/save-data-into-mysql-database-in-batch-mode-on-transaction-basis/95838)

<div class="topic-metadata">

**Author:** [@Sandy45](https://discourse.julialang.org/u/Sandy45)\
**Replies:** 2\
**Last updated:** [March 13, 2023, 4:43am UTC](https://discourse.julialang.org/t/save-data-into-mysql-database-in-batch-mode-on-transaction-basis/95838 "2023-03-13T04:43:13Z")

</div>

I am trying to load data(from df) into mysql database in batch mode, Loading should be on single transaction and data should be rolled back if load fails at any stage during batch processing. I’ve coded currently by usin…

---

## [TimeSeries Database](https://discourse.julialang.org/t/timeseries-database/94920)

<div class="topic-metadata">

**Author:** [@harsh\_kumar](https://discourse.julialang.org/u/harsh_kumar)\
**Replies:** 8\
**Last updated:** [February 21, 2023, 8:24pm UTC](https://discourse.julialang.org/t/timeseries-database/94920 "2023-02-21T20:24:08Z")

</div>

I have a process (websocket) that push data into a channel on realtime (couple of item every second). Each data points has a timestamp, group columns, and additional fields. I want to store this data on continuous basis …

---

## [\[ANN\] OMOPCDMCohortCreator.jl v0.2.0 - Docs, Tests, Features Oh My!](https://discourse.julialang.org/t/ann-omopcdmcohortcreator-jl-v0-2-0-docs-tests-features-oh-my/89179)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 0\
**Last updated:** [October 24, 2022, 5:11am UTC](https://discourse.julialang.org/t/ann-omopcdmcohortcreator-jl-v0-2-0-docs-tests-features-oh-my/89179 "2022-10-24T05:11:39Z")

</div>

Hi everyone, It is with pride that my colleagues and I announce the release of OMOPCDMCohortCreator.jl 0.2.0! :tada: Some of the biggest updates are that: The documentation has received a massive update with fantasti…

---

## [Influxdb client package](https://discourse.julialang.org/t/influxdb-client-package/82890)

<div class="topic-metadata">

**Author:** [@gmouts](https://discourse.julialang.org/u/gmouts)\
**Replies:** 8\
**Last updated:** [October 12, 2022, 10:08am UTC](https://discourse.julialang.org/t/influxdb-client-package/82890 "2022-10-12T10:08:42Z")

</div>

I’m looking into getting data from influxdb. I found this package but it seems abandoned. Is this functionality added somewhere else or this is all there is?

---

## [TLS Version is not supported MySQL error](https://discourse.julialang.org/t/tls-version-is-not-supported-mysql-error/84422)

<div class="topic-metadata">

**Author:** [@Mitch](https://discourse.julialang.org/u/Mitch)\
**Replies:** 7\
**Last updated:** [July 28, 2022, 12:05pm UTC](https://discourse.julialang.org/t/tls-version-is-not-supported-mysql-error/84422 "2022-07-28T12:05:59Z")

</div>

Hi everyone, I have an Azure MySQL Database I’m trying to connect to using: DBInterface.connect(MySQL.Connection, host, user, pass, db = dbname); host, user, pass and dbname are string inputs. I’m receiving the error…

---

## [What is the currently recommended way to access a postgres database?](https://discourse.julialang.org/t/what-is-the-currently-recommended-way-to-access-a-postgres-database/75862)

<div class="topic-metadata">

**Author:** [@met-j](https://discourse.julialang.org/u/met-j)\
**Replies:** 3\
**Last updated:** [February 23, 2022, 9:03am UTC](https://discourse.julialang.org/t/what-is-the-currently-recommended-way-to-access-a-postgres-database/75862 "2022-02-23T09:03:56Z")

</div>

My search made it look like the LibPQ.jl wrapper would be the most popular way to access a PostgreSQL database. Is there something else I should look at?

---

## [How to Create a Table in a DataBase Using DataFrames?](https://discourse.julialang.org/t/how-to-create-a-table-in-a-database-using-dataframes/75759)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 3\
**Last updated:** [February 4, 2022, 2:34pm UTC](https://discourse.julialang.org/t/how-to-create-a-table-in-a-database-using-dataframes/75759 "2022-02-04T14:34:40Z")

</div>

Hi all! I tried looking through the documentation, but I could not find it readily - is there a way to write a DataFrame to either a Postgresql (via LibPQ.jl) or MySQL (via MySQL.jl) database as a new table? Ideally, i…

---

## [Unable to connect to postgress with libPQ](https://discourse.julialang.org/t/unable-to-connect-to-postgress-with-libpq/70906)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 7\
**Last updated:** [November 6, 2021, 12:44am UTC](https://discourse.julialang.org/t/unable-to-connect-to-postgress-with-libpq/70906 "2021-11-06T00:44:26Z")

</div>

conn2 = LibPQ.Connection("dbname=postgres") tells me that I can’t find Unix domain socket "/tmp/.s.PGSQL.5432"? I’m using Ubuntu 20.04.3 LTS on an x86 Xeon machine. I’ve had the same issue with Crystal. Postgress i…

---

## [Unable to successfully read sqlserver Date datatype \[ODBC, DataFrames\]](https://discourse.julialang.org/t/unable-to-successfully-read-sqlserver-date-datatype-odbc-dataframes/70072)

<div class="topic-metadata">

**Author:** [@vtomar](https://discourse.julialang.org/u/vtomar)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 8:13pm UTC](https://discourse.julialang.org/t/unable-to-successfully-read-sqlserver-date-datatype-odbc-dataframes/70072 "2021-10-20T20:13:01Z")

</div>

i have a very simple query: using ODBC, Dates, DataFrames query = "select id, convert(date, ColumnName1) as CalendarDate from table1" conn = DBInterface.connect(ODBC.Connection, "ConnectionString"); statement = DBInter…

---

## [DBInterface specify types?](https://discourse.julialang.org/t/dbinterface-specify-types/69956)

<div class="topic-metadata">

**Author:** [@Lincoln\_Hannah](https://discourse.julialang.org/u/Lincoln_Hannah)\
**Replies:** 0\
**Last updated:** [October 18, 2021, 2:21am UTC](https://discourse.julialang.org/t/dbinterface-specify-types/69956 "2021-10-18T02:21:36Z")

</div>

Is there an equivalent of CSV.read types= e.g. DBInterface.execute( "select statement", types = Dict( Col1 =\> Date, ... ) ) Querying SQL server, DateTime comes through ok, but Date becames a string

---

## [Firebird database in Julia?](https://discourse.julialang.org/t/firebird-database-in-julia/33295)

<div class="topic-metadata">

**Author:** [@Darione](https://discourse.julialang.org/u/Darione)\
**Replies:** 6\
**Last updated:** [October 2, 2021, 12:40pm UTC](https://discourse.julialang.org/t/firebird-database-in-julia/33295 "2021-10-02T12:40:42Z")

</div>

Hello, we use Firebird database in our compnay, for our Erp software. I was trying to use a firebird driver for Julia, and i found this: But I, who am a beginner, cannot import the package … I have this error … (i a…