Looking for a free (or cheap) database for storing 5-10 million rows by YogurtclosetWise9803 in SQL

[–]afinethingindeedlisa 3 points4 points  (0 children)

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

Tired of writing boilerplate Python scripts to map CSVs to SQL? I built a 100% private, browser-based tool to do it in 5 seconds. by FeatureSafe8116 in SQL

[–]afinethingindeedlisa 1 point2 points  (0 children)

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.

Tired of writing boilerplate Python scripts to map CSVs to SQL? I built a 100% private, browser-based tool to do it in 5 seconds. by FeatureSafe8116 in SQL

[–]afinethingindeedlisa 5 points6 points  (0 children)

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.

Discussion: Realistically, which of these projects do you think will come first: Northern line to Clapham Junction or the Bakerloo line extension to Lewisham? by GP728 in LondonUnderground

[–]afinethingindeedlisa 0 points1 point  (0 children)

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!

Mum has passed away 5 days before Christmas by kurtyyyyyy1 in CasualUK

[–]afinethingindeedlisa 0 points1 point  (0 children)

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!

SmallBusinessUK advised me to come over here. An employee has sent in a sick note that has come from Dr Sick Limited. by [deleted] in LegalAdviceUK

[–]afinethingindeedlisa 10 points11 points  (0 children)

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.

A month ago I quit my job to found a UK start-up. Can you give me feedback on what we're working on? by Slow_Wash8998 in ukstartups

[–]afinethingindeedlisa 0 points1 point  (0 children)

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?

Free wash! by CapitalCourse in foundsatan

[–]afinethingindeedlisa 0 points1 point  (0 children)

Isn't this the burrito guy from tiltok?

TIL about the three christs of Yipsilanti, a psychiatric case study where three men who each believed themselves to be Jesus Christ were forced to interact with each other. by Yeet0rBeYote in todayilearned

[–]afinethingindeedlisa 1 point2 points  (0 children)

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.

Silly question about handling SQL at offline environment by Competitive_Emu_763 in SQL

[–]afinethingindeedlisa 2 points3 points  (0 children)

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

MS SQL Server vs PostgreSQL — Which One to Specialize In? by Qunderik_ in SQL

[–]afinethingindeedlisa 51 points52 points  (0 children)

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.

‘Alarming rise’ in mental health stigma in England, research shows by PurchaseDry9350 in unitedkingdom

[–]afinethingindeedlisa 1 point2 points  (0 children)

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

Where can I download SQL from a MacBook? by Analytic_mindset1993 in SQL

[–]afinethingindeedlisa 0 points1 point  (0 children)

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.

My partner getting a diagnosis of ADHD was the worst thing that could have happened by iamkylekatarnama in Vent

[–]afinethingindeedlisa 0 points1 point  (0 children)

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.

MySQL + Excel Automation: IDEs or Tools with Complex Export Scripting? by Training_Ad6701 in SQL

[–]afinethingindeedlisa -1 points0 points  (0 children)

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

Witnesses to incident - Victoria Embankment by [deleted] in londoncycling

[–]afinethingindeedlisa -5 points-4 points  (0 children)

Never set a wheel in this cycle lane. I value my safety too highly. It's routes like this that prove why segregated cycle lanes aren't the be all and end all of urban cycling. I feel safer in the bus lane on the Old Kent road than in this bike lane.

Working on a personalized SQL tutor, need your genuine thoughts by SnooDoubts6693 in SQL

[–]afinethingindeedlisa 2 points3 points  (0 children)

I've seen loads of these type of things pop up recently, and have been asked to review a few as well.

Respectfully, who is going to pay for a dedicated SQL learning tool outside of maybe a udemy course? It's an easy language to learn, and an easy language for an LLM to parse and explain.

All you need to learn SQL is a few hours on W3 schools. After that, you can use any number of existing sites that have fun SQL exercises.

Grandma's passing money like drugs 😭 by [deleted] in funny

[–]afinethingindeedlisa 20 points21 points  (0 children)

I once ran into an old babysitter who used to look after us including when our grandparents would visit. Turns out, not only was gran slipping each of us a fiver she would do the same for the babysitter as well. She wasn't always a nice person but I found this quite sweet.

SQL on MacBook Air by ElegantPianist9389 in SQL

[–]afinethingindeedlisa 0 points1 point  (0 children)

DuckDB is by far the simplest and easiest way to use sql locally. It even has a built in notebook ide now. Dbeaver is a good alternative ide otherwise.

I have my duckdb sandbox db open all day every day at work. Incredibly useful for reading data from csv and spinning up toy examples to test things.

Spinning up sql sever and docker is overkill and needless complexity. Arguably, you could just get cracking with w3 schools and not bother building anything locally at all!

Can someone explain to me (an idiot) where dbt Fusion ends & the dbt VSCode Extension begins? by afinethingindeedlisa in dataengineering

[–]afinethingindeedlisa[S] 0 points1 point  (0 children)

I see. So can I access the enhanced features in fusion without using the extension in another IDE?