[ home / rules / faq ] [ overboard / sfw / alt ] [ leftypol / siberia / hobby / tech / edu / games / anime / music / draw / AKM ] [ meta / roulette ] [ cytube / git ] [ GET / ref / marx / booru / zine ]

/tech/ - Technology

"Technology reveals the active relation of man to nature" - Karl Marx
Password (For file deletion.)

Join our Matrix Chat <=> IRC: #leftypol on Rizon

| Catalog | Home

File: 1633038134278.png (276.31 KB, 680x703, officecuck.png)


Proprietary SQL: IBM DB/2, Oracle, Microsoft SQL Server
FLOSS SQL: MySQL, MariaDB, Postgres
No-SQL: Mongo, Cassandra, CouchDB, other proprietary shit like elasticsearch.
NewSQL: Google Spanner, CockroachDB
Nu-NoSQL : Terrabase/Skytable, TerminusDB ???

Why the fuck are there so many database companies now? Did people get so butthurt off mysql, etc. not scaling to google scale of billions of users that they decided to fuck off SQL forever? I thought the the nosql craze ended when postgres started offering json store but now I see companies like Skytable, TerminusDB trying to make new databases as well.

Ironically the CTO of TerminusDB used to be a Marxist, Gavin Mendel-Gleason. Even did some interactions with Cockshott. You can still find his blog articles online.

Is there any point of this shit? Properly normalized, tuned, relational DB's with optimized sql queries, indexes, materialized views, and decent replication can probably handle hundreds of thousands of users, and possibly several million users if the hardware is buff enough and you have decent DBAs/database people. This already covers 99% of uses. Also the vast majority of data out there can be modeled relationally, shit like mongo only became popular due to javascript hipsters wanting a dumb json store and not understanding sql/relational db design.

Redis/Memcached are in a different category as in memory db's are often used for caching, or storing session/login data or misc. tokens or something and not as a main data store. So they actually have a use. But the rest of this shit?

Other than a facebook, google, instagram tier service, there's almost no reason to go beyond a traditional relational DB. Maybe some niche company who needs a graph db (social network possibly?) or niche type db for geospatial data or something.
Post too long. Click here to view the full text.
10 posts and 1 image reply omitted. Click reply to view.


no my startup internally extrapolates the universe from its internal state so no data needs to be imputed :)


just use mySQL or postgres


Data involving lots of relationships are a pain in SQL, which is where graph databases are better at. If you ever had to do many-to-many relationships in SQL you know the pain. That's where graph databases like TerminusDB are useful for.

Agree with you about Mongo though. Although I do like it for rapid prototypes.


having a ton of many-to-many relationships is a sign of bad design and a need to go back to the drawing board with regards to modelling and alot of the time many to many relationships can be solved using a join table:


What you're saying is true, but what the other anon is saying is also true. AI and massive data lakes are only useful in narrow scenarios but (mis)applied in all scenarios.

And on top of that, there is a lot of mystification of what AI or "big data" actually is and is doing, and enormous amounts of propaganda.

This meme has been around for 10+ years. If anything, it has died down from what it was 8 years ago.
And also join relations exist for a reason. The idea of tables and relations is a very sound one.

A big trend coming up is application level joins. Especially in the context of "Micro service architecture" but applied to a single API/server. And I hate it. At this point my hate has become so large that I now advocate for as much as possible to be done by the database, and on the application level, use bespoke SQL queries.
If you're starting a new project there's really no reason to use mysql over postgres.
Also fuck Mongo and all the stupid fucking trends and those who jump on them.

File: 1644624210201.jpg (132.08 KB, 774x756, dead zoomer.jpg)


I wonder if the algorithm really is this scarily good that it can even detect the length of the skirt in videos?
No wonder it's so addictive for the average person. If the botnet is already this advanced I don't want to imagine how bad things are going to get in the near future.


>stop watching car video half way
>ok you don't want to watch car videos
>watch a video of a girl dancing twice
>ok you want to watch videos of girls dancing
This is such a simplistic way to do it. It's actually kind of bad because if you re-watch the same clip it means you are going to spend more time on that piece of content that you could spend on other pieces of content. Realistically if you wanted to optimize for one metric based on watch time (which by itself is dubious) you'd want to go for something like watching most or all of the clip before moving on. There's also an extremely dangerous assumption built into this about metrics, some real anglo mentality. Just because the algorithm is noticing a pattern and deciding on something doesn't mean the algorithm is correct. It might be very reliable at determining something but that doesn't mean it's doing a good job of interpreting the data coming in. It only knows the metrics that the system feeds it. It doesn't know for example that this guy was so dissatisfied with his experience on tiktok that he raised the issue of the algorithm not doing what he wanted to a techie, who then smugly assured him that it's not a bug but a feature. That's the real scary thing there: not that the algorithm is actually smart, but that so many people will take it on faith that what the algorithm tells you is true.


>making broad generalizations based on limited data?
>pfffft, typical anglo mindset


File: 1644484831678.png (631.59 KB, 1280x1175, 1644467972648.png)


ARM was a mistake.
4 posts and 1 image reply omitted. Click reply to view.


>who cares
Socialists care because they care about upholding personal property. Without an open bootloader, you can't install the operating system of your choice and that means you don't own your stuff.


yeah but the chart is mostly smartphones which you'd expect to be locked down as fuck, usually
i like the look of the pinephone


>which you'd expect to be locked down as fuck
No my expectation is that all gadgets are open because computers are supposed to be programmable. A locked down boot loader is a defect.
>i like the look of the pinephone.
The recently released Pinephone pro is looking promising


No, it's even worse because it's designed to be as straightforward as possible to extend. In the future you won't even be able to trust that a compiled binary will run on one RISCV chip vs another.


what the hell

File: 1644585550701.jpg (275.64 KB, 2048x1021, 1644360575840.jpg)


They have a combined net worth of 423,1 billion dollars yet neither of them is funding male pattern baldness research
literally why? why are they doing fellow baldcels like that? thank you jeff and elon thanks to you i will never be able to get laid



musk got hair plugs though





File: 1644211650805.jpg (108.59 KB, 726x600, 1644204928164.jpg)


Now I don't subscribe to Great Man Theory but I still believe this asshole single-handedly ruined the entirety of the tech industry.
17 posts and 1 image reply omitted. Click reply to view.


>we also need A Torvalds and Stallman moment for Hardware
i wonder why alternative semiconductor fabrication plants with open source designs don't come out. it could be extremely lucrative


Because it is fucking expensive.


File: 1644373295476.jpg (231.83 KB, 751x1024, 1644361043874.jpg)

iToddlers BTFO.


>it could be extremely lucrative
How? All their R&D will be copied by competitors.


Almost had it. Homosexuals don't have a phone for them yet. Although those rose gold iphones make my bussy hot ngl.

File: 1641419090144-0.png (73.44 KB, 1200x1200, 1200px-XMPP_logo.svg.png)

File: 1641419090144-1.jpg (99.62 KB, 1296x751, Madrid_may_day375.jpg)


Currently, the best you can hope for when looking for a secure XMPP client is Pidgin and Gajim, which is not ideal. Aside from rampant security issues and lackluster development/maintenance, there is no integrated OTR and OMEMO support.
Historically, the reason for this disappointing selection has been due to the sabotage of porkies like at AOL or Microsoft who purposefully killed the project so their own software could hold a monopoly.

So, in the spirit of communism, I'd like to propose an autonomous community project for developing and maintaining a client:
- Multiplatform (Linux, Windows, MacOS, iOS, Android)
- Modern, default features for stuff like end-to-end encryption and media sharing, etc.
- Proper delegation of dev duties according to principle of mutual aid. Individuals contribute what they can and the group determines how it fits into the project and how the individual could be supported in their contribution
- Up to date with https://xmpp.org/extensions/
- In-built default OTR, and for groupchats, OMEMO. The client shouldn't generate keys for the user though

Pointless, confusing modularity on the user's end can instead be done for them by a smart, mutualistic development team that are themselves users that want a proper chat client.

Let the ruling classes tremble at a communistic secure chat client!
21 posts omitted. Click reply to view.


>what more do you want?
something that isn't just a checklist tbqhwy


File: 1642146954156.jpg (32.81 KB, 615x720, knatte.jpg)

yes, and integration with facegooglecord
so you don't know what you want? fuck
it's like a friend of mine says: users are like clients, except they don't pay


you should be a patronizing techlord elsewhere


File: 1642160402976.jpg (55.47 KB, 1000x669, gno.jpg)

>the user thinks they have anything important to say


Simple PGP could be better than OTR

File: 1644014802037.jpg (19.47 KB, 383x400, arch user.jpg)


Anyone else having random constant crashes of Firefox and derivative browsers (like Tor)? Checking the logs there's always this line before it closes:
> firefox.real: xcb_io.c:269: poll_for_event: Assertion `!xcb_xlib_threads_sequence_lost' failed.
I haven't been able to find much when searching for this but it seems to be related to GTK? I'm on a rolling release distro and it happens independent of window manager.




File: 1644016400738.png (13.68 KB, 800x800, ClipboardImage.png)

yes you archslaves are supposed to fix this before it touches my beautiful distro. Get back to work.


OP here. After fucking around in about:config and trying multiples things I think I may have fixed it by turning webrender on (gfx.webrender.all = true). Any warnings about doing this?


Navigate to about:config
set gfx.webrender.all to true
set gfx.x11-egl.force-enabled to true (on linux only)
set gfx.webrender.compositor to true
set layout.animation.prerender.partial to true
set layout.display-list.retain.sc to true
set fission.autostart to true
set fission.sessionHistoryInParent to true
set fission.bfcacheInParent to true
set browser.tabs.documentchannel.parent-controlled to true
set docshell.shistory.bfcache.allow_unload_listeners to true
set security.pki.crlite_mode to 2
set accessibility.cache.enabled to true
set accessibility.force_disabled to 1
set extensions.pocket.enabled to false

File: 1644281075873.png (806.49 KB, 640x809, z5pffctttjd81.png)


I recently encountered this article. Given the nature of the framing and use of language concerning the DPRK and the general nature of English-language reporting on the DPRK, I was wondering if someone had comprehensively fact-checked this article.
>North Korea Hacked Him. So He Took Down Its Internet
>Disappointed with the lack of US response to the Hermit Kingdom's attacks against US security researchers, one hacker took matters into his own hands.

>pic because I had no directly relevant pic

>although I suppose it is tangentially relevant

File: 1641581718791-0.png (1.14 MB, 1000x563, ClipboardImage.png)

File: 1641581718791-1.png (154.35 KB, 360x203, ClipboardImage.png)


I didn't understand the whole GPU prices meme all these years until now

I had a budget note.
I went over and looked at the price of a GPU I wanted to buy, and it's price now


THE FUCKING AUDACITY, to think that their worthless tins of silicone are worth this much because of FUCKING VIDEO GAMES?

I don't even care about having the latest card for this video game bullshit

But the fact that I am subject to buy a shitty 2000's bum ass "gpu"or amd gpu's with shit ass drivers or even worse go dumpster driving of some consoomer's recycled gpus?
It disgusts me

Post too long. Click here to view the full text.
7 posts omitted. Click reply to view.


if you want "basic" stuff,jut get a very good (a 7th for intel,you don't have to buy a 9th,and AMDs are pretty good) CPU with integrated graphics,it's better price wise at this moment.
Especially if it's just gaming,if you want to do 3D modeling,you have to buy the damn graphics card,I'm sorry.
tfw bought a 1660 super at 200 euros before the prices exploded,and my friend has a 3080 that came with a 1100 built PC.


What you want to happen is the bottom to fall out from etherium


No, it's because of coronavirus actually.


If you're on Linux do not buy an nvidia card.


Most? No, and the processors with integrated graphics tend to underperform compared to the main ones.

Delete Post [ ]
[ home / rules / faq ] [ overboard / sfw / alt ] [ leftypol / siberia / hobby / tech / edu / games / anime / music / draw / AKM ] [ meta / roulette ] [ cytube / git ] [ GET / ref / marx / booru / zine ]
[ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / 12 / 13 / 14 / 15 / 16 / 17 / 18 / 19 / 20 / 21 / 22 / 23 / 24 / 25 / 26 / 27 / 28 / 29 / 30 / 31 / 32 / 33 / 34 / 35 / 36 ]
| Catalog | Home