Perl 6 - the future is here, just unevenly distributed

IRC log for #askriba, 2017-05-07

| Channels | #askriba index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
00:41 ribasushi vanstyn: btw a semi-join-less solution ( there are still joins but not nearly as reified ) to the question in #dbic goes something like this: https://paste.debian.net/plain/931118
00:41 ribasushi it's not terribly expensive either on most engines
00:53 vanstyn oh, interesting.... but in genewral, i assume you agree his design is bad...
00:53 ribasushi it depends - sometimes EAV is what the system calls for
00:54 ribasushi no way to know what he is modelling in real life
00:54 vanstyn well, i just know that I personally made the same mistake in the past and it was always aweful
00:55 ribasushi again - it really depends
00:56 ribasushi with proper indexing the above will perform surprisingly well from mysql up
00:57 vanstyn the other problem with EAV is data types... in my expereince, it rarely solves the problem you hvae... except in some limited config table scenarios
01:01 vanstyn I'd actually consider making some EAV solutions if there was a clean/nice way to solve the data type problem.... for a column to have one type on one row and a different type on another.... of course that could be done in higher layers than the db (and if I had put the time into that, maybe i'd have a different opinion)
01:02 vanstyn for every 1 scenario where EAV makes sense, 10 novices use it when it doesn't and ruin their lives
01:02 ribasushi that last part is very true
01:03 ribasushi but still - it's a tool
01:03 ribasushi ( and yes, data-type on the raw rdbms level is obnoxious, but this is what you have a DBIC layer on top for )
01:04 vanstyn right. thats something RapidApp could do. (but it doesn't right now, so my position is "why would anyone ever want to do that?!" ) :D
01:06 vanstyn I actually was one of those novices that ruined my life pursuing an EAV solution.... I even implemewnted a pivit thing which would display it as if they were real columns .... and... it worked (sort of)
10:58 vanstyn_ joined #askriba
17:11 ribasushi joined #askriba

| Channels | #askriba index | Today | | Search | Google Search | Plain-Text | summary