#DBConnect
LightNews LightNews
andrew.heiss.phd
Ooh, @posit.co's Positron is no longer in beta as of this week(!), and it recently added support for DuckDB databases in the Connections Pane positron.posit.co/connections-... - any db connection you add with {connections} shows up there—this is magical! #rstats
Screenshot from Positron showing code that connects to a database, and then highlights the connection in a Connections Pane and shows the data in a Data Explorer tab Here's the code: library(dplyr) # Connect with {connections}, which automatically adds this to the panel con <- connections::connection_open(duckdb::duckdb(), ":memory:") # Or do it manually with {DBI} # con <- DBI::dbConnect(duckdb::duckdb(), ":memory:") # connections::connection_view(con) # Add some stuff to the database copy_to(con, penguins, name = "penguins", overwrite = TRUE) copy_to(con, gapminder::gapminder, name = "gapminder", overwrite = TRUE) # Get stuff out of the database adelie_query <- tbl(con, I("penguins")) |> filter(species == "Adelie") # Check it out! It's SQL! show_query(adelie_query) # Actually run the query penguins_from_db <- adelie_query |> collect() penguins_from_db connections::connection_close(con) # Or this: # DBI::dbDisconnect(con)
July 3, 2025 at 2:04 PM
tiddlydump.bsky.social
tbl(
DBI::dbConnect(...),
dbplyr::in_catalog(__, __, __)
) |> ...

Applies to more than just Snowflake, though!

What's more offensive is that Snowflake goes Database > Schema (the hell?) > Table
January 22, 2026 at 1:14 AM
nigelsq.bsky.social
Using all the tips, the correct syntax for a new db connection would be:

con <- dbConnect(duckdb::duckdb(), dbname = here::here("db", cfg$dbName), read_only = TRUE)
December 29, 2025 at 4:19 AM
tjmahr.com
getting ready to read in 30000 csv files
library(dplyr) db <- DBI::dbConnect(duckdb::duckdb("data.duckdb")) # Test on some folders before trying whole dataset test_dirs <- dir |> fs::dir_ls() |> head(20) list_of_globs <- paste0(test_dirs, "/*.csv") |> sprintf("'%s'", ..1 = _) |> paste0(collapse = ", ") |> sprintf("[%s]", ..1 = _) # https://duckdb.org/docs/stable/data/csv/overview#parameters # https://duckdb.org/docs/stable/data/multiple_files/overview q <- glue::glue(" read_csv( {list_of_globs}, FILENAME = TRUE, header = TRUE, delim = ',', skip = 0, quote = '\"', escape = '\"', auto_detect = FALSE, columns = struct_pack( file := 'VARCHAR', speaker := 'VARCHAR', frame := 'INTEGER', model_name := 'VARCHAR', model_commit := 'VARCHAR', run_timestamp := 'VARCHAR', label := 'VARCHAR', logprob := 'DOUBLE' ) )") # This just queries the pile of csvs # it's fast because it's lazy (just enough to print a few rows) tbl(db, q) DBI::dbListTables(db) # This would actually story the query results in the db # it's slower because it's reading all the data tbl(db, q) |> compute(name = "csvs", temporary = FALSE) DBI::dbListTables(db)
November 18, 2025 at 9:38 PM
tjmahr.com
the way that namespaced functions get automatically translated to SQL if the package author's support that function translation... is weird magic

con <- DBI::dbConnect(duckdb::duckdb())
dbplyr::translate_sql(stringr::str_trim(x), con = con)
#> LTRIM(RTRIM(x))
September 16, 2025 at 8:08 PM
libbyheeren.bsky.social
invisible(con <- DBI::dbConnect(...))
June 23, 2025 at 6:48 PM
andrew.heiss.phd
I haven't done fancy big data stuff, but I recently used it for DB testing. I developed a data pipeline that queried a secure state elections MySQL database, but I didn't have access to it, so I replicated the schema for testing the pipeline locally
db_connect <- function() { if (Sys.getenv("PRODUCTION") == "true") { con <- DBI::dbConnect( odbc::odbc(), Driver = "MySQL ODBC 9.0 Unicode Driver", Server = "SECRET", UID = keyring::key_get("tenex_db_username"), PWD = keyring::key_get("tenex_db_password"), Port = 3306 ) } else { db_file <- "testing_db.duckdb" con <- DBI::dbConnect(duckdb::duckdb(), db_file) } return(con) }
December 6, 2024 at 8:00 PM
rayt.bsky.social
You could also write wrapper functions for the DBI functions which open and close the connection, along the lines of this. read_duckdb <- function(q) {
con <-dbConnect(...)
on.exit(dbDisconnect(con))
dbGetQuery(q)
}
December 29, 2025 at 5:22 PM
epsteinweb.bsky.social
EFTA01097544.jpg
#epsteinweb #efta01097544
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01097543 | EFTA01097544 Deutsche Bank Private Wealth Management VA Overview DBConnect Overview DBConnect, Deutsche Bank Alex. Brown's account management and trading website*, provides you with around-the-clock portfolio information. DBConnect is your personal financial toolkit, a comprehensive link to all that Deutsche Bank Alex. Brown offers. Portfolio Information DBConnect provides you with the following portfolio information: positions, balances and transactions; unrealized and realized gains and losses; activity history and projected cash flow and access to electronic documents such as statements, trade confirmations and tax documents. Most portfolio information can also be downloaded to Microsoft Excel. Paper Suppression You can register for our document delivery program and receive e-mail notification when your trade confirms and statements are ready to view online in lieu of receiving physical delivery of such documents. Intuit Quicken®. Microsoft Money® and TurboTax® Downloads Deutsche Bank is pleased to offer you the ability to download account data to Intuit Quicken®, Microsoft Money® and TurboTax®. Customized DBConnect A nicknaming feature is provided so that you can easily identify your accounts. In addition, you can create custom groups and then view portfolio information for those groups. Deutsche Bank Research Deutsche Bank has top-ranked research teams covering Global Markets, Equities and Macro-Economic analysis around the globe 24 hours a day. Much of Deutsche Bank equity research and third party independent research is available 24/7 via DBConnect. You can create alerts so that you will receive e-mail notification when DB research is ready to view online. Market Data Create price, volume and new alerts for securities that you would like to track. Create your own watchlist and access real-time quotes. *provided via the NetExchange Client site by Pershing LLC DB EFTA01097544
May 9, 2026 at 9:11 AM
emkayoh.bsky.social
I find it tiresome setting up environments, importing a rack of modules, just to try and remember a load of Queryset methods. I used a dbConnect function years ago, & now I'm very happy I can stick SQL into #rstats base. I know I could just sql but I'd still have to open R to make pretty pictures.
December 31, 2024 at 10:51 PM
tiddlydump.bsky.social
If they're familiar with dplyr, you can plug into it using a DBI::dbConnect and hit it that way.

I shudder at the thought of opening a csv that large on its own, even if `data.table::fread` or `arrow::read_csv_arrow` go brrrrr
January 15, 2026 at 1:21 AM
bjedwards.bsky.social
My friend, have you heard about my new lord and savior, duckdb?

library(duckdb)
library(tidyverse)
con <- dbConnect(duckdb(), dbdir = 'mydata.duckdb', read_only = FALSE)
dbExecute(con, "CREATE VIEW 'tbl' AS SELECT * from 'data.csv'")
df <- tbl(con, 'tbl')

Seemless integration via dbplyr. Fast AF.
September 19, 2024 at 4:48 PM
xtaran.chaos.social.ap.brid.gy
Oh, mensch kann bei der Deutschen Bahn jetzt auch Electric Bromptons mieten: https://www.youtube.com/watch?v=99akiGigI-8

#deutschebahn #brompton #bromptonelectric #DBConnect
August 8, 2026 at 1:40 AM
doomedromhackyuri.bsky.social
[Shortly after release, the hack was deleted off of DBConnect, no one bothered to reupload it and it quickly fell off the face of the Earth.]
[...though, if you were to find it, it's a very enjoyable experience. But, there's a softlock at the ICE PALACE section of Dragonblazers III.]
August 2, 2026 at 6:23 AM
rkiel.bsky.social
Nach mehreren vergeblichen Versuchen habe ich mit dem Paket RMySQL endlich geschafft, R mit meiner Datenbank zu verbinden:

con <- dbConnect(
MySQL(),
dbname = "[datenbankname]",
host = "localhost",
user = "[user]"
password = "[passwort]"
)
November 22, 2025 at 8:05 AM
epsteinweb.bsky.social
Parts 1-2/2 — EFTA01141578.jpg
#epsteinweb #efta01141578
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01141578 | EFTA01141578 From: Connect Support <1 To: JEEVACATION@GMAIL.COM >, Vahe Stepanian Cc: Jay Lipman Subject: Welcome to DBConnect- Deutsche Asset & Wealth Management [C] Date: Wed, 30 Oct 2013 16:31:48 +0000 Attachments: DBConnectPitchbook_clientApproved_007806-060711.ppt Classification: Confidential Dear DBConnect Client: Deutsche Asset & Wealth Management is pleased to offer you DBConnect, a web site that provides you with detailed information about your Deutsche Asset & Wealth Management accounts. The attached brochure provides more information about DBConnect. We encourage you to visit the web site to experience the site's capabilities. • You can access DBConnect at the following address: www.dbconnect2.nctxselect.com • To log in, your user ID is Please call our Web Support representatives to receive your temporary password at (800) 776.7564, option 3 or (410) 895-4347, option 3 from 7 a.m. to 5 p.m. Eastern Time, Monday through Friday. • Keep in mind that at your first log in, you will be prompted to change the temporary password. • For assistance with navigating the DBConnect web site please contact our Web Support representatives at (800) 776-7564, option 3 or (410) 895.4347, option 3 from 7 a.m. to 5 p.m. Eastern Time, Monday through Friday. Thank you, and enjoy your new connection to the world of investing at www.dhconnect2.netxselect.com Sincerely, DBConnect /PCS Internal Applications Support Deutsche Bank Alex. Brown A division of Deutsche Bank Securities Inc Toll Free: 1-800-776-7564, option #3 International: +1-410-895-4347, option #3 Fax: 410-895-4962 This communication may contain confidential and/or privileged information. If you are not the intended recipient (or have received this communication in error) please notify the sender immediately and destroy this communication. Any unauthorized copying, disclosure or distribution of the material in this communication is strictly forbidden. Deutsche Bank does not render legal or tax advice, and the information contained in this communication should not be regarded as such. EFTA01141578 Epstein Web iOS app on the App Store.
May 10, 2026 at 4:31 PM
epsteinweb.bsky.social
EFTA01097552.jpg
#epsteinweb #efta01097552
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01097543 | EFTA01097552 Deutsche Bank Private Wealth Management Statements, Confirms and Tax Documents FEATURES • Provides links to the PDF version of statements, trade confirms and 1099s Nr• StiOUINS •1•11.• Ow.lab • M.n. I I ***** C•dsae•l 4 11.19411011“ ani Control Sr! WI* - Dads [wens. br.•••••• toI •:Wit; 0. Waeni nen Ra:Gr Vsle.tellat usa, %PA) wag • ,29.! t 14=11 cm ,21,2! 'MS( DBCONNECT Page 10 EFTA01097552 Epstein Web iOS app on the App Store.
May 9, 2026 at 9:11 AM
epsteinweb.bsky.social
EFTA01097550.jpg
#epsteinweb #efta01097550
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01097543 | EFTA01097550 Deutsche Bank Private Wealth Management History DBCONNECT memo Meant.. $-$0, Oti t. no,0 Bennis Indent It• sem, h *nein 4 90.• Callon... Se. Me awn reed...ten Moo • ..... ($, :we neit• sat 44.$40/.• HIst01). Tiensilla Twig Al TImetorisk n. .. It Sflat•bn 5,4o:4 v /we now One seen eat Ta Poen Acclaim 0 ..... • ••• sax% sea* LW.a.COOP3 MCNEYFLPOPPOUSE uW 1401eTIJUSAMPROUTeCei etaniED VA r.7150:9 NeetV tr9, fel IWO. rfletotat (.I7/X0) IKOEY FVO ca0.0701 S® Ouldilimobt O Non., 0 0.w.' 1-- 1 4onus pail C.J.4.441.C.Pra °many Ilet Animal Na. Noe A•110.111 411419.0 Ywl OPSOCI Onettolle• u4.7i CCP (WI WOOS WIT “tit$1 ••• •1444/1 1.4 0.7.1X9) ii Uwe 1U "Weave IS T. Nett I C.STROUTONICallf0 nrun Panea WiellWat CtIeittnCie MCI.MD 435 Z3 [sit 96 9942,3 Late . HISTORY • Provides activity for current year plus two previous years • Filtering capability by specific date, symbol or transaction type Ca CTIA nme czts Irk ro ta 050 101%60 050 N6 6790 LOS USD 5/ 9D OHO Watt $ • I. MOD gre0 0400 00D 1203 .003 t090 PWCO links DBCONNECT Page 8 EFTA01097550
May 9, 2026 at 9:11 AM
epsteinweb.bsky.social
EFTA01097545.jpg
#epsteinweb #efta01097545
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01097543 | EFTA01097545 Deutsche Bank Private Wealth Management Welcome Page •••••••• • DBConnect can be accessed from the following URL: dbconnect2.netxselect.com • You will be issued a unique User ID and Password to view all of your DBAB accounts • For security reasons, you will be asked to choose a picture and phrase to identify yourself • Additionally, you will be asked to choose four security questions and provide answers The first time you log on to the site, you will be asked to review and accept a general site terms of use •••••m•••••••••••‘• 44444 (YHA.' 04ernid,COVV. SWANn as. sera Smalat CISOriali• p.• W14. In.. taFli ....angntrt wo II Ai, CW(.•••,,...4,-. romirer ,.on. ...awn eanuommurrmon tem...• eara.ennivisteer.xci.s....., efrain.leanwo.“...“. Mitlia•ThrtivtOlet•••1411•••••••••03•01,, • • •••••••• tal/••••••Of You can also select to choose one of the following as a default home page: • • Balances Account Snapshot • Holdings • Market Highlights mat Piessait rzect.Noleaf WOO OM'S DBCONNECT Page 3 EFTA01097545
May 9, 2026 at 9:11 AM
epsteinweb.bsky.social
EFTA01097543.jpg
#epsteinweb #efta01097543
https://epsteinweb.org
Available in the iOS app store now!
https://apps.apple.com/us/app/epstein-web/id6758880661
EFTA01097543 | EFTA01097543 Ini Deutsche Bank Private Wealth Management DBCONNECT Overview June 1, 2011 dbconnect2.netxselect.com EI EFTA01097543
May 9, 2026 at 9:11 AM
epsteinweb.bsky.social
EFTA01369363.jpg
#epsteinweb #efta01369363
https://epsteinweb.org
EFTA01369363 | EFTA01369363 Christopher V. Quartararo Assistant Vice President I Investment Solutions Group Deutsche Bark Securities Inc. Deutsche Bark Wealth Management 24th 34.5 PkrkkA• v Neynu 1e0.154 New Twitter: @DBAmericas Online account information via the DBConnect website. Ask me for access. If you already have access to DBConnect use: httpl/dbconnect.netkinvestorcom Dovmload the NetXlnvestor mobile app for Apple or Android. All trade execution information contained herein is being provided as an accommodation at your request in advance of your receipt of the official trade confirmation(s). Additional trade detail information available upon request. The terms of the trade(s) may be subject to change prior to settlement. and therefore the official trade confirmations) and account statements issued by Deutsche Bank shall govern. Deutsche Bank is not responsible for any discrepancy between the informal execution report and the official trade confirmation(s) or account statements. This communication may contain confidential and/or privileged information. If you are not the intended recipient (or have received this communication in error) please notify the sender immediately and destroy this communication. Any unauthorized copying, disclosure or distribution of the material in this communication is strictly forbidden. Deutsche Bank does not render legal or tax advice, and the information contained in this communication should not be regarded as such. CONFIDENTIAL - PURSUANT TO FED. R. CRIM. P. 6(e) CONFIDENTIAL DB-SDNY-0061585 SDNY_GM_00207769 EFTA01369363
February 15, 2026 at 6:22 AM
forums.autodesk.com.web.brid.gy
DbConnect to SQL server
Hi folks, we just migrated from SQL Server 2019 to SQL Server 2022 and since then I can't connect do my Databases with DbConnect. The UDL file is unchanged except for "Data Source=[NEW SERVER NAME]". AutoCAD 2025 crashes whenever I try to connect to a database (see attached video). Sometime the connection succeeds but crashes when I disconnect. As you can see in the UDL file, there is nothing special in it. Any ideas? System: Windows 11 Enterprise (10.0.26100 Build 26100) Autocad 2025.1.1 (Product ver. V.154.0.0) Thanks
forums.autodesk.com
April 29, 2025 at 10:33 AM
colinhoad.com
Handy Python class for managing connections to multiple RDBMS sources (currently supports Oracle, SQL Server, PostgreSQL and MySQL) including encrypted passwords and easy pandas data frame creation: github.com/colinhoad/db...
GitHub - colinhoad/dbconnect: Python class to connect safely to multiple RDBMS sources and generate pandas DataFrames
Python class to connect safely to multiple RDBMS sources and generate pandas DataFrames - colinhoad/dbconnect
github.com
April 28, 2024 at 7:11 PM