BitSound

@BitSound@lemmy.world

This is a remote user, information on this page may be incomplete. View at Source ↗

⁨Comment⁩ on ⁨Please suggest some good self-hostable RAG for my LLM.⁩ ⁨⁨1⁩ ⁨month⁩ ago⁩:
Not sure how ollama integration works in general, but these are two good libraries for RAG:

github.com/facebookresearch/faiss

pypi.org/project/chromadb/
⁨Comment⁩ on ⁨Car dealers say they can’t sell EVs, tell Biden to slow their rollout⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
I have no idea, and that’s kind of my point. I’ve never bothered checking, because charging off of a regular outlet is enough for me, and it will be enough for a lot of other people too.
⁨Comment⁩ on ⁨Car dealers say they can’t sell EVs, tell Biden to slow their rollout⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
Those questions really don’t need to be asked. I charge off of a regular outlet, level 2 charging at home is nice but unnecessary. If those questions keep coming up, it’s likely from dealers that are fearmongering.
⁨Comment⁩ on ⁨Car dealers say they can’t sell EVs, tell Biden to slow their rollout⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
You don’t need a level 2 charger at home. You don’t need gas stations equivalents. EV companies won’t make infrastructure, because we’ve already built tons of infrastructure for EVs and it’s called the electric grid. Everywhere has electricity. I was recently in a very remote area for vacation in my EV, and just plugged my car into a regular outlet to charge it up. To get there, I stopped for lunch and plugged my car in at a supercharger while I ate.

Target is putting in superchargers at lots of their locations around me. Other places are or will follow suit. If you can’t charge at home, you’ll simply stop by the store/mall/whatever, do your normal shopping, and have your car charge in the meantime. Or you’ll charge at work, or any number of other places.

EVs aren’t hard, they just require a mindset shift. People worry about this and that, but it’s because they haven’t actually tried it and have given too much weight to FUD spread about EVs.
⁨Comment⁩ on ⁨Car dealers say they can’t sell EVs, tell Biden to slow their rollout⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
I’m not worried about that, but I’ve seen some more cautious people get the cable underneath one of their wheels so that you’d have to move the car to take it. I’m quite sure you could also find another way of attaching or securing it to your car to make it fairly difficult to walk away with. The chargers also aren’t really worth much, so it seems unlikely that even someone desperate for cash would put much effort into it.
⁨Comment⁩ on ⁨Car dealers say they can’t sell EVs, tell Biden to slow their rollout⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
I charge my car off of a regular outlet outside in a very cold climate, and charging like that will actually likely make the battery last quite a while. The only way to find out for sure is to wait, but it has been 4 years and the battery hasn’t lost any capacity. My car also has a 320 km range, so even in your scenario, if you charged 50km away and came home, you’d still have 270km of range.

I think you may have given too much weight to FUD about EVs from companies that would like to see them fail. I’ve seen a lot of concerns posted online that just don’t practically matter, once you actually try it. There’s also some really nice minor things about owning an EV, like not having to breathe in toxic fumes when walking around the car. Especially nice if you have kids that are right at the level of the tailpipe.

It is also fine to wait a bit, of course. In my area chargers are springing up in lots of places, and I think we’re not far off from a tipping point away from ICE cars, which will spread even to rural areas pretty quickly when gas stations start becoming unprofitable.
⁨Comment⁩ on ⁨New Leica camera stops deepfakes at the shutter⁩ ⁨⁨11⁩ ⁨months⁩ ago⁩:
This is tilting at windmills. If someone has physical possession of a piece of hardware, you should assume that it’s been compromised down to the silicon, no matter what clever tricks they’ve tried to stymie hackers with. Also, the analog hole will always exist. Just generate a deepfake and then take a picture of it.

⁨Comment⁩ on ⁨Is there something better than SQL?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:

I’m too lazy to convert that by hand, but here’s what chatgpt converted that to for SQL, for the sake of discussion:

SELECT 
    a.id,
    a.artist_name -- or whatever the name column is in the 'artists' table
FROM artists a
JOIN albums al ON a.id = al.artist_id
JOIN nominations n ON al.id = n.album_id -- assuming nominations are for albums
WHERE al.release_date BETWEEN '1990-01-01' AND '1999-12-31'
AND n.award = 'MTV' -- assuming there's a column that specifies the award name
AND n.won = FALSE
GROUP BY a.id, a.artist_name -- or whatever the name column is in the 'artists' table
ORDER BY COUNT(DISTINCT n.id) DESC, a.artist_name -- ordering by the number of nominations, then by artist name
LIMIT 10;

I like Django’s ORM just fine, but that SQL isn’t too bad (it’s also slightly different than your version though, but works fine as an example). I also like PyPika sometimes for building queries when I’m not using Django or SQLAlchemy, and here’s that version:

q = (
    Query
    .from_(artists)
    .join(albums).on(artists.id == albums.artist_id)
    .join(nominations).on(albums.id == nominations.album_id)
    .select(artists.id, artists.artist_name)  # assuming the column is named artist_name
    .where(albums.release_date.between('1990-01-01', '1999-12-31'))
    .where(nominations.award == 'MTV')
    .where(nominations.won == False)
    .groupby(artists.id, artists.artist_name)
    .orderby(fn.Count(nominations.id).desc(), artists.artist_name)
    .limit(10)
)

I think PyPika answers your concerns about

What if one method wants the result of that but only wants the artists’ names, but another one wanted additional or other fields?

It’s just regular Python code, same as the Django ORM.

⁨Comment⁩ on ⁨Is there something better than SQL?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
I’m pretty excited about PRQL. If anything has a shot at replacing SQL, it’s something like this (taken from their FAQ):

PRQL is open. It’s not designed for a specific database. PRQL will always be fully open-source. There will never be a commercial product.
⁨Comment⁩ on ⁨What languages are well suited for testing SDKs written in multiple other languages?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
I don’t think you really have a choice TBH. Try to do something like that sounds like a world of pain, and a bunch of unidiomatic code. If you can’t actually support 4 to 10 languages, maybe you should cut back on which ones you support?

One interesting thing you could try if you really don’t want to cut back is to try having using an LLM to take your officially supported code and transliterate it to other languages. I haven’t tried it at this scale yet, but LLMs are generally pretty good at tasks like that. I suspect that would work better than whatever templating approach you’ve used before.

If neither of those approaches works, everything speaks C FFI, and Rust is a modern language that would work well for presenting a C FFI that the other languages can use. You’re probably not hot on the idea of rewriting your Go tests into another language, but I think that’s your only real option then.
⁨Comment⁩ on ⁨Any good alternatives to Home Assistant?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
Have you used either of them before and have opinions on them vs HA?
Any good alternatives to Home Assistant?
Submitted ⁨⁨1⁩ ⁨year⁩ ago⁩ to ⁨selfhosted@lemmy.world⁩ | ⁨27⁩ ⁨comments⁩
⁨Comment⁩ on ⁨Giving up on selfhosted email / Any sane email setups?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
For mobile with fastmail, I use fairemail. Works great with it, and provides a nice merged view with my non-fastmail work emails.
⁨Comment⁩ on ⁨Do you know a VPS prices and features comparator website?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
This site is specific to AWS, but you might find it helpful:

ec2instances.info

Looks like it got bought out by someone, so might be enshittified, but it’s worked nicely for me in the past.
⁨Comment⁩ on ⁨What is the best file format for configuration file?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
Dhall
⁨Comment⁩ on ⁨Disney to Crack Down on Password-Sharing Too⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
My SO just set up a new account because of Netflix’s new policies. Like it or not, it’s working out well for Netflix
⁨Comment⁩ on ⁨[deleted]⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
I’ve never heard of either of these. I’ve got Signal and Element/Matrix. Why should I care about anything else?
⁨Comment⁩ on ⁨Opinion - AI is the future of gaming.⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
You got pretty downvoted here, but I think we’ll see this happen within a few years. It already exists in a basic form with projects like AI Dungeon. It’s “just” a matter of marrying that to some nice graphics.
⁨Comment⁩ on ⁨I've noticed that lemmy as a whole is much more leftist than reddit (outside of political servers of course)⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:
That’s the important bit. The creators of Lemmy needed to be hard leftist to keep it from being taken over by right wingers before it could become popular. Now it’s big enough that the community isn’t as leftist as the creators, but will still reject turning into another voat.