| 00:15.32 | troubled | works for me |
| 00:16.52 | troubled | although i believe there are speed ups with fixed row sizes when doing any sort of selects since row offsets become fixed math, but i think the space wasted for char(92) would be too great |
| 00:20.28 | dondelelcaro | yeah, it probably only matters when you're dealing with really small rows |
| 00:21.27 | troubled | combine fixed rows with the idea earlier of the hostname lookup table and it would help probably |
| 00:21.58 | dondelelcaro | the problem with hostname lookups is that peoples hostnames change all the time |
| 00:22.32 | dondelelcaro | though it probably would be useful to keep track of which factoids were made by people who were identified at the time and the nick used |
| 00:23.12 | troubled | you should take a look at my schema with ircdetective script. i have 3 tables, 1 for nick, ident and hostname. then a 4th table that joins all 3 to get a unique id. then all my tables just reference that userid |
| 00:23.57 | troubled | mind you to keep it simpler, you could always just break apart all the fields into 3 to avoid the extra join with the 4th table |
| 00:24.35 | troubled | with identified nicks though, does oftc have capab msg? |
| 00:25.25 | troubled | i mean, having an identified field (bool) does limit its use to networks with services as well |
| 00:27.16 | troubled | i suppose before we can redesign the db, questions need to be answered on what the bot cant do that you wish it would, first |
| 00:27.54 | troubled | as well as how much compatibility you dont mind breaking with the changes in respect to network and db netrality |
| 00:29.17 | troubled | lookup tables for example are nice if you keep the referencial integrity in the db or handle missing (deleted) fields, but the glue can also be put in the code for db's like sqlite that may not support everything for example |
| 00:30.09 | *** join/#debian-bots apt-br (n=apt-br@189.20.255.233) |
| 00:30.27 | *** join/#debian-bots dpkg-br (n=dpkg-br@189.20.255.233) |
| 00:31.02 | troubled | i assume dpkg-br is yours? |
| 04:43.42 | *** join/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 07:11.05 | *** join/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 07:15.50 | *** part/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 07:26.03 | *** join/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 07:31.14 | *** part/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 09:55.09 | *** join/#debian-bots streuner (n=streuner@p54A5C9B4.dip.t-dialin.net) |
| 10:56.37 | *** part/#debian-bots streuner (n=streuner@p54A5C9B4.dip.t-dialin.net) |
| 11:05.22 | *** join/#debian-bots dpkg (n=dpkg@unaffiliated/dpkg) |
| 11:29.32 | *** join/#debian-bots streuner (n=streuner@p54A5E03C.dip.t-dialin.net) |
| 11:29.58 | *** part/#debian-bots streuner (n=streuner@p54A5E03C.dip.t-dialin.net) |
| 19:44.32 | *** join/#debian-bots dpkg (n=dpkg@unaffiliated/dpkg) |
| 20:01.41 | *** join/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 20:01.43 | *** part/#debian-bots markybob (i=markybob@unaffiliated/markybob) |
| 23:38.48 | simonrvn | neat |
| 23:39.38 | simonrvn | btw, i had only 3 files tp update since my last svn up. had to relocate my local copy though... i hate doing that, but i figured it out finally. just had to do: |
| 23:40.07 | simonrvn | svn switch --relocate oldURLWithoutSubDirs newURLWithoutSubdirs |
| 23:40.31 | simonrvn | tried with the sub-dirs, but kept erroring out |