|
ynohtna posted:congrats on the arrival of new columns child13...child99 Cognos Analytics by IBM has a CMOBJECT table that hold reports and like sixty CMOBJPROPS# tables that hold various properties. Each table has a different set of columns. No table is named something useful. I had to select a list of all the column names in the database to discover that the "Hidden" flag is in CMOBJPROPS55. No idea why they didn't make a single table and use it as a key->value store.
|
# ? Nov 28, 2018 16:18 |
|
|
# ? Mar 29, 2024 03:39 |
|
that reminds me, the other day i wanted to do some bulk editing of data in a third party app. eventually settled on export xml > edit it > import xml again which worked well except all the object properties were like <property id="{uuid}">value</property> with the uuid<->property name mapping only defined in the xml header so i had to parse&build that in my script. whyyy
|
# ? Nov 28, 2018 16:30 |
|
a customer is really mad that one of our products didn’t warn them of a violation of business constraints that was occurring when they had the device unplugged, turned off, and put on a shelf.
|
# ? Nov 28, 2018 17:04 |
|
i've seen a table with a TEXT column containing a string with comma separated ID's for related records. the application would load the record, deserialize the id's into a list and do a select from the related table where id in(). i guess someone thought having a many-to-many join table with a lot of rows would be slow or something, but come on, at that point you might as well give up and use mongodb.
|
# ? Nov 28, 2018 17:15 |
|
floatman posted:It's amazing that a user of the name "AggressivlyStupid" can identify that it is problematic, yet the "code craftsmanship culture" here apparently is all okay with it. is it too bleak to say the programmer-facing parts of "culture fit" are "lies we tell ourselves" + "stockholm syndrome"
|
# ? Nov 28, 2018 17:28 |
|
CRIP EATIN BREAD posted:a customer is really mad that one of our products didn’t warn them of a violation of business constraints that was occurring when they had the device unplugged, turned off, and put on a shelf. seems like it's your fault for not equipping their device with a secondary power source, a broken power button and sirens
|
# ? Nov 28, 2018 18:01 |
|
Sagacity posted:
i dont have a hosed up pretend pivot table to test it on but if the db doesn't support this i think you can just do code:
|
# ? Nov 28, 2018 18:18 |
what can be happening if a java app on openjdk 8 fails to allocate heap space without maxpermsize argument (that is deprecated in 8)
|
|
# ? Nov 28, 2018 18:45 |
|
For that 12 column join I would just create a view that does the union all into a single column like it should be and then just do all my queries on that view forever. Until someday seven years later that becomes a performance problem and it takes some sucker hours to figure out
|
# ? Nov 28, 2018 18:56 |
|
cinci zoo sniper posted:what can be happening if a java app on openjdk 8 fails to allocate heap space without maxpermsize argument (that is deprecated in 8) Use xmX or whatever, that controls the heap size and is not deprecated E: as for what is happening, its that there is a default limit and you're blowing it
|
# ? Nov 28, 2018 19:05 |
|
CRIP EATIN BREAD posted:unplugged, turned off, and put on a shelf. ha just like my career
|
# ? Nov 28, 2018 19:16 |
gonadic io posted:Use xmX or whatever, that controls the heap size and is not deprecated yeah we use xms for init and xmx for limit for the heap space, whereas maxpermsize limits the permanent generation size. what i am confused with is that this argument was deprecated with java 8 release, yet launching application without it, on java 8, triggers failure. am i missing something dumb, like java 7 app running in java 7 even on java 8 runtime environment?
|
|
# ? Nov 28, 2018 19:29 |
|
CPColin posted:Cognos Analytics by IBM has a CMOBJECT table that hold reports and like sixty CMOBJPROPS# tables that hold various properties. Each table has a different set of columns. No table is named something useful. I had to select a list of all the column names in the database to discover that the "Hidden" flag is in CMOBJPROPS55. No idea why they didn't make a single table and use it as a key->value store. very early in my career i helped support some add-on apps to an ancient ERP system called BPCS. because it was originally an as/400 system the table and column names were all something like 6 characters or fewer and completely inscrutable, so you spent basically all day looking poo poo up in the data dictionary so you could figure out what poo poo like SELECT INFDT, SLG12 FROM DEFB1 WHERE LOGTR4 = @var meant and it scared me away from ERP systems forever
|
# ? Nov 28, 2018 19:33 |
|
for me, pivot and unpivot are like right joins. it'll take me forever to figure out and i'll be damned if i ever write them
|
# ? Nov 28, 2018 19:55 |
|
also why tf doesn't excel come with a sql query feature built in?
|
# ? Nov 28, 2018 19:59 |
|
DELETE CASCADE posted:For that 12 column join I would just create a view that does the union all into a single column like it should be and then just do all my queries on that view forever. Until someday seven years later that becomes a performance problem and it takes some sucker hours to figure out why not make it a view dependent on a view dependent on even more views? a viewchain if you will
|
# ? Nov 28, 2018 20:57 |
|
cinci zoo sniper posted:yeah we use xms for init and xmx for limit for the heap space, whereas maxpermsize limits the permanent generation size. what i am confused with is that this argument was deprecated with java 8 release, yet launching application without it, on java 8, triggers failure. am i missing something dumb, like java 7 app running in java 7 even on java 8 runtime environment? maxpermsize is supposed to be ignored entirely so either the jdk has a bug that's using it or maybe check ur paths to make sure ur not running a different jvm.
|
# ? Nov 28, 2018 21:15 |
|
Boiled Water posted:why not make it a view dependent on a view dependent on even more views? i'll materialize some of the views but not others, for reasons that will be lost to time
|
# ? Nov 28, 2018 21:17 |
Shaggar posted:maxpermsize is supposed to be ignored entirely so either the jdk has a bug that's using it or maybe check ur paths to make sure ur not running a different jvm. ill fish around if this app (its not small) doesnt come with an embedded jvm, cheers
|
|
# ? Nov 28, 2018 21:40 |
|
"it made sense at the time", i'll cry when justice finally finds me and drags me to the unesco tribunal for terrible programmers to answer for my crimes. when the new york times covers it they'll write something about the banality of evil, probably.
|
# ? Nov 28, 2018 22:01 |
|
Shaggar posted:maxpermsize is supposed to be ignored entirely so either the jdk has a bug that's using it or maybe check ur paths to make sure ur not running a different jvm. you look like you know a lot about ignoring maxpermsize
|
# ? Nov 28, 2018 22:23 |
|
Sereri posted:seems like it's your fault for not equipping their device with a secondary power source, a broken power button and sirens the employee who did it explicitly did so because he doesn't like the system optimizing his job (he prefers to do only 1 thing at a time, instead of letting it save the organization money and time). but of course it's our fault.
|
# ? Nov 28, 2018 22:40 |
|
redleader posted:also why tf doesn't excel come with a sql query feature built in? because not even Microsoft is willing to drat that many of us poor fuckers to hell dealing with the consequences
|
# ? Nov 28, 2018 22:42 |
|
actually though doesn't excel use the JET db engine behind it which couldn't even do a vlookup on an unsorted list until like 2010? if it is then its the same as access in that it's kind of like sql but also not really, and it only works if you use named ranges for everything to mimic tables. plus I guess excel is a static sheet that you're effectively inserting into so though taking x columns back from a vlookup instead of just one should be easy, where would you put them? do you move all following columns along and gently caress up every formula or what? edit: it doesn't use jet I imagine that but anyway check out this horror: quote:However, this does not mean that a MS Jet (Red) database cannot match MS SQL Server in storage capacity. A 5 billion record MS Jet (Red) database with compression and encryption turned on requires about 1 terabyte of disk storage space, comprising hundreds of (*.mdb) files, each acting as partial table, and not as a database in itself. ban this sick filth Powerful Two-Hander fucked around with this message at 23:05 on Nov 28, 2018 |
# ? Nov 28, 2018 23:02 |
|
DaTroof posted:you look like you know a lot about ignoring maxpermsize perms are no good and never were good and the 80s should just be forgotten.
|
# ? Nov 28, 2018 23:08 |
|
excel has a query engine that’s a separate addon and it’s called power query my manager loves it, it works with way more than just sql server, and I’ve deliberately avoided learning anything else about it
|
# ? Nov 28, 2018 23:09 |
|
DaTroof posted:you look like you know a lot about ignoring maxpermsize oh I get this now. lol.
|
# ? Nov 28, 2018 23:12 |
|
DaTroof posted:you look like you know a lot about ignoring maxpermsize
|
# ? Nov 28, 2018 23:22 |
|
while we're on the topic, i have a question that has bugged me for a while: what the gently caress is the point of the default behavior of vlookup (i.e. the 'will pick a nearby row somehow and give you that value instead of saying not found if your item isnt found)? does that match any conceivable use case that isn't just insanely sloppy scripting?
|
# ? Nov 29, 2018 02:40 |
|
Corla Plankun posted:while we're on the topic, i have a question that has bugged me for a while: I've used it to get a letter grade (including pluses and minuses) from a total score. Needs suited.
|
# ? Nov 29, 2018 06:39 |
|
jdk 8 calls it metaspace and a blog I read says it’s not limited in size. probably your jvm options are wrong somehow
|
# ? Nov 29, 2018 07:17 |
Kevin Mitnick P.E. posted:jdk 8 calls it metaspace and a blog I read says it’s not limited in size. probably your jvm options are wrong somehow there’s just -xms and -xmx however. w/e i guess
|
|
# ? Nov 29, 2018 07:43 |
|
if you're using an oracle jdk then jvm warnings are trustworthy and you should assume the apparently maxpermsize-related behavior is a red herring. if its a distro build then who fuckin knows. distro maintainers gotta put janky patches or they feel like they aren't necessary
|
# ? Nov 29, 2018 16:48 |
|
Kevin Mitnick P.E. posted:jdk 8 calls it metaspace and a blog I read says it’s not limited in size. probably your jvm options are wrong somehow meatspace
|
# ? Nov 29, 2018 17:56 |
|
https://www.youtube.com/watch?v=ZP7K9SycELA
|
# ? Nov 29, 2018 18:31 |
|
Exciting headlines on hacker news today for the Go community (not to be confused with Go!) * We have a new blog post about Go 2. This version of Go will be much more community driven, so can't wait to see what the Go community can come up with! * The Go community came up with a new fixed precision decimal library called Fixed. It's great and has hard-coded limitations to 7 decimal places and supports numbers up to 99 billion! (Perfect for Belize as the GDP is only about US$1.8b)
|
# ? Nov 29, 2018 18:59 |
|
Finster Dexter posted:* The Go community came up with a new fixed precision decimal library called Fixed. It's great and has hard-coded limitations to 7 decimal places and supports numbers up to 99 billion! (Perfect for Belize as the GDP is only about US$1.8b) More like Broken
|
# ? Nov 29, 2018 19:03 |
|
Finster Dexter posted:Exciting headlines on hacker news today for the Go community (not to be confused with Go!) do you mean scale 7 or 7 significant digits
|
# ? Nov 29, 2018 20:52 |
|
NYSE gave me this as a CSV line using pipe delimiters. Presumably when Microsoft systems collide as no one else is retarded enough to use quadruple quotes and more.quote:"CNF|""CNFinance Holdings Limited American Depositary Shares (""""ADSs"""")"," each representing twenty (20) Ordinary Shares""|8|R|0|0|0|0|0|N||GTSS|62",,,,
|
# ? Nov 29, 2018 21:15 |
|
|
# ? Mar 29, 2024 03:39 |
|
Finster Dexter posted:Exciting headlines on hacker news today for the Go community (not to be confused with Go!) https://twitter.com/daemon404/status/1068195329890295808
|
# ? Nov 29, 2018 22:20 |