Thread 106619601

Do you agree that SQLite is the best db for most web apps?

>Free beginner resources to get started with HTML, CSS and JS
https://developer.mozilla.org/en-US/docs/Learn - MDN is your friend for web dev fundamentals
https://web.dev/learn/ - Guides by Google, you can also learn concepts like Accessibility, Responsive Design etc
https://eloquentjavascript.net/Eloquent_JavaScript.pdf - A modern introduction to JavaScript
https://javascript.info/ - Quite a good JS tutorial
https://flukeout.github.io/ - Learn CSS selectors in no time
https://flexboxfroggy.com/ and https://cssgridgarden.com/ - Learn flex and grid in CSS

>Resources for backend languages
https://nodejs.org/en/learn/getting-started/introduction-to-nodejs - An intro to Node.js
https://www.phptutorial.net - A PHP tutorial
https://dev.java/learn/ - A Java tutorial
https://rentry.org/htbby - Links for Python and Go
https://quii.gitbook.io/learn-go-with-tests - Learn Go with Tests

>Resources for miscellaneous areas
https://github.com/bradtraversy/design-resources-for-developers - List of design resources
https://www.digitalocean.com/community/tutorials - Usually the best guides for everything server related

>Need help? Create an example and post the link
https://jsfiddle.net - if you need help with HTML/CSS/JS
https://3v4l.org - if you need help with PHP/HackLang
https://codesandbox.io - if you need help with React/Angular/Vue

/wdg/ may or may not welcome app development discussion. You can post and see what the response is.
Some app technologies of course have overlap with web dev, like React Native, Electron, and Flutter.

We have our own website: https://wdg-one.github.io

Submit your project progress updates using this format in your posts, the scraper will pick it up:

:: my-project-title ::
dev:: anon
tools:: PHP, MySQL, etc.
link:: https://my.website.com
repo:: https://github.com/user/repo
progress:: Lorem ipsum dolor sit amet

Previous: >>106544071

>web
Absolutely disgusting

>>106619720
i identify as a spider

>>106619752
me too

>>106619752
he cute

>>106619601 (OP)
https://files.catbox.moe/bdwom7.mp4
https://youtu.be/dnRkQVvTnb8
>>106618148

yes because most apps never surpass 1 user

:: gg/example ::
dev:: gg
tools:: Common Lisp, hunchentoot, hunchensocket, easy-routes, spinneret, mito, htmx, Pico CSS
link:: http://beastie.sdf.org:4200/
repo:: https://git.vern.cc/gg/example
progress:: I got websockets to work on more browsers.

- This is just a little place where you can anonymously post text.
- When posting, name and subject are optional.
- You can register and login, but most people don't.
- I like how form validation turned out, though. (Try submitting wrong registration forms.)

>>106619601 (OP)
SQL sucks. It was literally made for normie no code fags.

>>106619720
webshit is a glorified CRUD in a database 98% of the time

>>106619601 (OP)
SQLite is bloat, I just use raw binary files.

>>106620422
already beat that

>>106619601 (OP)
>
probably enough for most usecases, but having a fully featured db can be a nice thing too

>>106621704
>hover
>get covid + aids
kekerinos

>>106619601 (OP)
I use Postgres because it just works and it supports lots of useful extensions

What's the benefit of SQLite?

>>106620432
Don't underestimate SQL.
https://x.com/andy_pavlo/status/1659740200266870787
https://db.cs.cmu.edu/papers/2024/whatgoesaround-sigmodrec2024.pdf

>>106622740
>What's the benefit of SQLite?
If you're working on something relatively small, having no server setup to deal with is convenient.

>>106622750
Fucking shit title with no relation to the content

>>106622773
It *does* relate to the content. People have been bitching and moaning about the death of SQL for a long time, but it never happens. If anything, SQL has been getting stronger. The current generation's whining about SQL is nothing new, and the authors decided to take a look at why SQL has the staying power that it has.

>>106622740
>what do those extensions provide? curious because pg is super feature rich already

I'm trying to make some portfolio project, I don't have much expirience with webapps, so I want to make a simple cms, my idea is to keep every url in db, so that every resource can have friendly link, so I want to have a simple table with url=>controller/method/resource_id (baka like that) translations, is it a good idea?

>>106622949
slugs, look it up, from page title through string processing you get a unique slug, or just explicitely define the slug, why not, that slug is ur "friendly url"

Was trying to fix aliasing and got some sweet looking signal glitch

>>106619601 (OP)
If your data is not important your app doesn't need to exist. It's called a datacenter right? Not a fucking app center

>>106623042
sick, keep pushing I'd say, vfx is a beautiful world

>>106623078
I'd argue that if you extract complexity from ur db, ur somehow moving it to the server, doesn't seem optimal to me, but perhaps cost effective, since an actual db expert might take a good bite in the salary

>>106622978
ty, but my question is more about where to store them, cause I also want to have some aliases like / /home /main all directing to the same page and stuff, I just want to know if storing this data in db (like you know, mysql or baka) in form of key=>value map is a good idea, or maybe there's some better way to do it

>>106623313
I'm not a pro at this, but this is how I did it
1. Stored posts/articles in a table register
2. each register had an ID, the usual uuid, regular bigint, doesn't matter
3. each register had a slug, that slug had unique constraint modifier, so 2 registers couldn't have that same slug
4. posts/unique_slug that fetched the register by slug name same way you fetch a register by id
5? Ideally (didn't do.that myself) use id under the hood for fetching, somehow still manage to use the slugs since they come with the same register
6.? If the system somehow gets big and you still use slugs, u'll need to set up db index, to speed ub the db fetch tines

>>106623313
You shouldn't store all the routes individually in the database and query it to match every request.
Routing should be handled when the request comes in to the front controller. You set the web server to direct every request to that.
You set up a router there, which calls the appropriate controller for the resource based on the patterns in the URL. "/home" and "/main" and "/" to go to the home controller. These are 3 patterns.
You can also use slugs as identifiers, like "/articles/{slug}". The controller receives the extracted values from the URL and it'll query the database based on the slug or the ID or whatever.
>www.aljazeera.com/economy/2025/9/16/tesla-faces-safety-investigation-due-to-faulty-door-handles (the entire thing is probably used for looking up the article)
You can add optional parameters too, just for decoration:
>www.tumblr.com/{userName}/{postId}/{slug} (slug is just optional so users can see what the link it about, it isn't used for queries)
>www.twitter.com/{userName}/{postId} (userName is actually optional)

>>106623656
here
>>106623689
second, routers or whatever they're called are a good abstraction to optimize routing

>>106623689
do u use laravel btw? ur abstractions are like 1:1 laravel architecture

>>106623733
No, but I do use PHP. But this pattern is very common anyway, with different levels of abstraction.
I want to try Laravel, it looks decent and it's very popular.

>>106623776
word of mouth is to use symfony, but with hexagonal architecture approach, aka only use the bits/services of it that you want and not the full framework as is

>>106622740
I've used SQLite for the save system in a small game I made. It just werked.

>>106623949
I see the appeal, but I want to use full enterprise solutions for the hell of it, the amount of features pg has is amazing

practiced callbacks the other day, I'm getting there, I understand why there's so few questions here, I don't think is the right thing to do though, but fully understand it, I'm polishing my weaknesses in js and having a blast thanks to gpt, should switch to chinesgpt though, anyone here has used chinesgpt for programming assistance?

>>106625672
>should switch to chinesgpt though
Why?
>anyone here has used chinesgpt for programming assistance?
I haven't, because I don't want the Chinese government to harvest all my data

>>106626332
well, certain people own gpt, and they're evil as fuck, I'd rather have 0 of my data, I literally trust chinese way more than I trust them

>>106626332
>I don't want the Chinese government to harvest all my data
Why not?

>>106626377
>>106626332
*I'd rather they have 0 of my data

>>106619601 (OP)
>Do you agree that SQLite is the best db for most web apps?
it's good and even better for dev and test, but if you ever plan on running more than one instance of your app, either for multi-region low latency or other reasons, it will never work. if you're reaching for some faggy clustered sqlite bullshit, you've gone full retard imo. but ya. one big ass giga server would likely be better served by sqlite with something like litestream for live read only replica somewhere else.

>>106620432
this... I only use sqlite because I'm too lazy to reimplement fts5 on top of something like rocksdb.

>>106626405
>it's good and even better for dev and test, but if you ever plan on running more than one instance of your app, either for multi-region low latency or other reasons, it will never work
It will work if you have data that doesn't change a lot. And SQLite not having a network connection and being embedded means that it's going to be blazing fast. It's the best choice if you have mostly reads.

>>106627265
>It's the best choice if you have mostly reads.
nta, but wait, that one BE benchmarking site almost always uses pg on the top rankings

>>106627265
Ok fine? But I think if you're leveraging meme features you're still doing something stupid. A proper rdbms will likely have proper clustering available.
Personally I prefer key-value databases like rocks or fjall or something.

>>106626377
>>106626392
>>106626403
Fair. I'm just not sure I trust the Chinese government.

>>106627309
Or if you're a go cuck, badger db seems to work for me.

>>106619601 (OP)
>Do you agree that SQLite is the best db for most web apps?

Isn't sqlite populare mostly because it's light weight and phone apps use it versus servers? i've always used postgres for my personal shit just because every job i've had uses postgres

>>106627310
I trust no government period, but if I have to choose...

>>106620432
>made for normie no code fags
>he's never worked on an actual production normalized database that needs like 10 joins to get any useful data

people who think sql is easy are using data so small and simple that they may as well switch to excel

>>106627359
He's not wrong though... It was basically designed by some retard and some people think "relational" DBs are backed by sound mathematical axioms.

>>106627359
>they may as well switch to excel
sick diss ngl

excel web queries go brr

>>106627438
>excel web queries
I really don't want to know what is that about

>>106627459
Excel can fetch on open and parse html tables

I, like many others, struggled to find a CS job for ages but I eventually landed an ERP developer job. My company uses Netsuite, and honestly it's a pretty easy job but I feel like it's too soulless. I know some web dev but I didn't delve too deeply into it, and lately I've been thinking of switching fields. Any idea how I can get started? I've seen The Odin Project and Fullstack Open mentioned on reddit but I don't know if they still hold up in current year. Any resources or roadmap I should follow? How can I pivot from ERP to Web Dev?

>>106619601 (OP)
>Do you agree that SQLite is the best db for most web apps?
If not "most web apps", definitely more than people give it credit for. The hype in the last few years is well deserved. Focusing specifically on your choice of words being "most web apps" instead of "most web sites", apps whose features and data rarely cross account boundaries? Perfect for those. For something like ecommerce, which I wouldn't necessarily call a "web app" or even web apps that a more marketplace-like, not so much. Even within larger apps that have something like Postgres or MySQL for their main DB, if they are supported by services with read-heavy use patterns, those could be built with a much simpler architecture using SQLite.

>open transaction
>start writing
>SQLITE_BUSY
It's all so tiresome.

I usually have one thread do all my writes, but that doesn't always work for everything. It's ok otherwise if you know the absolute bullshit you need to configure at startup or schema creation. I usually have my sqlite stuff run a bunch of code when "connecting." Make sure to test this because I've accidentally dropped in a thread pool and some connections didn't apply the same per-connection settings.

>>106627676
I would use those words in the opposite way. An ecommerce website is clearly a web app to me (and I would absolutely not use SQLite for it), a personal blog is more like a website than an app, though it could be thought of as an app too (and I would absolutely use SQLite for it if I can).

So what's stopping us from rewriting a FOSS version of the Q-sys ecosystem based around the web and creating our own career field all together based on installing AV to people on any hardware we want rather than Qsys standard hardware, and programming controllers for people with HTML, CSS, and JS instead of HTML, CSS, and Lua?

I feel like it's a hidden sleeper career. You guys have no idea how big the market is for Qsys and that type of products; and the people who install and set up the AV stuff using it.

Web FOSS nerds would easily maintain that shit.

>>106627888
WAL and BUSY_TIMEOUT

Bump

how do you inspect modals/dynamic elements that disappear when the window loses focus?
I have tried setting breakpoints on subtree modifications etc but when I then use step-by-step in the debugger the submenu (with the playback speed options) never shows up

I want to see the dom/html for the modal list of playback speeds because they gave it retarded padding (probably on purpose) that makes it more annoying to set it to 2.0 because you have to scroll

>>106627552
between the two, I'd take fso, however it is probably not enough and you should keep your eyes on junior/internship/entry job posting requirements

>>106631533
this here is essentially the problem

you don't use utf-8, r-right anon?

>>106631787
I use UTF-8 with BOM.

>>106631533
that'd be a challenge, either see if hover modifier on elemnt inspector does the trick, or find the class they are toggling and add it or just disable the class status that hides them
remember that you can modify html, and overwrite css

>>106631810
>>106631573
>>106631533
there's also inspect element keyboard shortcut as another trick to try

>>106631533
>>106631573
Oh I happen to know the solution to that.
If you go to the dev console and simply type debugger, then it completely freezes the page and all scripts on its o you can inspect it as much as you want.

Problem is, sometimes it's hard to execute the debugger in the console while also making the dynamic element visible at the same time.
In that case, you can just put the debugger command in a setTimeout, like this:
setTimeout(() => {debugger}, 3000)
Put it in the console, open the dynamic element, and in 3 seconds it'll freeze the page.

>>106631858
>setTimeout(() => {debugger}, 3000)

huge help
thanks

>>106631915
np, this is very useful for when you want to inspect hover tooltips and so on.

>>106631573
>>106631533
>>106631819
>>106631858

fwiw, on Chrome you can cmd+shift+p (or ctrl+shift+p I think on windows) -> Emulate a Focused page

then you can just click to inspect the elements that disappear after losing focus

>>106632176
noice

>>106631858
absolute beast

>>106632176
>>106631858
>>106631819
>>106631573
bussin' I'm going to save all these, any more tricks like that?

>>106632222
[][(![]+[])[+!+[]]+(!![]+[])[+[]]][([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+([][[]]+[])[+!+[]]+(![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[+!+[]]+([][[]]+[])[+[]]+([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+(!![]+[])[+!+[]]]((!![]+[])[+!+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+([][[]]+[])[+[]]+(!![]+[])[+!+[]]+([][[]]+[])[+!+[]]+(+[![]]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+!+[]]]+(!![]+[])[!+[]+!+[]+!+[]]+(+(!+[]+!+[]+!+[]+[+!+[]]))[(!![]+[])[+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+([]+[])[([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+([][[]]+[])[+!+[]]+(![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[+!+[]]+([][[]]+[])[+[]]+([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+(!![]+[])[+!+[]]][([][[]]+[])[+!+[]]+(![]+[])[+!+[]]+((+[])[([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+([][[]]+[])[+!+[]]+(![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[+!+[]]+([][[]]+[])[+[]]+([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[+[]]]+(!![]+[])[+!+[]]]+[])[+!+[]+[+!+[]]]+(!![]+[])[!+[]+!+[]+!+[]]]](!+[]+!+[]+!+[]+[!+[]+!+[]])+(![]+[])[+!+[]]+(![]+[])[!+[]+!+[]])()((![]+[])[+!+[]]+(![]+[])[!+[]+!+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]+(!![]+[])[+[]]+([][(![]+[])[+!+[]]+(!![]+[])[+[]]]+[])[+!+[]+[+!+[]]]+[+!+[]]+([]+[]+[][(![]+[])[+!+[]]+(!![]+[])[+[]]])[+!+[]+[!+[]+!+[]]])

>>106632222
for quick web page editing (you want to change some text for screenshots perhaps), you can do:

document.designMode = 'on'

>>106632261
>>106632282
ok here's my top tricks
1. editing the styles in the element inspector
2. editing the styles/overwriting them on the css style sheet view
4. using the hover modifier on the eleme t inspector

>>106632261
>harddrive spins up

>>106632434
shills use pepe OPs to post slide psyops and generally shit threads that take space and contribute nothing, stop pepeposting, it is the mark of the ultimate newfaggot

>>106632489
oh how brave of you

Do any of you work at a company that needs junior web devs right now

I need a bloody job

>>106632626
check intern possitions as well, they pay worse but some times are the gateway to an ok position a year later, as always, nothing is promised

>>106632261
>a certain combination of square brackets, parenthesis, plus symbols and exclamation marks is turing complete javascript

and this is apparently a toy language?

>>106632675
js is extrenely good and extremely shit at once

i got stoned and vibe coded together a CMMS clone and it is like 8000 lines of javascript. am i gonna make it? i've never coded and barely undertsand what is going on

am i gonna make it?

>>106633608
in a short tem future maybe, you'll just need to be pro at marketing bullshitting, your target is a manager that relly bought into the AI hype and you're the man who is going to save him and make him money at the same time, wouldn't like to be that dude, but maybe you do
but remember you have no clue of what the code is actually doing

>>106619601 (OP)
oh no no no no no

>>106634941
>just add more packages
now what? serious question, now fucking what? And I say this as somebody that admires node's simplicity, might as well go back to php at this point, fuck spring and java's verbosity, and go is from the murderers of the web

what do you use for optimizing your PNGs' size for the web?

>>106635493
save as... webp

>>106635493
gig with 5 colors (jk)

>>106635930
.gif

>>106635493
optipng, oxipng.

>>106631533
Press f8 while the source view/debugger is open and it'll pause

about those element inspector tricks, I'll compile and write them into my clay tables, and share with you, so keep them coming if you have them

>that op

>at work
>um why are you using *not oracle SQL*
I am GOING INSANE who fucking likes Oracle anything? You can't even talk to oracle SQL without nonfree software!

>>106636464
pg

>>106636464
>who fucking likes Oracle anything?
enterprise, pretty much exclusively

Let's say I need a new laptop and I like the idea of trying to make an iOS/Android app with React Native (in addition to web dev)

Should I get a MacBook or a PC laptop? You need MacOS (with Xcode) to compile an iOS app. But on Linux you can run the Intel version of MacOS in a VM. The downside though is that MacOS Tahoe (new version) is the last Intel version of MacOS - future versions won't run in a VM on a PC laptop.

>>106636487
ya, but I'm targeting SQL Server. Isn't that E N T E R P R I S E enough?

>>106636479
>pg
as in Paul Graham? well he probably throws weird rich people occult parties with "Lucky" Larry Ellison.

>>106636535
it's the shitty kind of enterprise, the kind of enterprise that got vendorlocked with office, windows and such, don't get me wrong MSQL is good shit, good shit that I'd rather not touch, but good shit regardless

>>106636542
>Paul Graham
>googles it
yes, he seems very satanic parties with minors, torture and sacrifices kind of guy

>>106636556
at least TDS is a documented protocol you can implement open source drivers from. hell basically every non meme language has a odbc, jdbc or other TDS driver. can't say the same for Oracle. they all require OCI (probably built for some random ancient Ubuntu distro libc and libs too) or they're the nonfree Oracle JDBC drivers.

>>106636542
as in postgres common abbreviation, pg

>>106636594
why would postgres like Oracle....

>>106636575
MS are betting on opensource I noticed since scratching the surface with .net
>>106636601
mortal enemies, but pj is LIKE oracle in a way that is feature rich as fuck

>>106636611
I vaguely remember even like 10 years ago jtds existed. I think the TDS protocol was well known for as long as I knew it. only ever bothered with mysql back then though.

>>106636620
MySQL, my first tries with a DB, comfy, I think it is now MS's prperty and the fork is MariaDB
I have to bully the BE devs to get me more SQL shit to play with, not getting paid for it, but fuck it, I was top dog in DB in my class for something

>>106636631
>I was top dog in DB in my class for something
kek. I remember those days. teacher gave us Oracle VMs, I ended up doing everything with sqlplus because I hated the stupid pl/sql whatever shit tool oracle has. teacher docked me points because of this and because I did like 7 levels of joins (with a cross join even) just to show I understood the material and dab on the whole fucked up thing.
asked the tard to use sqlite for training instead since it's more accessible and more immediately useful for people to build projects on in college than some nonfree gayware db.

>>106636648
in our class if you slept one class and not made the homework you were pretty much fucked, because he stacked every new component on top of the other one you learned previously, shit was fucking hard, you were juggling like 7 types of shit together, and on top of that there was an optimal way and a retard way

I'm learning CSS and UX, but I have no idea about human first design. Is there a website/catalog that lists every useful and practical component with a explanation of its purpose and how to use it effectively. I am a backend guy trying to do it all right now and I'm really stuck on how to design the interface that is intuitive on both mobile and desktop. It's a hobby project for learning, a social media chat room like Twitter but real time and you can filter posts by tags etc. I want to put on the page a logo, search box, links (FAQ, account, etc), the main content itself, and a reply box

>>106636631
>MS's property
Oracle's
>the fork is MariaDB
yep. another major one is Percona MySQL.

>>106637345
oracle is being greedy
>Percona MySQL
>googles it
very red hatty kind of deal, hate the idea

>>106637017
I found exactly what I needed
https://lawsofux.com/
https://ui-patterns.com/patterns
https://www.lukew.com/ff/entry.asp?1514
https://bradfrost.github.io/this-is-responsive/patterns.html

All sites are clean, and exactly what I wanted which was just a catalog of ideas to build off. These are so good I think the 2nd and 4th should be added to the sticky

>>106638738
that's a lot of theory, what would you highlight? I particularly like to be creative, but I've lately developed a thing for usability, the idea of it is pretty fucking sick, take as big as a sample of users you can take, track their interactions and intentions extenssively, their mouse cursor, movements, etc. but that's already too late, or too early, some times you just gotta take them and say ok you're in a blank screen, your objective is to do n task, how do you go there?
and they'll tell you different user flows, so you take whichever takes the most sense and try to polish it and improve it, make prototypes, test them again, what works what doesn't what is easy for the user, where does he get stuck, how can we improve his journey

>>106636525
Get a MacBook most certainly if you can afford it, with at least 16gb ram. If you intend to do anything with iOS.

Windows laptops are utter shit anyways, in terms of build quality and battery life.

>>106637893
>very red hatty kind of deal, hate the idea
Percona is fully compatible with MySQL (you use some of their extra stuff, which is turned off by default). MariaDB is not, and it isn't even fully compatible with everything that expects the DB to be MySQL.
If they ever discontinue Percona, you can simply switch to the official MySQL release.
I find this the best way to use MySQL in 2k25.

>>106640672
I see what you're saying, and it is off course valuable. What I was trying to point out is that "we offer support", in my opinion, might lead to shitty documentation and "half working" features on purpose, just so you'll come crawling to them. That's fedora to red hat, not sure if it'll happen, but if it doesn't then how are they going to eat?

Web pages

>>106634941
b-but package managers are good!

>>106621704
implemented webrtc today

employed anons what do you guys do most of the days?
build crud apps using different flavor of the same shite?
integrate with third party using different flavor of the same shite?

I feel like I would lose my sanity doing this day in and day out.

>>106642568
Package managers are objectively good. It's convenient to be able to update all your packages with a single command, rather than have to update each package individually.

To me it looks like the problem with supply chain attacks is caused by big projects (React, Vite, other big projects) depending on small packages from random people. Those random people get phished, and their package is replaced with malware, and suddenly everyone who is using React or Vite is downloading malware.

For example, one dependency of React is a package called fast-glob, which seems to be maintained by a single person, a Russian who works for Yandex. This article describes that package as a "supply chain risk": https://huntedlabs.com/popping-fast-globs-hood/

So maybe Meta should not add random packages from random developers as dependencies for React. I'm sure they have the resources to develop everything they need themselves, without having to depend on random packages.

Can somebody tell me about the state of the art in PHP?
In other words:
What would a PHP dev would use these days in terms of tooling and frameworks?


I have done some WebDev in different langs in the past (many years ago) but settled for Data Analyst. Now am I am changing my field of employment again (due to personal reasons) and got a interview for a PHP position next week.

It would be nice if I could explain or at least namedrop some of their stuff.

My current plan is to dabble into laravel and maybe symphony at the weekend..
anything else?

>>106642786
been employed for 8 years doing "full stack" web dev. It varies a lot on the day-to-day stuff, but that's because the company is fairly lean, e.g.:

- daily project management shit (reviewing PRs, creating & assigning tasks, stand ups)
- new front end client facing features (there's always something new that we're adding) and we have projects out of it every few weeks / sometimes months
- backend work with capturing analytics events, MySQL database stuff sometimes if we need specific numbers on things, setting up views for our events on posthog
- working on API integrations sometimes (e.g. payment providers, educational institutions)
- working on some OSS npm libraries that we use in house
- fixing bugs & assisting support staff with tech issues
- deploying & versioning apps (we have android/iOS apps too)
- sometimes refactor projects, e.g. we're migrating a nuxt v2 project over to Astro and also migrating a PHP project from 8.2 to 8.4 with phpstan.
- deployment stuff (Vercel, AWS)
- sometimes cloudflare backend stuff to do with DNS/waf/managed rules
- sometimes AWS account management stuff (e.g. purchase of reserved instances, security groups)
- sometimes provisioning EC2/RDS/Elasticache resources (e.g. did one last week for a meilisearch server)
- going through the sentry error tracker, prioritizing fixes

as said, it's going to change every day but it's probably because I work at a smallish company

>>106642935
Usually

- Laravel as the framework
- phpstan for the static type checking (+ larastan on laravel)
- Rector for code refactoring + modernizing PHP
- the Laravel VSCode extension or phpstorm with Laravel Idea
- intelephense for the IDE checking if you're on VSCode/cursor, it's not as good as phpstorm but works decently

Also if you really get in to it, try out:

- FrankenPHP
- Laravel Octane
- some of the Laravel packages (like sanctum, scout, cashier, etc)

>>106643019
Thanks, I appreciate it

>>106619601 (OP)
why are both going down?

>>106643145
Looks like a screenshot from a YT video I watched a while ago, some dude was doing benchmarks on popular web tech. That probably is something to do with latency, queries per second when concurrency increases (x axis is timeline)

>>106642612
normal conversation

>>106643145
>>106643290
SQLite has much better performance than Postgres. But Postgres has some features that SQLite doesn't have. Only use Postgres if you really need those features.
https://www.youtube.com/watch?v=VzQgr-TgBzc

>>106642612
>>106643603
do you do that thing where there's a renderer and a engine or something like that?
a friend of mine taught me, I didn't understand much, but it was like 1 abstraction controls the values and other renders it or some shit like that
>>106642926
.net has a trillion packages, but I think that for the most part they're created and maintained by microsoft, but don't quote me on that

>>106634239
yeah i dont wanna do that. i just found it fun to try make things that would be useful at my job. i guess i could make a platform and try sell it to the managing director.

>>106644258
>make things that would be useful at my job
maybe you can monetize this, at your very job

how many browsers do you guys have installed on your machine for testing, or do you use some online testing services

>>106640744
Right, I see what you mean. That's certainly a strategy a lot of companies take, that's why I'm really weary of vendor-locking yourself into an ecosystem with no alternatives. Percona is a consulting company though and not just for their own distributions, so I think their being engaged with the software and contributing to open source is the best way they can show off their skills. If they started backtracking on their promise of their distributions being fully compatible, that would really hurt their good reputation.

>>106645562
I have Chrome and Firefox installed. The only other one I should test on really is Safari.

Is AlpineJS a meme?

>>106646798
why would it? we use it at work

Do you have a footer on every page? If no, when do you not have a footer on a page?

>>106642965
What does the company do? Some small SaaS company?

>>106646914
First ask what information the footer is providing, if it's a generic legal disclaimer then just put that in /legal

Now with live audio clipping
>>106644238
>engine
I call it an API wrapper, because it just calls canvas functions

>>106649172
I think you should read some books, because you're shining, imagine shining on top of the knowledge

>>106649172
Please record in more than 12 fps

>>106649883
are you web-gaming?