originalfrozenbanana

@[email protected]

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

best way to access databases in different projects

Hi, I want to know what is the best way to keep the databases I use in different projects? I use a lot of CSVs that I need to prepare every time I'm working with them (I just copy paste the code from other projects) but would like to make some module that I can import and it have all the processes of the databases for example...

originalfrozenbanana ,

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 ,

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 ,

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

What proton games are: completely ownable with no nonsense and a solid community?

I'm old-naughties internet café crew from around the era of the original Counter Strike through CoD MWF3 and Battlefield 2042. I wouldn't mind reliving the nostalgia of that era, and have more than enough machine to do it now. I have zero tolerance for micro transactions, gatekeeping, or software as a service business models. I...

originalfrozenbanana ,

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

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?

Edit: Due to popular demand FatTony Search servers are down for the time being. but has gone open source just in time (Yes that's how it works 😡) . You may now get responses from other users. Servers will be back up some time later.

‘My whole library is wiped out’: what it means to own movies and TV in the age of streaming services ( www.theguardian.com )

*What rights do you have to the digital movies, TV shows and music you buy online? That question was on the minds of Telstra TV Box Office customers this month after the company announced it would shut down the service in June. Customers were told that unless they moved over to another service, Fetch, they would no longer be...

originalfrozenbanana ,

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 ,

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

originalfrozenbanana ,

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

originalfrozenbanana ,

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 ,

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

/s

originalfrozenbanana ,

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.

originalfrozenbanana ,

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

originalfrozenbanana ,

People here are far more likely to be anti-capitalist, anti-corporate, pro-privacy, etc. those groups all circle the same kind of Cory Doctorow/Matt Stoller/Luddite world where the word enshittification became popular.

originalfrozenbanana ,

The Luddite is an anticapitalist blog https://theluddite.org

originalfrozenbanana ,

Happy to! I can see why someone would be confused 😂

originalfrozenbanana ,

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 ,

And they will say you can’t go to the gym, then. I agree this is enshittification but this isn’t a magic trick that lets you bypass the app

originalfrozenbanana ,

That isn’t how contracts work

originalfrozenbanana ,

Yes that’s absolutely what will happen. They likely have language in the contract you signed allowing them to do just that.

You are paying for access to the gym. They don’t have to provide you access via a card or a list or an app - they probably specify that they can refuse access for a variety of reasons, including “safety and privacy” or some shit they can shoehorn an app into. You don’t have a legal right to access a place via the mechanism you choose.

originalfrozenbanana ,

Isn’t what illegal? They are allowed to determine how you access their gym.

originalfrozenbanana ,

I never said they’d charge you, I said they wouldn’t just let you in.

originalfrozenbanana ,

Ah I missed the part where you said “and charge you.” There’s nothing in contracts like these that says the gym has to let you identify yourself in any way you choose and I don’t see why you think there would be.

originalfrozenbanana ,

Most gym employees don’t have that level of discretion in the US at least. Most gyms I’m aware of are franchises and asking a wage employee to go against their corporate policies risks their livelihood.

originalfrozenbanana ,

Technically only Congress can authorize a war. However, the president can and often will undertake “peacekeeping efforts” or “counterinsurgency operations” or “targeted strikes” without congressional approval.

Whether anyone could stop a president issuing an order is another question. The president is the commander in chief - the military reports to the president, not Congress. If the president tried to order the military to do something unconstitutional (like fight a war that was not authorized by Congress or, idk, overturn an election) then we’d be in a constitutional crisis. In such a crisis, either the military disobeys the president (which is unconstitutional) or the president violates separation of powers (which is unconstitutional)

The American system of government relies on three branches all participating in good faith. As soon as that stops, it all falls apart. Though government is just a series of rules and norms. Rules and norms won’t stop soldiers all the time.

originalfrozenbanana ,

But that’s the crisis right? The president would almost never say “go violate the constitution.” They would say “go arrest and occupy Congress, THEY violated the constitution “

originalfrozenbanana ,

You say that but that isn’t how it would happen.

There would be months or years of prep work, spreading propaganda that Canada was the source of our woes, that they were wronging us. By the time we invaded there’d be just enough “legitimate discourse” about the invasion that the Presidents supporters could claim any effort to stop him was political.

There was a time not long ago where people said you couldn’t do lots of things or you’d get thrown out - then Trump did many of them, even got impeached (twice!) and stayed in office. In practice, these limits are at best inconvenient for a dedicated lunatic.

I'm looking to drop cable but need live sports alternative.

As the title states, I currently have cable but want to cut it. I dont watch anything live anymore aside for sports. I can't buy a sports package as the local pro teams are blacked out, and you must watch on the local channel. Are there any alternatives?

originalfrozenbanana ,

Excel has a bad UX for people who want to use it to make art

originalfrozenbanana ,

Do MOST people who use GitHub download .exes? In my experience the VAST majority of people are using it for source and version control, not external releases. The overwhelming majority. FOSS and OSS is a small portion of the overall GitHub user base compared to, say, enterprise companies.

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