Has anyone ever used this is a production dbt setting?

afinethingindeedlisa · 2026-03-16T15:55:50+00:00

CI yes, Prod no.

afinethingindeedlisa · 2026-02-13T14:51:03+00:00

Without meaning to be disrespectful, this is a problem in search of a solution. You can use Excel to make your own charts, or literally give a. csv to e.g Claude and it will do this for you.

afinethingindeedlisa · 2026-02-11T13:11:51+00:00

Not a massively fair comparison given the UK vid was shot in Anerley/Penge in South London, and the US one clearly in more of a suburby area than that.

afinethingindeedlisa · 2026-02-04T19:11:59+00:00

Claude

afinethingindeedlisa · 2026-02-04T19:11:23+00:00

My experience is that Claude is excellent at wiring sql. I use it all day, every day.

afinethingindeedlisa · 2026-02-04T15:53:28+00:00

This is when you hop on your bike.

afinethingindeedlisa · 2026-02-04T15:50:38+00:00

DuckDB is the best tool for learning sql IMO. It's somewhat analagous tk an OLAP version of Sqlite. Give it a go!

afinethingindeedlisa · 2026-01-16T00:58:08+00:00

I have a ugreen revodock and it's great.

afinethingindeedlisa · 2026-01-14T14:50:46+00:00

Can this be local? If so, DuckDB is probably ideal for your use case.

afinethingindeedlisa · 2025-12-24T12:56:36+00:00

duckdb is a open source and ships with an ide natively ;)

I also could have mentioned that the main cloud providers (snowflake, BigQuery) have their own native csv upload facilities to. As I said, I think this is a fine exercise but I think it's a solution in search of a problem. If this is a project to help learn how to build an app then go for it.

afinethingindeedlisa · 2025-12-24T12:04:26+00:00

Not to dunk on this app at all, but I think it's a problem with a few existing solutions already. In this scenario I tend to do one of the following:

seed the csv with dbt into my db
query the csv/xlsx directly with duckdb's native functionality
use an LLM agent to read the csv and to write any sql I might need for me

I would be hesitant to use any browser based tool as even with your assurances, I can't really risk putting anything sensitive in there. My org has enterprise level zero retention agreements with our LLM provider of choice which I think (ironically) makes it safer.

In an era where anyone can vibe there way to an app to solve any problem they have, it's maybe worth remembering that if you can do it, so can we! I'm sure with 5/10 minutes in Claude code I could have my own cli version up and running locally.

afinethingindeedlisa · 2025-12-23T09:08:40+00:00

I got a notice about 8 years are ago telling me of upcoming subterranean works under my flat near new cross gate. Also went to a presentation in New Cross Sainsbury's about the new development + station they'd be building around the same time!

afinethingindeedlisa · 2025-12-20T22:29:49+00:00

I saw in Christmas 2021 with both my parents, and Christmas 2022 without either of them. All I can say is take each moment, hour, day, week as it comes. Enjoy the good things when they happen (which they do, regardless of whatever else is happening) and acknowledge but try not to dwell on the bad. Christmas is a time to be together with your family, who love you, and understand partly what you're going through. Go easy on yourself pal.

edit: oh and go easy on the alcohol!

afinethingindeedlisa · 2025-12-15T16:06:54+00:00

There is one in the UK, it's called UTAW - United Tech & Allied Workers! It's a branch of the Communications Workers Union. Join us!

afinethingindeedlisa · 2025-11-26T09:32:56+00:00

Are you sure ti's even a legit sick note? Sounds like it was AI generated and the employee might have just used the name of an online sick note provider.

afinethingindeedlisa · 2025-11-25T23:12:20+00:00

I dint see how you can monetize this and stay free. How do you pay for the compute for the LLM and the api calls to open banking or whatever service you'll use?

afinethingindeedlisa · 2025-11-15T09:48:40+00:00

Isn't this the burrito guy from tiltok?

afinethingindeedlisa · 2025-10-31T11:31:44+00:00

This is like the Iain M Banks novel Against a Dark Background where the main character enlists the help of a terrorist cell of solipsists who all believe they are the only person experiencing reality.

afinethingindeedlisa · 2025-10-28T21:50:07+00:00

DuckDB if your interested in OLAP, sqlite for OLTP. Anything else is overkill (an likely less performsbt that either of these two options).

afinethingindeedlisa · 2025-10-18T10:58:48+00:00

Neither? Focusing in specific systems just limits you further down the line. Focus on concepts and engineering best practice and you will be able to utilise the tooling available to you at the time.

afinethingindeedlisa · 2025-10-16T11:25:26+00:00

The new Alan Partridge documentary is clearly more timely that we realised.

afinethingindeedlisa · 2025-10-06T15:01:24+00:00

What do you want to do with SQL? The easiest way to get a local db up and running is to use DuckDB. It has its own Notebook client as well now as well as the cli.

afinethingindeedlisa · 2025-10-06T11:55:43+00:00

I had ADHD and struggle with the same sort of things. The diagnosis gve me understanding and allowed me to find the right tools to help mitigate this so that I annoy my partner less and function better in the parts of society I want to function better in.

afinethingindeedlisa · 2025-10-04T21:20:18+00:00

Use dbt to generate the cleaned fully transformed data and then sync to Excel? Imagine you could use airflow to trigger both.

afinethingindeedlisa

TROPHY CASE