*** mull__ has quit IRC | 00:29 | |
*** toumi01 has left #ingres | 02:34 | |
*** rossand has joined #ingres | 03:45 | |
*** ChanServ sets mode: +o rossand | 03:45 | |
*** rossand has quit IRC | 05:05 | |
*** flyer has joined #ingres | 06:42 | |
*** grantc is now known as grantc_offline | 06:42 | |
*** flyer_ has quit IRC | 06:44 | |
*** grantc_offline is now known as grantc | 06:58 | |
*** notdefault is now known as withdefault | 07:09 | |
*** pleemans has joined #ingres | 08:13 | |
*** MagnusG| has joined #ingres | 08:33 | |
grantc | does anyone know of a way to automatically connect to a specified database if non is provided to a command. For example - if i issue the command "isql" it goes to a predefined db? | 10:26 |
---|---|---|
pboro | make it an alias? | 10:27 |
grantc | i was looking for something more generic | 10:28 |
pboro | oh, something that's provided by Ingres itself? | 10:28 |
grantc | specifically this is for PHP i.e. openapi | 10:28 |
grantc | yup | 10:28 |
pboro | ah :) | 10:28 |
grantc | there is an ini setting sql_safe_mode | 10:28 |
pboro | Hi MagnusG|, haven't seen you for a long time | 10:28 |
grantc | whilst there is no docs for that setting the code says it should connect to the default database... | 10:30 |
grantc | in the case of MySQL it connects to the localhost server | 10:30 |
pboro | without a selected database? or some default database (which is... what?)? | 10:30 |
grantc | with mysql you can either go to a database or something higher level that lets you select the database | 10:31 |
pboro | yup | 10:31 |
grantc | like a db command prompt | 10:31 |
pboro | yeah, in mysql util you can just start it by "mysql" and then type "use dbname" to choose the db | 10:32 |
grantc | indeed - since we/Ingres does not have that facility I need to work out how to implement this "feature" (it's been in the code for 8+years and never worked afaict) or remove it... | 10:34 |
grantc | i like plan b | 10:34 |
pboro | implement it internal to the driver? ;) don't connect before the user calls ingres_select_db etc.? what a kludge would that be tho'... | 10:34 |
grantc | ingres_select_db is another problem i have to resolve.. :) | 10:35 |
pboro | I remember you talking about it :) | 10:35 |
grantc | but this is just dealing with sql_safe_mode... | 10:35 |
grantc | another (unrealated) Q - has anyone here used AmazonS3 ? | 10:46 |
withdefault | grantc, kind of | 10:49 |
grantc | via the appliance i guess? | 10:49 |
withdefault | yes | 10:50 |
grantc | i am looking a an off-site backup solution, several of which feature S3 as their backend | 10:51 |
pboro | sounds interesting | 10:52 |
grantc | i use dropbox for work with their free 2GB account - 50GB from them is $9.99/m or $99/yr | 10:53 |
grantc | or JungleDisk which is $2/month+ $.18/GB | 10:53 |
grantc | dropbox is good for automatically syncing - for example i edit the php ingres extension on linux save the changes and those files get replicated to each PC which has the client installed and is linked to my account. | 10:54 |
grantc | saves me having to futz about with samba/rsync ... | 10:55 |
pboro | don't they charge for data transfer too? | 10:55 |
grantc | dropbox - no for the 2GB account its completely free | 10:55 |
grantc | for now | 10:55 |
pboro | ah, ok | 10:56 |
grantc | looking at it for 50GB DB is cheaper since the equivalent in JD is $11 | 10:56 |
grantc | not sure I want to commit to a year... | 10:56 |
MagnusG| | Hi pboro, No it's a long time since I was connected here. Been busy with User group and other things. | 11:24 |
*** Gerhard has joined #ingres | 12:50 | |
*** rossand has joined #ingres | 12:57 | |
*** ChanServ sets mode: +o rossand | 12:57 | |
grantc | pboro, that valgrind php link you sent has been really useful | 13:00 |
grantc | USE_ZEND_ALLOC=0 has shown a "few"TM problems with the driver. | 13:01 |
grantc | shown up rather... | 13:01 |
pboro | oh, cool :) | 13:02 |
grantc | a few too many but that is another issue... | 13:02 |
pboro | :D | 13:03 |
pboro | doh, I wish there was a maintainer for Ingres Hibernate Dialect | 13:03 |
grantc | i believe we maintain it... | 13:04 |
pboro | it does work, but it's not really up to date | 13:04 |
grantc | ah | 13:04 |
pboro | the latest version is for r3 :) i.e. the ca version of 2006... | 13:04 |
grantc | is it just missing stuff for 9.2/9.3? | 13:05 |
pboro | mostly, I have not yet dug deeper | 13:05 |
grantc | withdefault, do you use it for jasper? | 13:06 |
grantc | via spring etc.. | 13:06 |
withdefault | yes but there are issues | 13:11 |
grantc | such as? | 13:11 |
withdefault | it doesn't honour the date_alias setting when creating schemas | 13:12 |
grantc | openapi problem? | 13:13 |
pboro | I guess it's a type handling problem... I guess Hibernate has no ways to handle such alias types? | 13:14 |
withdefault | there are also various problems highlighted with some of the certifications which have custom dialect changes which becomes a huge maintenance issue. | 13:15 |
withdefault | I've been discussing with some of the developers how this can be handled and it requires that there are multiple versions of the dialect for various versions of Ingres | 13:16 |
grantc | could we publish the different dialects to maven? | 13:17 |
pboro | oh, that's sad :/ I wonder if JDBC driver is able to know the version of Ingres so that it could still automatically choose correct dialect | 13:17 |
pboro | i.e. you could just get the all dialects and Hibernate choses the correct one based some information from the driver / dbms | 13:18 |
withdefault | there is a mechanism for the dialect to query the jdbc metadata about the version of Ingres but that requires a running Ingres instance and the schema creation doesn't have to | 13:18 |
grantc | pboro, what about installations that use ingres_date vs ansidate | 13:18 |
pboro | grantc, don't know about that | 13:19 |
pboro | withdefault, ahh, yes... you're right | 13:19 |
grantc | from what withdefault is saying I guess even that could be an issue | 13:19 |
pboro | grantc, seems so | 13:19 |
grantc | troal01, are you about¿ | 13:20 |
troal01 | Is that a question? I don't know how to read upside down question marks :D | 13:24 |
pboro | :D | 13:24 |
grantc | am doing stretching exercises and my little pinky went a bit too far.. | 13:24 |
grantc | i might have a patch for your segv... | 13:24 |
troal01 | Hehehe, never seen a Spanish keyboard myself :) | 13:24 |
troal01 | Ohhhhhh yay | 13:24 |
grantc | http://ingres.pastebin.com/m78705e5a - the patch is for something else but i fixed a bunch of memory issues i came across, tks to pboro | 13:26 |
troal01 | pboro: THANKS! | 13:26 |
grantc | checkout head-revs then apply the patch | 13:26 |
troal01 | Will do | 13:26 |
troal01 | Heh have to install CVS | 13:28 |
troal01 | I have SVN and GIT, not CVS | 13:28 |
grantc | :) | 13:28 |
troal01 | Grr pastebin cuts out the @@ in the patch | 13:34 |
grantc | are you signed in to im? | 13:35 |
troal01 | It's okay regex FTW, but thanks anyway :D | 13:37 |
troal01 | :%/s\(^ -\d*,\)/@@\1/ | 13:38 |
troal01 | Go vim | 13:38 |
troal01 | :p | 13:38 |
* troal01 waits for flames from emacs users | 13:38 | |
pboro | :D | 13:38 |
pboro | Vi should be enough for everyone ;) | 13:38 |
* troal01 agrees with pboro | 13:43 | |
pboro | it was a pretty astonishing moment when I first time executed vi | 13:44 |
pboro | like... "ftw, how do I get out" :D | 13:44 |
troal01 | LOL! | 13:44 |
troal01 | I had teh same meomeny | 13:44 |
troal01 | moment even | 13:45 |
troal01 | esc esc esc esc | 13:45 |
troal01 | ctrl c ctrl c ctrl c | 13:45 |
troal01 | god dammit | 13:45 |
pboro | hehe :) | 13:45 |
troal01 | I had used pico/nano before that, ctrl q ctrl q ctrl q | 13:45 |
pboro | yeah, me too | 13:45 |
troal01 | Once you get used to vi's commands though, mmm nice | 13:46 |
troal01 | In your face notepad! | 13:46 |
pboro | I will never get used to Solaris' sh | 13:47 |
pboro | it's still the default and it's horrible :D | 13:47 |
troal01 | I have little experience with Solaris, used it in school once and that's about it | 13:47 |
troal01 | We had to use the zeus web server | 13:47 |
pboro | and all the other Solaris tools too... like df, ls etc... GNU versions are superior in usability and features | 13:48 |
pboro | it's like comparing Ingres to PostgreSQL! | 13:48 |
troal01 | Hehe! Sun is in a bit of disarray right now, IBM pulled their offer | 13:55 |
troal01 | Monday it was I think | 13:55 |
pboro | Yup, I guess HP and Cisco are the other possible candicates to buy Sun | 13:56 |
pboro | although it is unknown why IBM really cut the offer, what kind of monsters hide beneath the sun of Sun... | 13:56 |
grantc | interesting op-ed in the register - http://www.theregister.co.uk/2009/04/08/sun_bonuses_ibm/ | 13:58 |
troal01 | LOL @ pboro, yeah no kidding, what evils are yet to be uncovered! | 14:03 |
pboro | grantc, good one, thanks | 14:04 |
grantc | you never know the truth in these things and whether "interested" parties are spiking the romour mill. the same thing happened with Ingres | 14:08 |
grantc | in our case G+H or people connected with passed on a supposed rumour to a journalist (the questionable one who outed PJ from groklaw) who printed it as fact... | 14:10 |
pboro | ouch | 14:10 |
grantc | just like hunters make noise to scare game :) | 14:11 |
grantc | i cannot remember if the rumour was based on an off the cuff remark by swainson, the CA CEO, or was fabricated which then prompted the remark. | 14:14 |
*** toumi01 has joined #ingres | 14:29 | |
*** Gerhard has quit IRC | 15:11 | |
*** MagnusG| has quit IRC | 15:18 | |
*** DarylM has joined #ingres | 15:20 | |
troal01 | DarylM: I can use pentaho if I don't try to create a repository | 15:29 |
troal01 | Use spoon to write some transformation stuff, then run it | 15:29 |
troal01 | It works beautifully, quite a neat tool | 15:29 |
DarylM | Interesting. Now that you describe it that way, I think perhaps I ignored their built in repository also. Sigh. Doing too many things at once ..... ;) | 15:30 |
*** mull_ has joined #ingres | 15:31 | |
troal01 | No problem at all, now I need to learn how to build transformation files by hand :D | 15:31 |
troal01 | You're not 1337 if you don't do shit by hand | 15:31 |
DarylM | lol | 15:31 |
DarylM | I "cut my teeth" throwing toggle switches on a PDP-8. Doing things "by hand" is second nature. :D | 15:32 |
grantc | must resist... | 15:33 |
* DarylM chuckles to himself | 15:33 | |
* troal01 is in awe of DarylM's geekiness, hoping he can achieve such a feat one day | 15:34 | |
grantc | troal01, any luck with that patch? | 15:53 |
troal01 | grantc: haven't gotten to it yet, I'm multitasking heh... I'll definitely try it before the end of the day | 15:56 |
grantc | ok - i am OOTO tomorrow/friday for easter | 15:56 |
troal01 | Alright, how long wil lyou be on today? | 15:57 |
grantc | the next hour :) | 15:58 |
grantc | i have some technical support duties to perform :( | 15:58 |
troal01 | Okay I'll shuffle some things around, trying your patch next :) | 15:58 |
grantc | there's no hurry for my part... i was just wondering | 15:59 |
troal01 | I'm kind of excited for it | 15:59 |
grantc | what ever floats your boat :) | 15:59 |
troal01 | Hehe yeah I know, I'm uber weird | 15:59 |
*** DerMeister has joined #ingres | 16:20 | |
*** pleemans has quit IRC | 16:24 | |
troal01 | grantc: I'm getting this coredump: http://ingres.pastebin.com/me425f76 | 16:33 |
grantc | hmm | 16:35 |
grantc | oh well, something for me to look at next week | 16:35 |
grantc | thanks for trying | 16:35 |
troal01 | Thank you for looking into it :) | 16:36 |
grantc | to be honest i did not - i saw the same segv trace when i was working on another problem. I no longer see it, i guess it was wishful thinking | 16:38 |
grantc | at least the stack is new... that code relates to the ingres_unbuffered_query() change i put in | 16:38 |
grantc | looking at the code i am not sure why it's there... | 16:38 |
troal01 | When I get a sec I might take a look at the code see if I can get any insights | 16:39 |
grantc | that would be good | 16:39 |
troal01 | grantc: result_ptr is a bad ptr, it's not NULL (0x38 in my machine) but will segfault if dereferencd | 16:46 |
grantc | somewhere it is being corrupted | 16:48 |
troal01 | Yup, hate trackign those down | 16:49 |
grantc | have a good weekend all... | 17:10 |
* grantc slopes off | 17:10 | |
*** grantc is now known as grantc_offline | 17:11 | |
* troal01 wonders if Pentaho's counter is an i4 or i8 | 17:19 | |
troal01 | AT 373million rows now, only like 1.8b rows more and I'll know! :P | 17:27 |
pboro | :D | 17:36 |
troal01 | 446 million | 17:53 |
troal01 | This is gonna take hours | 17:53 |
troal01 | Around 18.5h | 17:54 |
troal01 | For one table, I've got two :P | 17:54 |
troal01 | Although second table is marginally smaller, like 2.5b rows | 17:56 |
pboro | such a small table, yeah... | 17:56 |
troal01 | This is stock data, quotes and trades from the NYSE, ~200 stocks for four months | 17:58 |
troal01 | Imagine how much data all stocks for a year would be | 17:58 |
*** pleemans has joined #ingres | 17:58 | |
pboro | hehe :) yeah | 17:58 |
pboro | here in finland on bus company records all gps coordinates for their busses, 24/7 | 17:58 |
troal01 | Wow | 17:58 |
pboro | one bus company | 17:58 |
pboro | they do that a year behind... pretty scary :D | 17:59 |
pboro | backwards even | 17:59 |
troal01 | Do they run Ingres? :D | 17:59 |
pboro | yup | 17:59 |
troal01 | Cool! | 17:59 |
pboro | heard this on IUA meeting | 17:59 |
pboro | time to go shopping :) -> | 18:00 |
troal01 | Have fun! | 18:00 |
*** withdefault has quit IRC | 20:12 | |
*** Alex|off is now known as Alex| | 20:34 | |
*** rossand1 has joined #ingres | 20:55 | |
*** rossand has quit IRC | 21:12 | |
*** Alex| is now known as Alex|off | 21:41 | |
*** pleemans has quit IRC | 21:55 | |
*** DerMeister has quit IRC | 22:30 | |
*** rossand1 has quit IRC | 22:57 | |
*** DarylM has quit IRC | 23:34 | |
*** mull_ has quit IRC | 23:52 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!