/wdg/ Web Development General - Web Development Edition

/wdg/ is a no anime safe space, pls respect

>Web Dev 101
youtube.com/watch?v=erEgovG9WBs

>Free beginner resources to get started with HTML, CSS, JavaScript and PHP
eloquentjavascript.net/Eloquent_JavaScript.pdf - A modern introduction to JavaScript
developer.mozilla.org/en-US/docs/Learn - A good starting point to learn about web dev fundamentals
javascript.info/ - Quite a good JS tutorial
theodinproject.com - Curriculum including HTML/CSS/JS, and either Ruby on Rails / SQL, or Node.js / MongoDB
fullstackopen.com/en/ - Requires you to have basic web dev, db and git knowledge
flexboxfroggy.com/ and cssgridgarden.com/ - Learn flex/grid in CSS
phptherightway.com/ - A decent PHP resource
phptutorial.net - A PHP tutorial

>List of design resources
github.com/bradtraversy/design-resources-for-developers

>All useful documentation in one place
devdocs.io

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

We have our own website: wdg.one
Submit your project progress updates using this format in your posts, the scraper will pick it up:

:: my-project-title ::
dev:: user
tools:: Flutter, Php, etc
link:: my.website.com
repo:: github.com/user/repo
progress:: Lorem ipsum dolor sit amet

Previous:

Attached: 1649186794611.png (279x257, 115.82K)

dot cunny dot function dot sex

asking again

Entering celebration mode due to implementing super tricky feature.
Speaking of which... what's the proper "standard SQL"/"cross SQL DB solution" implementation of the MySQL equivalent:

select
col1,
col2,
GROUP_CONCAT(col3 SEPARATOR ', ')
FROM table1
join table2 key1= key2
join table3r on key3 = key4
group by col1, col2;

tl;dr what's the cross DBMS equivalent of GROUP_CONCAT(column SEPARATOR ', ') + group by ?

Attached: 1628622993593.gif (295x210, 189.71K)

There is none because every DBMS has different limits for string columns. You'll have to implement your own.

>You'll have to implement your own.
how with CASE? pls shoe me how

>/wdg/ is a no anime safe space, pls respect
Stfu retard
It didn't even hit bumplimit or later pages yet, classic newfag whining about anime.

Attached: 29ae93a6ba94190cb05a7429ac7ad54d9c9131ca.png (1125x900, 702.95K)

stupid fucking nigger OP

sage

>/wdg/ is a no anime safe space, pls respect
it's also no cowpiss drinker general, go shove shivlingam up your ass

welcome to the burnoutistan general sers

not sure if we're on the same page, what I do is pull a many to many relationship like so:
users - roles
aka each user can have many roles and vice versa.


So what I do is grabb all the roles by a single user and stick it in a single column-row result to avoid repeating results as:
name role
John admin
John editor
Paul user
Paul editor


So there's what I get instead:
name role
John admin, editor
Paul user, user

at query level, not at table structure level

Hobby full stack nerd here. Is it normal to work longer on css/framework until you get what you want compared to sq/backend? I find that i struggle more with css than with anything else.

we get this kind of post contiuously, mostly from back end lads

uoooh

Yes. Everything you've been taught is a lie. Frontend is the hard part and always has been

welcome to real web development

Attached: 1654334482455.jpg (791x534, 356.14K)

>/wdg/ is a no anime safe space, pls respect
kill yourself nigger
don't bump this retarded thread

Attached: 1661959924625.jpg (914x680, 368.34K)

xirs pls do the needful

Attached: 1583074176553.jpg (910x960, 81K)

Frontend is harder than backend, mainly because you have to stay up to speed with every shitty web framework that comes out every couple years or your career is in the toilet.

Backend stuff basically never changes. I mean, sure, the exact libraries may change, but backend engineers are essentially doing the same exact thing at every job. Not trying to insinuate they're "lesser," it's just a more consistent gig.

>don't bump this retarded thread

Attached: 1631012275169.jpg (367x500, 26.28K)

i'm going to bump without saying anything useful at all just so it dies quicker than usual.

anons are right, you should off yourself you wannabe normalfag
hating anime does not make you special

i saged by habit, bump.

nu-weebs are a newfaggot wave from post 2012, but don't worry about that, cause most of them transitioned and many of them offed themselves because of it, nature finds a way

Attached: artworks-000176335511-ay456m-t500x500[1].jpg (500x500, 82.88K)

too many faggot troon newfags in wdg lately

What frontend framework will make me want to kill myself the least?

Bulma

bulma nuts

>we're on the same page

Obviously not. You do not yet understand that A, B, C, ... can be VERY LONG and overflow the DBMS maximum string length. MYSHITQL even has a setting for it.

lol

bump

This is just a UI library though, right? It doesn't have the functionality of React/Angular/etc.

I don't get it, the max string leght would be "Author, Admin"

i neither respect weebs nor indians

Attached: 10348454_759101204133756_552515078400309373_n.png (960x720, 930.79K)

Svelte