Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Administered by:

Server stats:

9.6K
active users

mastodon.world: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sql

62 posts52 participants1 post today
Public
Preston Maness ☭

Ok. Just culled ~20,000 of 25,000 #tumblr posts accumulated via #RSS over a month. I've gotta get to work on my own project applying basic statistics to this stuff. Think "reverse chronological + $all_your_own_filtering_and_sorting_and_bucketing". Not sure if I should do that within the confines of a #thunderbird add-on, or try some other approach. I really, really want to be able to use #sql for this stuff. It's a natural fit. But #sqlite seems to be a no-go for #WebExtensions. There is only #IndexedDB, which, in my limited experience with it, is absolute garbage to work with.

Public *
Chris Newton

New #introduction after migrating to Hachyderm.io - I work in data/research for a dog welfare and rehoming charity, mostly using #RStats, #Python and #SQL with occasional #QGIS.

I’m also interested in the environment, climate and wildlife. I don’t have loads of free time these days but I also enjoy music (see Bandcamp link!), books when I get round to reading them (see Bookwyrm link!), films (anything from highbrow to Highlander), cycling, yoga and #TaiChi (initially as ways to help manage #arthritis, before I began to appreciate both in their own rights).

Public *
Jack C.

Finally came up with a project to learn #Rust with. Not moving particularly fast, but it's making me spend a lot of time considering the implementation of data structures with ownership and lifetimes in mind.

I've been away from system-level programming for a while and last time I did any it was #C++ which is its own kind of pain.

Working on building up structures backed by a #sqlite #database as well, so getting #SQL practice also.

#RustLang#CPlusPlus#CPP
Replied in thread
Public
Coocook.org

@demiguise Well, #DBIxClass has proven to be very stable and powerful. Most often I found a way to implement unusual queries in DBIC and there’s always a workaround possible by using custom #SQL if you give up.

For me the main benefit of using a powerful ORM like DBIC is that you can reuse DB code in OOP fashion. Our Coocook::Schema::Result[Set]:: namespace has many methods providing tiny bits that can be plugged together like building blocks. Plain SQL quickly becomes very repetitive …

Public
Markus Brückner

Guess who took a few weeks (on and off) off frustrated research, as to why his #SQL migrations were failing, only to discover, that they were missing a comment (of all things)? Not this guy! (Well maybe - definitely - this guy, though 😅)
So, anyways: at least I got to write a nice little article about it: geekbetrieb.de/ramblings/drizz

geekbetrieb.deDrizzle ORM and statement-breakpoint - geek:betrieb
#drizzle#orm#databases
Public
GripNews

🌘 SQL 引擎的剖析
➤ DoltHub SQL 引擎的內部機制
✤ dolthub.com/blog/2025-04-25-sq
本文深入探討了 DoltHub 採用 go-mysql-server 後，SQL 引擎的運作流程。從接收查詢開始，文章詳細描述了查詢解析、繫結、計畫簡化、連接探索、計畫成本估算和結果輸出等步驟。文章特別強調了 Dolt 引擎使用的左遞迴解析器，以及其在記憶體使用和除錯方面的優勢。此外，文章也介紹了繫結階段如何將 AST 識別符與資料庫目錄中的符號匹配，並闡述了計畫簡化如何優化查詢執行效率。
+ 這篇文章清楚地解釋了 SQL 引擎的複雜運作，對於想深入瞭解資料庫底層原理的人來說非常有幫助。
+ 讀完這篇文章，我更瞭解 DoltHub 在資料庫技術上的創新，特別是解析器的設計令人印象深刻。
#資料庫 #SQL #DoltHub #技術

www.dolthub.com · Anatomy Of A SQL EngineBlog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
ExploreLive feeds
About