# \#help-database

**URL:** https://discourse.julialang.org/tag/help-database/244.md

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

---

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

---

## [Randomized SVD](https://discourse.julialang.org/t/randomized-svd/98488)

<div class="topic-metadata">

**Author:** [@Desmond](https://discourse.julialang.org/u/Desmond)\
**Replies:** 6\
**Last updated:** [May 8, 2023, 10:25pm UTC](https://discourse.julialang.org/t/randomized-svd/98488 "2023-05-08T22:25:37Z")

</div>

I am implement the randomized SVD without power iteration and I am just getting a black and white dots as the output of the SVD. I can’t seem to spot the problem. Here is the code function rsvd(X,k) (m,n)=size(X) …

---

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

---

## [Need Help with accented characters](https://discourse.julialang.org/t/need-help-with-accented-characters/77699)

<div class="topic-metadata">

**Author:** [@folleyz](https://discourse.julialang.org/u/folleyz)\
**Replies:** 5\
**Last updated:** [March 10, 2022, 6:58pm UTC](https://discourse.julialang.org/t/need-help-with-accented-characters/77699 "2022-03-10T18:58:56Z")

</div>

Hello, i’m new in Julia and i’m facing a problem with accented characters like ã or á. I loaded a dataframe from my SQLServer Database using ODBC and i’m having trouble to Uppercase the column “unidade”, i think this oc…

---

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

---

## [How do I change the values of a dataframe within a dictionary](https://discourse.julialang.org/t/how-do-i-change-the-values-of-a-dataframe-within-a-dictionary/67231)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 11\
**Last updated:** [August 29, 2021, 5:26pm UTC](https://discourse.julialang.org/t/how-do-i-change-the-values-of-a-dataframe-within-a-dictionary/67231 "2021-08-29T17:26:06Z")

</div>

I’d like to know how to change the values of a dataframe, and ultimately a dataframe within a dictionary. starting\_balance=( starting\_balance\["debit"\]\["assets"\]\[account\]=\>( DataFrame( date=Vector{String}("31 …

---

## [Adding Julia itself to juliahub?](https://discourse.julialang.org/t/adding-julia-itself-to-juliahub/66582)

<div class="topic-metadata">

**Author:** [@Bardo](https://discourse.julialang.org/u/Bardo)\
**Replies:** 4\
**Last updated:** [August 18, 2021, 8:15am UTC](https://discourse.julialang.org/t/adding-julia-itself-to-juliahub/66582 "2021-08-18T08:15:43Z")

</div>

I (re-)discovered juliahub to search also for help and code snippets. But then I wondered why the biggest package (Julia itself) seems not be included. Could the owner add it? - That would make a nice help interface. T…

---

## [I can't get Julia to work in VS Code, because the Path JSON is a mess](https://discourse.julialang.org/t/i-cant-get-julia-to-work-in-vs-code-because-the-path-json-is-a-mess/54714)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 3\
**Last updated:** [February 11, 2021, 10:13am UTC](https://discourse.julialang.org/t/i-cant-get-julia-to-work-in-vs-code-because-the-path-json-is-a-mess/54714 "2021-02-11T10:13:39Z")

</div>

I was trying to change my JSON to create a path to PyDev, and now none of my extensions work. It’s not recognizing an array for some reason (I’m not familiar with JSON or JavaScript in general) } "terminal.integrat…

---

## [Connect to Redshift with SearchLightPostgreSQL](https://discourse.julialang.org/t/connect-to-redshift-with-searchlightpostgresql/53646)

<div class="topic-metadata">

**Author:** [@franco](https://discourse.julialang.org/u/franco)\
**Replies:** 5\
**Last updated:** [February 8, 2021, 3:41pm UTC](https://discourse.julialang.org/t/connect-to-redshift-with-searchlightpostgresql/53646 "2021-02-08T15:41:32Z")

</div>

Following the tutorial Working with Genie Apps - Accessing databases with SearchLight models I’m trying to use SearchLightPostgreSQL to connect to a Redshift database. I noticed it lists LibPQ as one of the dependencies…

---

## [Package Manager won't load in Pluto](https://discourse.julialang.org/t/package-manager-wont-load-in-pluto/54066)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 0\
**Last updated:** [January 27, 2021, 4:55pm UTC](https://discourse.julialang.org/t/package-manager-wont-load-in-pluto/54066 "2021-01-27T16:55:34Z")

</div>

In Pluto everything runs until begin import Pkg Pkg.activate(mktempdir()) end then this keeps trying to load, but never loads or gives an error message.

---

## [Least common multiple function description in the "help" environment](https://discourse.julialang.org/t/least-common-multiple-function-description-in-the-help-environment/47887)

<div class="topic-metadata">

**Author:** [@fdamore](https://discourse.julialang.org/u/fdamore)\
**Replies:** 2\
**Last updated:** [October 7, 2020, 7:42am UTC](https://discourse.julialang.org/t/least-common-multiple-function-description-in-the-help-environment/47887 "2020-10-07T07:42:05Z")

</div>

Hi everybody. I am sorry if this is the inappropriate category, but I’m new to the forum (and to Julia) and I did not find any other fitting category. I was looking for the simple least common multiple function “lcm()”…

---

## [Search for functions whose first argument can be a specific type](https://discourse.julialang.org/t/search-for-functions-whose-first-argument-can-be-a-specific-type/38318)

<div class="topic-metadata">

**Author:** [@NightMachinary](https://discourse.julialang.org/u/NightMachinary)\
**Replies:** 4\
**Last updated:** [July 21, 2020, 1:06pm UTC](https://discourse.julialang.org/t/search-for-functions-whose-first-argument-can-be-a-specific-type/38318 "2020-07-21T13:06:38Z")

</div>

In object-oriented languages, it is easy to see what methods a type has. For example, to find a replace command for strings, I just need to search in the methods that a string object exposes (using, e.g., \_\_dict\_\_ in pyt…

---

## [Julia Database or CSV filtering](https://discourse.julialang.org/t/julia-database-or-csv-filtering/36104)

<div class="topic-metadata">

**Author:** [@bandaya](https://discourse.julialang.org/u/bandaya)\
**Replies:** 8\
**Last updated:** [March 18, 2020, 12:47pm UTC](https://discourse.julialang.org/t/julia-database-or-csv-filtering/36104 "2020-03-18T12:47:06Z")

</div>

Hi, I am using JuliaDB.jl package to upload CSV files but having problems with filtering or extracting some data. using JuliaDB # t = loadtable("MTab.csv") # Assume that the CSV contains the following data t = table(\[1,…

---

## [Converting LibPQ result into dataframe](https://discourse.julialang.org/t/converting-libpq-result-into-dataframe/26567)

<div class="topic-metadata">

**Author:** [@abeburnett](https://discourse.julialang.org/u/abeburnett)\
**Replies:** 1\
**Last updated:** [July 19, 2019, 11:26pm UTC](https://discourse.julialang.org/t/converting-libpq-result-into-dataframe/26567 "2019-07-19T23:26:03Z")

</div>

So coming from R and Python I’m finding it astonishingly mysterious how I can connect to my Postgres DB and pull (select) data down into a dataframe format. I discovered the LibPQ package, but the documentation is very c…

---

## [Where is the "?" being served from?](https://discourse.julialang.org/t/where-is-the-being-served-from/17178)

<div class="topic-metadata">

**Author:** [@PetrKryslUCSD](https://discourse.julialang.org/u/PetrKryslUCSD)\
**Replies:** 5\
**Last updated:** [November 5, 2018, 8:36pm UTC](https://discourse.julialang.org/t/where-is-the-being-served-from/17178 "2018-11-05T20:36:02Z")

</div>

When we type “?”, where is the help being served from? Is there a big file somewhere with this information? I’ve tried searching the .julia folder (for instance length(collection)), but curiously there are no hits.