originalfrozenbanana

@[email protected]

This profile is from a federated server and may be incomplete. View on remote instance

originalfrozenbanana , to Python in best way to access databases in different projects

This sounds kind of like a data warehouse. Depending on the size of the data and number of connections I’d say script or database or module, this is a much bigger problem. Look into dbt (data build tool) and airflow

originalfrozenbanana , to Python in best way to access databases in different projects

I am a little curious about the conditional. I have a suspicion that this is a bit of over engineering.

The problem you seem to be trying to solve is “I need to access the same data in multiple ways, places, or projects.” That’s what a database is really great for. However, if you just need to combine the same csv files you have on disk over and over, why not combine them and dump the output to a csv? Next time you need it, just load the combined csv. FWIW this is loosely what SQLite is doing.

If you are defining a method or function that performs these ETL operations over and over, and the underlying data is not changing, I think updating your local files to be the desired content and format is actually what you want.

If instead you’re trying to explore modules, imports, abstraction, writing DRY code, or other software development fundamentals- great! Play around, it’s a great way to learn how might also recommend picking up some books! Usually your local library has some books on Python development, object oriented programming, and data engineering basics that you might find fascinating (as I have)

originalfrozenbanana , to Python in best way to access databases in different projects

Here “database” seems to mean a pandas dataframe. Sounds like you need to create a database using Postgres or sqlite or something similar, and recreate that database from a backup or database dump whenever you need it. You could host that database in the cloud or on your own network as well, if you need access remotely.

For instance see this pandas doc https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html

originalfrozenbanana , to Linux Gaming in What proton games are: completely ownable with no nonsense and a solid community?

I don’t think there are online multiplayer games like CoD or CS that don’t require a platform like steam or good old games to buy, download, and run. I’m not actually sure what you’re trying to do, but if avoiding marketing is your goal I recommend you run steam and change the default page it opens to to be the library where your games are and not the store

originalfrozenbanana , to Ask Lemmy in Now that DuckDuckGo is out. Give me your search prompts and I'll answer them as best I can. That includes images (based on what I have saved on my PC). So what is it you wish to know or see?

You fucking what

Oh god

Oh fuck I’m so old

originalfrozenbanana , to Games in Stellaris gets a DLC about AI that features AI-created voices, director insists it's 'ethical' and 'we're pretty good at exploring dystopian sci-fi and don't want to end up there ourselves'

Probably

originalfrozenbanana , to Games in Stellaris gets a DLC about AI that features AI-created voices, director insists it's 'ethical' and 'we're pretty good at exploring dystopian sci-fi and don't want to end up there ourselves'

My mid game builds 😢

originalfrozenbanana , to Selfhosted in ‘My whole library is wiped out’: what it means to own movies and TV in the age of streaming services

Yeah I don’t trust the good will of corporations, even the ones I personally like

originalfrozenbanana , to Selfhosted in ‘My whole library is wiped out’: what it means to own movies and TV in the age of streaming services

Yeah GOG is a better ownership model. Steam is not ownership

originalfrozenbanana , to Selfhosted in ‘My whole library is wiped out’: what it means to own movies and TV in the age of streaming services

I mean I hate to say it but if steam closed up shop tomorrow your games are gone too. You buy a license, not a copy, from steam

originalfrozenbanana , to Ask Lemmy in Daughters and Fathers

What everyone else has said but - apologize when you’re wrong. Tell your children that you were wrong, why you acted or said what you did, and how you will try to do better next time. Set the example that everyone is wrong, that it’s more important to make it right than be perfect

originalfrozenbanana , to Asklemmy in Why is Lemmy obsessed with the word "enshittification"?

Well that’s because you’re a tech-hating Luddite most likely \s

Yeah since I learned who the Luddites were I’ve kind of fallen in love with them

originalfrozenbanana , to World News in Weaned off from Russian gas, Europe finds itself trapped in expensive energy resources

Lê Monde? More like Lê Tankie am I right I’m so sorry

/s

originalfrozenbanana , to No Stupid Questions in [Serious] Any high-quality right-wing media, books, explainers?

Yep it’s a great one. Knowledge Fight talks about JBS all the time as well

originalfrozenbanana , to No Stupid Questions in [Serious] Any high-quality right-wing media, books, explainers?

Others have weighed in on the academic, but a lot of the American conservative braintrust is (literally) in think tanks like the Heritage Foundation, Federalist Society, John Birch Society, etc. These organizations vary from "pretty right wing" Heritage to "nearly literally fascist" John Birch Society, and they put out a LOT of papers and material they use to...I'll generously say "inform" the public discourse.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • kbinchat
  • All magazines