| 00:07.58 | hans | from plug: "Digit Rights Management anyone?" I think it's a freudian slip :) |
| 00:08.12 | hans | pretty soon they'll be managing what we have rights to do with our digits (fingers) |
| 00:08.49 | *** join/#utah BZFlag (~timr@proxyle01.ext.ti.com) |
| 00:09.43 | *** mode/#Utah [+o TimRiker] by ChanServ |
| 00:16.07 | hans | sigh. this thing with chuck is just infuriating |
| 00:17.52 | hans | now he's not only set on microsoft (poor soul) but his phd ego has been tapped and there's likely no turning back once that happens unless some higher-ranked phd he respects embarrasses him pretty hard-core |
| 00:36.05 | *** join/#utah synic (~synic@slkcdslgw12PoolC221.slkc.uswest.net) |
| 00:37.15 | brailsmt | phd's don't have egos... |
| 00:37.25 | brailsmt | they have complexes... |
| 00:37.30 | brailsmt | :) |
| 01:14.22 | hans | is auto_increment a mysql-ism? |
| 01:15.18 | brailsmt | yes |
| 01:15.53 | hans | i suppose there's no way to get a unique id in pure sql? |
| 01:16.02 | *** join/#utah Jayce^ (~jayce@65.218.37.161) [NETSPLIT VICTIM] |
| 01:16.02 | *** mode/#Utah [+o Jayce^] by tolkien.freenode.net |
| 01:16.07 | brailsmt | sure there is |
| 01:16.21 | hans | do tell : |
| 01:16.22 | hans | ) |
| 01:16.35 | brailsmt | create a table like Id(table_name, cur_idx) |
| 01:16.58 | brailsmt | then with the tuple in Id "Foo, 1" |
| 01:18.39 | hans | a workaround |
| 01:18.40 | brailsmt | you can do "Insert Id, bar into Baz from Id values (Id.cur_idx, "blah"); |
| 01:19.10 | hans | but a good one |
| 01:19.29 | hans | what about varchar? |
| 01:19.35 | brailsmt | then just increment Id.cur_idx with an update... |
| 01:20.17 | hans | but it's only as good as your handling of the Id table. |
| 01:20.18 | brailsmt | beats me... can you use auto_increment on varchar in sql? |
| 01:20.43 | brailsmt | hans: I have never actually done that, just seen it done... so I am lite in specifics... |
| 01:20.58 | brailsmt | that is pure sql |
| 01:21.01 | hans | well, i wasn't going to use auto_increment on varchar. :) the only db stuff I've done is myqsl and I want this to be compatible across dbs |
| 01:23.01 | brailsmt | were i worked before they used the Id table approach in Oracle and used triggers to auto-update the Id table for each insert into tables... |
| 01:23.34 | hans | that would work well. |
| 01:23.54 | hans | i believe postgres has a similar approach that you can use |
| 01:24.06 | brailsmt | that is fairly standard i think (disclaimer: I don't know much about sql) |
| 01:24.17 | brailsmt | i forget... |
| 01:27.02 | brailsmt | in postgres you can make the field of type 'serial' |
| 01:28.34 | brailsmt | aha |
| 01:28.39 | brailsmt | i found what i was thinking of... |
| 01:29.07 | brailsmt | create sequence table_seq increment 1; |
| 01:30.00 | *** join/#utah Mecworks_ (marc@208.186.182.174) |
| 01:30.15 | hans | yeah, that was it |
| 01:35.41 | brailsmt | you should also use "maxvalue" with create sequence |
| 01:37.26 | brailsmt | but how to get the value from the sequence into the unique field... |
| 01:38.10 | brailsmt | aha |
| 01:38.45 | brailsmt | insert into foo values (nextval(<sequence name>), ...); |
| 01:40.01 | hans | man, writing portable sql is harder than portable c |
| 01:43.39 | brailsmt | project1=# insert into a values (nextval('foo_seq')); |
| 01:43.39 | brailsmt | INSERT 64492 1 |
| 01:43.39 | brailsmt | project1=# insert into a values (nextval('foo_seq')); |
| 01:43.39 | brailsmt | INSERT 64493 1 |
| 01:43.39 | brailsmt | project1=# insert into a values (nextval('foo_seq')); |
| 01:43.41 | brailsmt | INSERT 64494 1 |
| 01:43.44 | brailsmt | project1=# select * from a; |
| 01:43.46 | brailsmt | <PROTECTED> |
| 01:43.49 | brailsmt | ---- |
| 01:43.51 | brailsmt | <PROTECTED> |
| 01:43.54 | brailsmt | <PROTECTED> |
| 01:43.56 | brailsmt | <PROTECTED> |
| 01:43.59 | brailsmt | <PROTECTED> |
| 01:44.02 | brailsmt | (4 rows) |
| 01:44.04 | brailsmt | there ... :) |
| 01:44.07 | brailsmt | sorry for the flood... |
| 01:44.34 | brailsmt | and foo_seq was created via "create sequence foo_seq increment 1 maxvalue 500000;" |
| 01:45.47 | brailsmt | and that is portable |
| 01:46.10 | brailsmt | well, it is as far as i know |
| 01:47.53 | hans | sql makes me sick |
| 01:49.18 | brailsmt | why? |
| 01:49.25 | hans | it's so bad |
| 01:50.23 | hans | it's easy to say that now, of course... sql is old |
| 01:50.50 | brailsmt | i like it, i hate using it in long convoluted academic sql exercises... |
| 01:53.15 | brailsmt | everything i ever used sql for has been simple straightforward queries, then 452 comes along and throws gordian knot sql queries at you... |
| 01:53.18 | hans | some things I dislike: varchar(255) (why should I have to worry about the length of a varchar?), so many important things are left out of the standard making it a bear to port, character sets seem to be an afterthought (could be wrong on that one) |
| 01:53.55 | hans | string quoting/escaping could be much better |
| 01:55.31 | brailsmt | like 75% of the queries they give in 452 would be an order of magnitude easier in code |
| 01:56.08 | hans | it's just an old tool and using it feels like a hack every time I do it. but it's the interface to the powerhouse databases, so what can I do? :) |
| 01:57.16 | brailsmt | use jdbc to get the data and then maniplate it.. |
| 01:57.24 | brailsmt | :) |
| 01:59.13 | hans | what's jdbc? i've never looked at it. isn't it java? only java? |
| 01:59.54 | brailsmt | yeah, Java DataBase Connectivity (i think) |
| 03:08.40 | *** join/#utah TimRiker (~timr@c-67-163-110-34.client.comcast.net) |
| 03:08.58 | *** mode/#Utah [+o TimRiker] by ChanServ |
| 03:51.15 | *** join/#utah TheSeige (~Seige@208.187.113.113) |
| 05:01.08 | *** join/#utah TimRiker (~timr@c-67-163-110-34.client.comcast.net) |
| 05:01.26 | *** mode/#Utah [+o TimRiker] by ChanServ |
| 08:38.20 | *** join/#utah brailsmt (~michael@12-254-250-249.client.attbi.com) |
| 12:51.18 | *** join/#utah hans (~fugalh@byu080710wks.byu.edu) |
| 12:57.17 | hans | synic: I'm ready to continue our vim discussion when you are. :) |
| 14:09.08 | *** join/#utah Mecworks__ (~Marc@novell123456.print.lab.novell.com) |
| 14:11.53 | *** join/#utah Mecworks_ (~Marc@novell123456.print.lab.novell.com) |
| 15:14.03 | *** join/#utah bonez39 (~Bonez@206.71.67.22) |
| 15:15.45 | *** join/#utah neybar (~jalance@dsl233.sisna.com) |
| 15:29.35 | Mecworks_ | quiet moring? |
| 15:31.37 | hans | so far |
| 15:33.43 | levi | Yo. |
| 15:57.50 | hans | where do you set whether the system clock uses UTC? |
| 15:58.28 | levi | Hmm, I don't remember that. |
| 16:07.59 | Bradipo | Just set the hardware clock to UTC and make sure that /etc/localtime points to the proper zone file in /usr/share/zoninfo |
| 16:09.53 | hans | well, actually the hardware clock doesn't use UTC |
| 16:10.03 | hans | is /etc/localtime supposed to be a symlink? |
| 16:12.41 | Bradipo | It can be a symlink. |
| 16:12.46 | Bradipo | I have seen some distros just copy the file. |
| 16:12.48 | Bradipo | I prefer a link. |
| 16:13.00 | Bradipo | ln -s /usr/share/zoneinfo/US/Mountain /etc/localtime |
| 16:13.32 | hans | that's the correct setting if hardware is not set to UTC? |
| 16:14.16 | Bradipo | That's always the correct setting. |
| 16:14.26 | Bradipo | /etc/localtime should always point to your local timezone. |
| 16:15.11 | Bradipo | Some systems may actually set the system time off of the hardware clock---let's hope your's doesn't. :-) |
| 16:15.32 | hans | ok. so how the system clock is set from the hardware clock is distro-specific? |
| 16:15.33 | Bradipo | Or rather, they adjust it... |
| 16:15.46 | Bradipo | Yeah, it can be distro specific. |
| 16:16.19 | Bradipo | Is the date/time wrong on your system right now? |
| 16:16.46 | hans | it was, I ran ntpdate |
| 16:16.55 | hans | /etc/sysconfig/clock (Mandrake) |
| 16:17.07 | hans | UTC=true (changed to false just now) |
| 16:17.16 | hans | we'll see next time I reboot |
| 16:17.26 | Bradipo | Cool. |
| 16:17.32 | Bradipo | Is your hardware clock in UTC? |
| 16:17.39 | hans | no. blasted windows |
| 16:18.00 | Bradipo | Ahh. |
| 16:18.03 | Bradipo | Yeah, that's lame. |
| 16:18.08 | Bradipo | I hate dual booting systems. |
| 16:38.32 | *** join/#utah TimRiker (~timr@proxyle02.ext.ti.com) |
| 16:38.33 | *** mode/#Utah [+o TimRiker] by ChanServ |
| 16:56.15 | Mecworks_ | TimRiker: howdy |
| 16:56.47 | *** join/#utah tensai (~tensai@dsl.dyn.01-86.budget.net) |
| 16:57.26 | Mecworks_ | ohaio gozaimasu tensai san |
| 16:58.41 | tensai | ohayo gozaimasu back at you |
| 16:58.57 | Mecworks_ | domo |
| 17:01.03 | tensai | nihonjin desu ka? soretomo senkyoshi deshita ka? |
| 17:02.19 | Mecworks_ | senkyoshi datta. Demo junen kan gurai nihongo no tour guide datta. |
| 17:02.52 | Mecworks_ | sore tomo, ni kai nihon ni kaette, sundemashita. Kyoto to Tokyo... |
| 17:03.28 | Mecworks_ | anatta? Senkyoshi datta? Nihonjin? |
| 17:04.41 | Jayce^ | e dai rapazes... para de falar aquela lingua :) |
| 17:05.02 | hans | mejor hablen la idioma celestial |
| 17:05.25 | tensai | senkyoshi deshita. 5 nen mae kaette ki mashita. |
| 17:06.28 | Mecworks_ | Jayce^ and hans: hatway anguagelay areya youya ootay ekingspay? 8^) |
| 17:06.52 | Mecworks_ | tensai: cool, what mission? |
| 17:06.59 | Mecworks_ | I was in nagoya |
| 17:07.10 | hans | and I thought you were using babelfish. ;-) |
| 17:07.11 | tensai | okayama |
| 17:07.24 | hans | Mecworks_: espanol. Jayce^ was speaking portuguese |
| 17:07.25 | Jayce^ | hans, a lingua celestial não é o espanhol |
| 17:07.37 | Jayce^ | yup |
| 17:07.47 | tensai | hans: same thing, no? :) |
| 17:08.03 | Mecworks_ | tensai: cool. You been back at all?> |
| 17:08.04 | Jayce^ | I got it direct from the first presidency that portuguese is :) true (fun story) |
| 17:08.05 | hans | close in many ways. I can understand a lot of p'guese |
| 17:08.23 | Jayce^ | and I can undertsand a lot of spanish.. although reading is definately easier that hearing it.. |
| 17:08.33 | Jayce^ | same with italian, and even some french |
| 17:08.40 | hans | i actually think p'guese is prettier than spanish (brazilian p'guese at least) |
| 17:09.08 | tensai | Mecworks_: I wish. too busy with school, etc. Some day... |
| 17:09.09 | Jayce^ | yeah, there is some difference from continental to brasilian.. kinda like english |
| 17:09.40 | Mecworks_ | I like the way they speak spanish in Argentina. It's not as harsh as Mexican spanish... |
| 17:09.49 | Jayce^ | castellano |
| 17:10.07 | hans | my favorite spanish is Ecuador |
| 17:10.19 | Mecworks_ | Of course many other South American countries' spanish is not as harsh sounding as Mexican spanish. |
| 17:10.25 | Jayce^ | hans, where´d you serve? |
| 17:10.33 | hans | connecticut. I heard it all |
| 17:10.35 | Jayce^ | ahh |
| 17:11.30 | Jayce^ | of course, brasilian portuguese has some hefty regional accents.. much like our southern, jersey, and boston accents.. makes for some very different sounding portuguese |
| 17:11.57 | Mecworks_ | tensai: I've traveled there on business onece and lived there twice (for summers) since coming home from the mission. I worked there as a english tutor one of the times I was there. Pretty coo. |
| 17:12.40 | Jayce^ | on the subject of languages.. Mecworks_ just commited one of the worst things american's can do in brasil.. |
| 17:12.59 | Mecworks_ | oops... |
| 17:13.03 | hans | what's that? say you don't like futbol? |
| 17:13.20 | Jayce^ | 'coo', which is the refernce to how most americans say 'cool', and say it all the time, is how you say fsck you, with heavy meaning... |
| 17:13.21 | Mecworks_ | what was that? |
| 17:13.48 | Jayce^ | you dont' know how many american teenagers, automatically add 'cool', even when first learning portuguese... |
| 17:13.51 | Mecworks_ | oh....mistype.... |
| 17:14.03 | Mecworks_ | 8^) |
| 17:14.10 | Jayce^ | just saying cool get's it though.. thought I'd point that out.. |
| 17:14.32 | Mecworks_ | thx....I'll watch my mouth 8^) |
| 17:14.46 | Jayce^ | just if you ever go to brasil |
| 17:25.42 | hans | Jayce^: perl-bash alert on plug. ;-) |
| 17:31.26 | Jayce^ | yeah, I know.. |
| 17:46.17 | Jayce^ | just make some quick notes.. |
| 19:03.25 | brailsmt | \q |
| 19:03.31 | brailsmt | oops... |
| 19:08.51 | Jayce^ | :q |
| 19:17.26 | brailsmt | \q == psql |
| 19:19.15 | Jayce^ | ah |
| 19:29.37 | brailsmt | dangit... i hada job interview tonight, turns out they just want people to work as brokers... if i wanted to be a broker i would have majored in business finance... i declined the interview... |
| 19:31.41 | *** join/#utah levi (~levi@208.177.141.226) |
| 19:31.46 | Jayce^ | what company? |
| 19:38.24 | hans | did you tell them you would broker their noses? |
| 20:08.20 | *** join/#utah tensai (~tensai@dsl.dyn.01-86.budget.net) |
| 20:21.07 | brailsmt | primerica, a citigroup company... I told them I was interested in a job in software, and he told me "We use a computer program for our analysis." I nearly fell out of my chair... |
| 20:21.43 | brailsmt | i politely explained that I was interested in a job *creating* software, not just using it... |
| 20:22.46 | Jayce^ | ok, that person should be shot.. |
| 20:23.29 | Jayce^ | tell him you want to create the analysis software and run the cluster it goes on. |
| 20:29.21 | hans | concision. that's a cool word |
| 22:45.06 | *** join/#utah hans (~fugalh@128.187.242.99) |