ian, to random
@ian@phpc.social avatar

Divs and spans are ignored by screen readers. Use semantic HTML so screen readers know the structure of the document - Paulo Fernandes at the Uncon

ian, to random
@ian@phpc.social avatar

TIL LAG() and LEAD() on dates in windowing functions.

I think I saw this presentation from @auroraeosrose back in 2017 at PNWPHP but I'm catching a lot of new stuff this time.

And this is an uncon talk

rob, to random
@rob@akrabat.com avatar

Lots of great SQL knowledge from @auroraeosrose at this afternoon. Everyone should have been in this one!

Crell, to random
@Crell@phpc.social avatar

"The last time I touched DB2, I got IBM cooties." - @auroraeosrose

Crell, to random
@Crell@phpc.social avatar

"We never want your database to be upset at your query." via @auroraeosrose

ian, to random
@ian@phpc.social avatar

TIL that GROUP BY GROUPING SETS exists. Also ROLLUP, which is even more terse and powerful. Thanks, @auroraeosrose!

This exists in Postgres as of 9.5, while ROLLUP exists in a janky fashion in MySQL.

ian, to random
@ian@phpc.social avatar

OLAP = Online Analytical Processing

The sorta thing that if you let accountants do wrong they'll toast your database.

OLAP is not a character in Frozen.

ian, to random
@ian@phpc.social avatar

"I'll stop lecturing on that." - @auroraeosrose
"No you won't." - @Crell

Crell, to random
@Crell@phpc.social avatar

The government is good at making standards standard.

Until you defund that department, and then it all went to hell.

Via @auroraeosrose

ian, to random
@ian@phpc.social avatar

The SQL standard got built out originally by, among others, Oracle, Sybase, IBM, and SAP.

Microsoft wasn't on the list because they hadn't bought Sybase yet, and didn't have a database product of their own.

ian, to random
@ian@phpc.social avatar

Data consistency is everything in enterprise - @auroraeosrose

mcdwayne, to random
@mcdwayne@mastodon.social avatar

Create Better Dotfiles
from Andrew Woods
At

ian, to random
@ian@phpc.social avatar

"My name is Elizabeth Smith. I've been programming in PHP since mumble"

mwop, to random
@mwop@phpc.social avatar

Hey, / folks: Raffle drawing for the four small denim elephpants and 4 @zend hats is happening at 1:40pm - that's in 10 minutes! Head over and find out if you won!

stevegrunwell, to random
@stevegrunwell@phpc.social avatar

I'm so grateful for the room full of folks looking to deal with their this morning at , thank you!

My slides are available at https://stevegrunwell.com/slides/technical-debt, and the README for the slides include links to all sorts of resources (including the Adapter Pattern blog post I mentioned: https://stevegrunwell.com/blog/adapter-pattern)

Crell, to random
@Crell@phpc.social avatar

What? Actually use database features developed after 1992?

@scottkeckwarren dropping the controversial truth...

grmpyprogrammer, to random
@grmpyprogrammer@phpc.social avatar

One of the interesting things of being a long-time member of a programming community is that you can do a ton of work (in my case test-writing evangelism), then drop out of it, come back, and be welcomed with open arms (or maybe they are too scared of me to reject me)

Crell, to random
@Crell@phpc.social avatar

Good guidelines to consider when collecting data. Via @e3betht

ian, to random
@ian@phpc.social avatar

"PHP has thrived in anarchy for 25 years" - @mwop

Crell, to random
@Crell@phpc.social avatar

Mundane data has been used for all kinds of nefarious purposes. Via @e3betht

Crell, to random
@Crell@phpc.social avatar

Crash course in ethical theory from @e3betht.

jmichaelward, to random
@jmichaelward@phpc.social avatar

@stevegrunwell giving a shout-out to @derickr about Xdebug in his Technical Debt talk makes me realize I've been convincing people to use it for step debugging for almost a decade.

mbniebergall, to random
@mbniebergall@phpc.social avatar

I've just contributed to PHP Foundation. Consider supporting them too — every little helps! https://opencollective.com/phpfoundation

mcdwayne, to random
@mcdwayne@mastodon.social avatar

"5 things about mental health every developer should know"
Unconference session at from Sarah Savage

Today, I learned there is such a thing as mental first aid
Good resource here: https://buff.ly/2Yjo5VG

Crell, to random
@Crell@phpc.social avatar

Obligatory... Via Mark Niebergall.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • megavids
  • kavyap
  • thenastyranch
  • khanakhh
  • DreamBathrooms
  • InstantRegret
  • magazineikmin
  • Youngstown
  • everett
  • slotface
  • ngwrru68w68
  • GTA5RPClips
  • cubers
  • rosin
  • anitta
  • tacticalgear
  • mdbf
  • vwfavf
  • osvaldo12
  • cisconetworking
  • Durango
  • modclub
  • ethstaker
  • tester
  • normalnudes
  • Leos
  • provamag3
  • JUstTest
  • All magazines