# \#sql

**URL:** https://discourse.julialang.org/tag/sql/710.md

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

---

## [DuckDB, FunSQL.jl, reading data](https://discourse.julialang.org/t/duckdb-funsql-jl-reading-data/127119)

<div class="topic-metadata">

**Author:** [@jerlich](https://discourse.julialang.org/u/jerlich)\
**Replies:** 0\
**Last updated:** [March 18, 2025, 9:20pm UTC](https://discourse.julialang.org/t/duckdb-funsql-jl-reading-data/127119 "2025-03-18T21:20:34Z")

</div>

Expanding Man Wednesday at 2:27 PM using DuckDB to interact with files, granting full query ability for files, really is great. The only thing that sucks about it is having to deal with SQL. I’m increasingly tempted to …

---

## [Batch insertion using MySQL.jl](https://discourse.julialang.org/t/batch-insertion-using-mysql-jl/115938)

<div class="topic-metadata">

**Author:** [@tom-plaa](https://discourse.julialang.org/u/tom-plaa)\
**Replies:** 1\
**Last updated:** [June 21, 2024, 12:58pm UTC](https://discourse.julialang.org/t/batch-insertion-using-mysql-jl/115938 "2024-06-21T12:58:56Z")

</div>

I am trying to change some functions that insert into my MariaDB database so that they will work in batches instead of row-by-row. I am having somewhat of a hard time because I don’t really understand how to prepare stat…

---

## [Database backed for DataFrames](https://discourse.julialang.org/t/database-backed-for-dataframes/94768)

<div class="topic-metadata">

**Author:** [@ayushpatnaikgit](https://discourse.julialang.org/u/ayushpatnaikgit)\
**Replies:** 6\
**Last updated:** [May 4, 2024, 3:05am UTC](https://discourse.julialang.org/t/database-backed-for-dataframes/94768 "2024-05-04T03:05:54Z")

</div>

Any package in Julia like R’s dbplyr? dbplyr allows you to use remote database tables as if they are in-memory data frames by automatically converting dplyr code into SQL. I want to do the same with DataFrames and SQL.

---

## [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…

---

## [One batch containing many SQL commands using ODBC.jl does not work with SQL Server](https://discourse.julialang.org/t/one-batch-containing-many-sql-commands-using-odbc-jl-does-not-work-with-sql-server/108856)

<div class="topic-metadata">

**Author:** [@Miroslav-Stimac](https://discourse.julialang.org/u/Miroslav-Stimac)\
**Replies:** 5\
**Last updated:** [January 16, 2024, 1:16pm UTC](https://discourse.julialang.org/t/one-batch-containing-many-sql-commands-using-odbc-jl-does-not-work-with-sql-server/108856 "2024-01-16T13:16:52Z")

</div>

Hello, I am using ODBC.jl to create a connection to a Microsoft SQL Server Database. conn = ODBC.Connection(Driver=ODBC Driver 17 for SQL Server;SERVER=MyServer;DATABASE=MyDatabase;Trusted\_Connection=Yes") Then I am e…

---

## [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…

---

## [SQL syntax hightlighting](https://discourse.julialang.org/t/sql-syntax-hightlighting/103845)

<div class="topic-metadata">

**Author:** [@Lincoln\_Hannah](https://discourse.julialang.org/u/Lincoln_Hannah)\
**Replies:** 6\
**Last updated:** [September 15, 2023, 1:25pm UTC](https://discourse.julialang.org/t/sql-syntax-hightlighting/103845 "2023-09-15T13:25:15Z")

</div>

This provides syntax highlighting and auto-completion of SQL in VS Code. Would it be possible to have a section in a .jl file that VS Code treats as SQL (for syntax highlight and autocompletion) ? Then convert the r…

---

## [Julia, ODBC connection to a remote MS SQL Server](https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374)

<div class="topic-metadata">

**Author:** [@jamaas](https://discourse.julialang.org/u/jamaas)\
**Replies:** 10\
**Last updated:** [August 2, 2023, 3:54pm UTC](https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374 "2023-08-02T15:54:57Z")

</div>

I have been using R to connect to a remote MS SQL Server database, from Ubuntu Linux 21.10 and it works quite well. I’d like to do the same thing from Julia but can not make the connection using the ODBC package. Does …

---

## [Is it worthwhile for a regular Julia user to learn SQL?](https://discourse.julialang.org/t/is-it-worthwhile-for-a-regular-julia-user-to-learn-sql/95387)

<div class="topic-metadata">

**Author:** [@oviedorodolfo](https://discourse.julialang.org/u/oviedorodolfo)\
**Replies:** 4\
**Last updated:** [March 4, 2023, 2:03am UTC](https://discourse.julialang.org/t/is-it-worthwhile-for-a-regular-julia-user-to-learn-sql/95387 "2023-03-04T02:03:56Z")

</div>

Is it worthwhile to learn SQL for someone who will seldom need to access SQL databases? I so, what dialect?

---

## [Help in Bulk Insert with ODBC connection](https://discourse.julialang.org/t/help-in-bulk-insert-with-odbc-connection/77892)

<div class="topic-metadata">

**Author:** [@folleyz](https://discourse.julialang.org/u/folleyz)\
**Replies:** 4\
**Last updated:** [March 15, 2022, 3:04pm UTC](https://discourse.julialang.org/t/help-in-bulk-insert-with-odbc-connection/77892 "2022-03-15T15:04:32Z")

</div>

Hi guys! Me again :grin: Now i need help to make an Insert Statement, i’m trying with: insert\_query = "INSERT INTO resumoValores (Data, Unidade, Total\_Fechamento\_SIDG) values(?,?,?)" stmt = DBInterface.prepare(cn…

---

## [Recommendations for Julia & SQL Workflow with Jupyter or VSCode](https://discourse.julialang.org/t/recommendations-for-julia-sql-workflow-with-jupyter-or-vscode/76698)

<div class="topic-metadata">

**Author:** [@Ouji](https://discourse.julialang.org/u/Ouji)\
**Replies:** 14\
**Last updated:** [February 25, 2022, 1:43pm UTC](https://discourse.julialang.org/t/recommendations-for-julia-sql-workflow-with-jupyter-or-vscode/76698 "2022-02-25T13:43:44Z")

</div>

Earlier, I went to Neptune, then Pluto, and I was in the process of finding a kind of setup for Julia and SQL. So far, I’ve had some success, but I’m not there yet. I thought that maybe I went about it the wrong way. So …

---

## [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?

---

## [SQLite.jl NOT NULL constraint failed](https://discourse.julialang.org/t/sqlite-jl-not-null-constraint-failed/74628)

<div class="topic-metadata">

**Author:** [@Jeremy](https://discourse.julialang.org/u/Jeremy)\
**Replies:** 0\
**Last updated:** [January 14, 2022, 2:52pm UTC](https://discourse.julialang.org/t/sqlite-jl-not-null-constraint-failed/74628 "2022-01-14T14:52:04Z")

</div>

Since updating Julia from v1.6.2 (SQLite v1.2.0) to v1.7.1 (SQLite v 1.3.0) I get an error while trying to add data to an existing table in my database. julia\> dataBiomet |\> SQLite.load!(db,"Biomet") ERROR: SQLiteExcept…

---

## [Hiring Student Assistants at Georgia Tech Research Institute](https://discourse.julialang.org/t/hiring-student-assistants-at-georgia-tech-research-institute/70167)

<div class="topic-metadata">

**Author:** [@TheCedarPrince](https://discourse.julialang.org/u/TheCedarPrince)\
**Replies:** 0\
**Last updated:** [October 21, 2021, 4:25pm UTC](https://discourse.julialang.org/t/hiring-student-assistants-at-georgia-tech-research-institute/70167 "2021-10-21T16:25:52Z")

</div>

Hi everyone! I am currently looking to hire a student assistant to work with me at Georgia Tech Research Institute! If you are interested in advancing research in public health, healthcare analytics, and health equity,…

---

## [Is there anyone that is an expert in SQL?](https://discourse.julialang.org/t/is-there-anyone-that-is-an-expert-in-sql/68766)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 8\
**Last updated:** [October 1, 2021, 7:54pm UTC](https://discourse.julialang.org/t/is-there-anyone-that-is-an-expert-in-sql/68766 "2021-10-01T19:54:02Z")

</div>

I was trying to use PostgresSQL in an accounting program, but I couldn’t get it to load. I want to know the best options for relational databases, and how to integrate them into my code.

---

## [Is there an idiomatic way to select a single value from a SQL query?](https://discourse.julialang.org/t/is-there-an-idiomatic-way-to-select-a-single-value-from-a-sql-query/68962)

<div class="topic-metadata">

**Author:** [@gleyland](https://discourse.julialang.org/u/gleyland)\
**Replies:** 3\
**Last updated:** [October 1, 2021, 7:59am UTC](https://discourse.julialang.org/t/is-there-an-idiomatic-way-to-select-a-single-value-from-a-sql-query/68962 "2021-10-01T07:59:23Z")

</div>

Hi, Some SQL queries (like “SELECT COUNT(\*)…”) return a single value. The shortest way I’ve managed to come up with for obtaining the result of the query is: using SQLite db = SQLite.DB() SQLite.DBInterface.execute(db…

---

## [Reading string including Greek letters from SQL server](https://discourse.julialang.org/t/reading-string-including-greek-letters-from-sql-server/68682)

<div class="topic-metadata">

**Author:** [@mobar](https://discourse.julialang.org/u/mobar)\
**Replies:** 2\
**Last updated:** [September 26, 2021, 7:40pm UTC](https://discourse.julialang.org/t/reading-string-including-greek-letters-from-sql-server/68682 "2021-09-26T19:40:57Z")

</div>

I need to store serialized JSON strings of types that include Greek letters (such as λ) on an sql server table. Storing works just fine (field defined as nvarchar(max) data type) and sql prefixed with N) - but I’m havin…

---

## [Not able to load PostgreSQL into LibPQ.jl](https://discourse.julialang.org/t/not-able-to-load-postgresql-into-libpq-jl/68767)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 20\
**Last updated:** [September 26, 2021, 3:45am UTC](https://discourse.julialang.org/t/not-able-to-load-postgresql-into-libpq-jl/68767 "2021-09-26T03:45:21Z")

</div>

I have installed postgressql, and am trying to use the LibPQ.jl . But, when I try to connect conn = LibPQ.Connection("dbname=postgres user=BrettKnoss) I’m told that. conn= could not connect to server: No such file or…

---

## [OHDSICohortExpressions.jl](https://discourse.julialang.org/t/ohdsicohortexpressions-jl/62525)

<div class="topic-metadata">

**Author:** [@cce](https://discourse.julialang.org/u/cce)\
**Replies:** 1\
**Last updated:** [June 7, 2021, 3:07pm UTC](https://discourse.julialang.org/t/ohdsicohortexpressions-jl/62525 "2021-06-07T15:07:57Z")

</div>

Observational Health Data Sciences and Informatics (or OHDSI) is a program to bring out the value of health data through large-scale analytics. OHDSI defines the OMOP CDM, a data warehouse database schema for storing …