| macyaway | getting back to business .. are you still there? | 00:03 |
|---|---|---|
| troal01 | Back again | 00:15 |
| troal01 | Assignment due tomorrow? :) | 00:16 |
| macyaway | exam | 00:16 |
| macyaway | we forgot to do this | 00:16 |
| macyaway | Varje film visas på flera biografer samtidigt | 00:16 |
| troal01 | Okay and each biograf can show many films right? | 00:17 |
| troal01 | Then it would be a classic many-to-many relationship | 00:17 |
| troal01 | And in that case you'd have to use an associative table | 00:17 |
| macyaway | so i am not doing anything | 00:18 |
| macyaway | Just a statement in the erd | 00:19 |
| macyaway | eh? | 00:19 |
| troal01 | Well if that's what your schema looks like no :) create table film (id int, namn varchar(255)); and then a create table film_biograf_assoc (film_id, biograf_id); | 00:19 |
| troal01 | It's easier to represent associative tables with diagrams but it's kinda hard to draw them on IRC | 00:19 |
| macyaway | Well noo .. you see i got ägare av tidning som betygsätter en film av olika kategorier med aktörer i som är kvinna och man en spelar älskare den annan mördare och dom har födelseår också | 00:23 |
| macyaway | Sedan säger man att dom film spelas i de biograf och att den biograf har så många salar och det befinner sig i de orten | 00:24 |
| macyaway | Så min er diagram ser ut på följande sätt ... har en media ... tabell med romb i som inehåller ägare och tidning som betygsätter sedan | 00:25 |
| macyaway | och då blir det betygsättning på film kategory betyg, som har flera aktörer och spelas upp på flera biograf | 00:25 |
| macyaway | typ | 00:25 |
| macyaway | Eller? | 00:26 |
| troal01 | Weeeeeeeeeeeeeell that's a mouthful! I can't solve your whole problem for you but you've gotta first list all relevant data you want to store | 00:27 |
| troal01 | Then sort them into tables | 00:27 |
| troal01 | Or just put them all in one table and normalize them :) | 00:27 |
| troal01 | Whichever you find easier | 00:27 |
| macyaway | But i did | 00:29 |
| macyaway | I even described how i did it | 00:29 |
| macyaway | Didnt you follow? | 00:29 |
| macyaway | Was i so uncoherent? | 00:29 |
| macyaway | Dammit! | 00:29 |
| macyaway | Ok .. tell me secrets :D | 00:29 |
| troal01 | Haha well what I could gather was that you think you had normalized your tables but not certain on how to enforce certain requirements | 00:30 |
| troal01 | I helped you with unique() on namn and ort | 00:31 |
| troal01 | So what's your question now? :) | 00:31 |
| macyaway | I would like some secrets | 00:33 |
| macyaway | You see for exam? | 00:33 |
| macyaway | oh ... these locking transactions | 00:33 |
| macyaway | why doesnt everybody use the tidsoptimistisk metod? | 00:34 |
| troal01 | Watch the South Park episode "Eek a Penis" :D | 00:34 |
| macyaway | no | 00:34 |
| macyaway | are you being mean now? | 00:34 |
| troal01 | No just trying to be funny heh | 00:35 |
| troal01 | If you'd seen the episode you'd know what I mean | 00:35 |
| macyaway | wöll .... i might have seen it | 00:35 |
| macyaway | Man im soo hungry :( | 00:35 |
| macyaway | but eak is a kitten | 00:36 |
| macyaway | a blue one if i remember right | 00:36 |
| troal01 | Anyway, I'm not an expert on locking theory, you might want to hit the books for that one | 00:36 |
| troal01 | But as far as teh test goes, remember normalization techniques and general SQL and you should be fine | 00:36 |
| macyaway | aye | 00:36 |
| macyaway | well ... i know about write ahead log, change log transaction log is more or less journaling and you use the acid way | 00:37 |
| macyaway | and as it is atomic meaning all or nothing, you got to do the comit at the end ... | 00:38 |
| macyaway | if not doing commit, you lock the session, and there comes the consistency where you got to respect the integrities and when they all pass the test it is good ... it got to be consistent at all times | 00:39 |
| macyaway | and the isolated ... here you do the locking really ... cuz one transaction can be done at a time separatley from each other | 00:39 |
| macyaway | and than you got them durability that should hold even when the disk has crashed | 00:40 |
| macyaway | Through ice and stone age | 00:40 |
| macyaway | eh? | 00:40 |
| troal01 | To me all that sounds good | 00:40 |
| macyaway | Very nice | 00:40 |
| macyaway | I agree | 00:41 |
| macyaway | Do you know what data mirroring is? | 00:41 |
| troal01 | Depends on what you mean by that :) | 00:43 |
| troal01 | BTW the joke with the South Park episode, it's the one where Cartman teaches the underprivileged kids how to cheat | 00:43 |
| macyaway | uuu, i should watch that! | 00:44 |
| macyaway | Data mirroring is when you got synkron and asynkron | 00:45 |
| troal01 | Very funny episode | 00:45 |
| troal01 | Sorry can't help you there :) | 00:45 |
| macyaway | You see there is distribuerad db and centraliserad one | 00:46 |
| macyaway | Well i actually know this thing :P | 00:46 |
| macyaway | I could teach you ;) | 00:46 |
| macyaway | Hum | 00:47 |
| macyaway | Not attractive enough? | 00:47 |
| troal01 | Hehe! I'm sure you could teach me a thing or two :) | 00:50 |
| macyaway | Hmm ... that sounded kinky! | 00:51 |
| macyaway | Ojj .... it's prolly just me :/ | 00:51 |
| troal01 | ANd you're probably pretty tired being up this late | 00:52 |
| macyaway | Im starting to get awake | 00:53 |
| troal01 | Heh | 00:53 |
| macyaway | you fooled me a wee bit with the : create table biograf ( namn varchar(255), ort varchar(255), unique(namn, ort)); | 00:54 |
| troal01 | Hmm? | 00:54 |
| macyaway | Wouldnt have it been easier to just say place them cinema and city both as primry keys? | 00:54 |
| macyaway | Would have saved me a whole lot of thinking | 00:54 |
| macyaway | :P | 00:54 |
| troal01 | That depends, you could do that but for every associative table you'd have to pull those two over | 00:55 |
| macyaway | huh? | 00:55 |
| troal01 | The associative table between movie and cinema would now have three fields instead of two | 00:56 |
| macyaway | Well no cuz i got a fk from betygsattning ... which is film | 00:56 |
| troal01 | I'm talking about the place where each film can be shown in many cinemas and each cinema can show many films | 00:57 |
| troal01 | many-to-many = associative table | 00:57 |
| troal01 | PK from each table | 00:57 |
| macyaway | So cinema cant be unique or primary key cuz it is not unique | 00:59 |
| troal01 | ciname name is not unique no, but name and ort together has to be so yes it could be the primary key | 01:00 |
| macyaway | But i dont have no name, i only have cinema city salar and film | 01:02 |
| macyaway | In the biograf entity .. table | 01:02 |
| macyaway | You went away? | 01:05 |
| macyaway | Very nice, i ought to bugger off and catch some of that sleep they spread around a long time ago | 01:06 |
| macyaway | night night, thanks for all :) | 01:06 |
| troal01 | No problem and good luck on the test! | 01:07 |
| macyaway | :) | 01:07 |
| macyaway | I will bring my hammer | 01:07 |
| troal01 | Hehe | 01:10 |
| *** macyaway has quit IRC | 01:12 | |
| *** stephenb has joined #ingres | 01:55 | |
| *** toumi01 has quit IRC | 02:53 | |
| *** mull has quit IRC | 03:01 | |
| *** rossand has quit IRC | 04:50 | |
| *** Alex|off is now known as Alex| | 06:09 | |
| *** Gerhard has joined #ingres | 06:12 | |
| *** Alex| is now known as Alex|off | 06:38 | |
| *** withdefault has joined #ingres | 06:57 | |
| *** ChanServ sets mode: +o withdefault | 06:58 | |
| *** Alex|off is now known as Alex| | 07:06 | |
| *** grantc_offline is now known as grantc | 07:34 | |
| Alex| | I'm sure there are some java experts around... I need to call a simple url from within java... just need to open the url and don't even need the content that comes back | 07:44 |
| pboro | well.. what do you need then? | 07:44 |
| Alex| | is this a job for curl or is there something more simplistic? | 07:45 |
| Alex| | java.url.call("http://...") <- that's what I want :) | 07:45 |
| pboro | what does mean "call a simple url", just make a request to that url and that's it? | 07:45 |
| Alex| | yes, just the request... I need to send data via get to a remote server | 07:46 |
| pboro | http://hc.apache.org/httpclient-3.x/ | 07:46 |
| pboro | add that lib to your project, it gives tools to make http requests easily | 07:46 |
| pboro | if you don't want to add a lib, then you will need to write a http client yourself | 07:46 |
| Alex| | no, adding a lib is ok. I was just not sure what's the one to use for this | 07:47 |
| pboro | ok, Apache Commons contains a bunch of very useful and good quality libraries for many uses, I recommend to check it :) http://commons.apache.org/ is the home page for it | 07:49 |
| pboro | I think calling an external binary should only be used as a last resort... | 07:49 |
| Alex| | hm, looks like there is something built-in already | 07:50 |
| Alex| | http://java.sun.com/j2se/1.4.2/docs/api/java/net/HttpURLConnection.html | 07:50 |
| pboro | oh yeah, forgot that... it's not as useful as HttpClient but can also be used for simple cases | 07:50 |
| Alex| | that should be enough. I only open the connection and check if it comes back as 202 | 07:51 |
| Alex| | or 200 even... | 07:51 |
| pboro | ok, sorry for not remembering that :) | 08:02 |
| *** Gerhard has quit IRC | 08:56 | |
| *** jmbp has joined #ingres | 09:02 | |
| *** jmbp is now known as jmbp_ | 09:08 | |
| *** jmbp_ is now known as jmbp | 09:10 | |
| *** Alex| is now known as Alex|off | 09:26 | |
| *** jmbp has quit IRC | 11:45 | |
| *** troal01 has left #ingres | 11:47 | |
| *** troal01 has joined #ingres | 11:50 | |
| *** rossand has joined #ingres | 11:55 | |
| *** ChanServ sets mode: +o rossand | 11:55 | |
| pboro | ahh... got a raise! | 12:07 |
| troal01 | Grats! :) | 12:10 |
| *** jmbp has joined #ingres | 12:24 | |
| grantc | pboro, +1 :) | 12:45 |
| grantc | afternoon mr jmbp | 12:45 |
| pboro | does Ingres Co. give any discount to educational organizations, like universities? | 13:25 |
| grantc | pboro, not sure, there used to be something in the uk called CHEST, i don't know if it still exists or if ingres is part of it | 13:27 |
| pboro | ok, I'll ask sales | 13:27 |
| satanmalin | hi grantc | 13:27 |
| satanmalin | hi pboro | 13:27 |
| satanmalin | hi everyone | 13:27 |
| grantc | hullo satanmalin | 13:27 |
| satanmalin | grantc if i put a page index.php and a page index.html in the same directory what page will be loaded as an index ? | 13:28 |
| pboro | depends on the http server configuration | 13:29 |
| grantc | it depends on what DirectoryIndex is set to in the apache config | 13:29 |
| satanmalin | because its for the application demo | 13:29 |
| satanmalin | im doing an index.html | 13:29 |
| satanmalin | to explain how to connect | 13:30 |
| pboro | you should probably only do either one | 13:30 |
| pboro | since it's no point in having two index "pages"... | 13:30 |
| satanmalin | but i was wondering ho w to do LOL | 13:30 |
| pboro | if you only need a page with some text, then do index.html :) | 13:30 |
| pboro | if you need to put PHP code (to be executed) on the page, you will certainly need .php | 13:31 |
| satanmalin | yep but indeed theproblem i have or i create LOL is that we have the demo done by emma who has still an index.php and i want to code so;e pages | 13:31 |
| satanmalin | before this index | 13:31 |
| satanmalin | or maybe must i do a sub directories maybe | 13:32 |
| pboro | rename index.php to demo.php and then write index.html with a link to demo.php? | 13:32 |
| pboro | if it is not possible to rename index.php to demo.php, then create a subdirectory demo and put it there or something :) | 13:33 |
| satanmalin | or what about putting the demo in a sub directory ? | 13:33 |
| pboro | that should work too, yeah | 13:33 |
| pboro | I don't get tho' why not just rename the file :) | 13:33 |
| satanmalin | because i think index.php is a base of the demo | 13:34 |
| satanmalin | grant isn it ? | 13:34 |
| pboro | oh, so there is even more php files? | 13:34 |
| grantc | indeed | 13:34 |
| pboro | ok :) didn't have enough data to compute the problem! | 13:34 |
| grantc | the demo got synced out to svn yesterday - let me check | 13:34 |
| satanmalin | lol oki | 13:35 |
| satanmalin | no prob pboro | 13:35 |
| satanmalin | and thanks for your help | 13:35 |
| grantc | http://svn.ingres.com/browse/listing.php?repname=ingres&path=%2Fmain%2Fsrc%2Ffront%2Fdemo%2Fphp%2FIngresDemoApp_php%2F#path_main_src_front_demo_php_IngresDemoApp_php_ | 13:36 |
| satanmalin | is it for me or for pboro ? | 13:36 |
| grantc | anyone who wants to see the code... | 13:36 |
| satanmalin | oki LOL | 13:36 |
| satanmalin | the code i have of course | 13:36 |
| pboro | nice, mixed PHP and HTML :/ | 13:36 |
| grantc | README.html and the help files | 13:37 |
| satanmalin | but i think the easiest way is with subdirectories | 13:37 |
| grantc | the rest is all code | 13:37 |
| satanmalin | i have never asked but if apache is set to have as root directory www | 13:38 |
| grantc | ? | 13:39 |
| satanmalin | wil it work if i place the fie in www\demo | 13:39 |
| pboro | hmm... is that demo vulnerable to sql injection? | 13:39 |
| satanmalin | will it work if I place the file in www\demo | 13:39 |
| satanmalin | ? | 13:39 |
| grantc | if you reference http://machine/demo/index.html | 13:39 |
| grantc | pboro, patches welcome | 13:39 |
| satanmalin | http://machine/demo/index.php | 13:40 |
| grantc | if www is your documentroot directory that should work | 13:40 |
| satanmalin | and the html file will be in http://machine/www/index.html | 13:40 |
| satanmalin | oki thanks | 13:40 |
| satanmalin | so il continue | 13:40 |
| satanmalin | thanks grant | 13:41 |
| satanmalin | and thank pbroro | 13:41 |
| satanmalin | pbroro | 13:41 |
| satanmalin | pboro | 13:41 |
| satanmalin | LOL sorry | 13:41 |
| pboro | by a quick look it seems to be vulnerable, I hope you're not going to put it on the open net | 13:41 |
| grantc | there are no plans for Ingres to put this code up as a running application | 13:42 |
| pboro | although since Ingres doesn't allow batch queries, the problem is mitigated :) | 13:42 |
| grantc | however I will have to fix it for best practises | 13:42 |
| grantc | :) | 13:42 |
| pboro | if(eregi("(select|insert|delete|update)", $value)) $invalidValues .= "Lastname is invalid<br/>"; | 13:43 |
| pboro | it does have some checks, but they are rather failure :) | 13:43 |
| grantc | i'll add it to my "list" of stuff to do | 13:44 |
| *** mull has joined #ingres | 13:46 | |
| *** troal01 has quit IRC | 13:53 | |
| *** troal01 has joined #ingres | 13:57 | |
| troal01 | Hmm my panel crashed... Must be because I hacked it the other day :D | 13:58 |
| *** toumi01 has joined #ingres | 13:58 | |
| *** troal01 has quit IRC | 14:06 | |
| *** troal01 has joined #ingres | 14:06 | |
| *** troal01 has joined #ingres | 14:07 | |
| *** stephenb has quit IRC | 14:11 | |
| *** DarylM has joined #ingres | 14:23 | |
| *** stephenb has joined #ingres | 14:54 | |
| *** toumi01 has quit IRC | 15:14 | |
| *** toumi01 has joined #ingres | 15:22 | |
| *** toumi01 has quit IRC | 15:27 | |
| *** satanmalin has quit IRC | 15:31 | |
| *** satanmalin has joined #ingres | 15:32 | |
| *** toumi01 has joined #ingres | 15:32 | |
| satanmalin | just to have a translation | 15:37 |
| satanmalin | as follows | 15:37 |
| satanmalin | is as follows is english ? | 15:38 |
| grantc | it depends on the context | 15:38 |
| satanmalin | is "as follows" correct english | 15:38 |
| grantc | it is english but it may not be grammatically correct | 15:39 |
| satanmalin | irst of all, you have to change the source to defined source as follows | 15:39 |
| satanmalin | ? | 15:39 |
| grantc | kind of | 15:39 |
| satanmalin | good or not ? | 15:39 |
| grantc | the last two words sure, the earlier stuff not so sure | 15:40 |
| grantc | on thing you are repeating source | 15:40 |
| grantc | you have to change the defined source as follows | 15:41 |
| satanmalin | indees its irst of all, you have to change the source to "defined source" | 15:41 |
| grantc | can you explain what this text relates to in the demo app? | 15:42 |
| satanmalin | or if you prefer irst of all, you have to tick "defined source" | 15:42 |
| satanmalin | and i have a print screen | 15:42 |
| grantc | of what? | 15:42 |
| grantc | ah i see.. | 15:42 |
| grantc | under the connection page... | 15:42 |
| satanmalin | yep | 15:42 |
| grantc | select "Defined Source" | 15:43 |
| grantc | since it is radio button not a check/tick box | 15:43 |
| satanmalin | oki | 15:43 |
| satanmalin | thanls grant sorry to have to ask translation | 15:44 |
| satanmalin | :( | 15:44 |
| satanmalin | i promise i try to do my best in english :'( | 15:44 |
| grantc | no problem - this stuff comes with practise even for native english speakers | 15:44 |
| satanmalin | LOl thanks to not tell the truth | 15:52 |
| satanmalin | indeed tell that my english is bad | 15:52 |
| *** troal01 has quit IRC | 15:55 | |
| satanmalin | LOL | 15:55 |
| satanmalin | it is as follows or as floowed ? | 15:56 |
| satanmalin | folllowed | 15:56 |
| satanmalin | dam*** it LOL followed | 15:56 |
| satanmalin | LOL | 15:56 |
| satanmalin | finally | 15:56 |
| grantc | as follows | 15:56 |
| satanmalin | oki thaks | 15:57 |
| satanmalin | thanls | 15:57 |
| satanmalin | oki | 15:57 |
| satanmalin | one day ill manage LOL | 15:57 |
| *** troal01 has joined #ingres | 16:00 | |
| *** troal01 has joined #ingres | 16:01 | |
| satanmalin | another question is it to change sth by or for ? | 16:03 |
| satanmalin | Then, in the "Server" section, change the Instance name by | 16:03 |
| grantc | by if you wish to indicate an action that will need to happen | 16:04 |
| satanmalin | ok thanks | 16:05 |
| satanmalin | english is quiet difficult with all these preposition | 16:05 |
| satanmalin | LOL | 16:05 |
| grantc | yup | 16:07 |
| *** troal01 has quit IRC | 16:42 | |
| satanmalin | sorry again | 16:50 |
| satanmalin | another question | 16:50 |
| satanmalin | how do you call the loggin of you pc ? | 16:50 |
| grantc | ? | 16:50 |
| satanmalin | for exemple they ask me to choose a user on XP | 16:50 |
| satanmalin | how to explainit in english | 16:50 |
| DarylM | Who are "they" | 16:51 |
| satanmalin | Now, in the "Credentials" section type your PC loggin : | 16:51 |
| satanmalin | they the system | 16:51 |
| satanmalin | they = $crosoft | 16:51 |
| satanmalin | i have to explain that poeplle who use the demo application have to type their User ID = there loggin of their pc | 16:52 |
| satanmalin | the loggin of there pc | 16:52 |
| grantc | I would say "log in to your PC using your assigned account" | 16:52 |
| satanmalin | euh | 16:54 |
| satanmalin | indeed they have to type their Pc account in the demno base | 16:55 |
| satanmalin | thats what im trying to explain | 16:55 |
| grantc | log in to the application using your user name and password | 16:55 |
| SlimeyPete | your Windows username and password | 16:55 |
| grantc | sure | 16:56 |
| satanmalin | im too complicated LOL | 16:56 |
| satanmalin | thans pete | 16:56 |
| satanmalin | thanks pete | 16:57 |
| satanmalin | type your windows username in the | 16:58 |
| satanmalin | form | 16:58 |
| satanmalin | Now, in the "Credentials" section, type your windows username in the User ID form: | 16:59 |
| satanmalin | is it correct ? | 16:59 |
| grantc | replace User ID form with User ID field | 16:59 |
| satanmalin | oki | 17:00 |
| satanmalin | tx | 17:00 |
| *** troal01 has joined #ingres | 17:05 | |
| satanmalin | may i put a button to sum up all the infor;ation a button sum up or is it a word more apropriate | 17:36 |
| satanmalin | ? | 17:36 |
| satanmalin | summary ? | 17:37 |
| satanmalin | is summary correct ? | 17:38 |
| grantc | a button to sum up information? what does that mean? | 17:39 |
| satanmalin | indeed i have made 3 pages | 17:40 |
| satanmalin | and i want to put a print screen to sum up the information | 17:40 |
| satanmalin | in one window | 17:40 |
| satanmalin | if you promise to not laugh i send you what i have done LOL | 17:41 |
| grantc | sure - mail me and I will take a look tomorrow | 17:41 |
| *** troal01 has quit IRC | 17:44 | |
| *** troal01 has joined #ingres | 18:07 | |
| satanmalin | it is sent grant | 18:17 |
| *** troal01 has quit IRC | 18:22 | |
| *** troal01 has joined #ingres | 18:24 | |
| *** thiagomz_ has quit IRC | 19:15 | |
| *** thiagomz has joined #ingres | 19:15 | |
| *** jmbp has quit IRC | 19:37 | |
| *** withdefault has quit IRC | 20:13 | |
| *** toumi01 has quit IRC | 21:40 | |
| *** DarylM has quit IRC | 22:17 | |
| *** mull has quit IRC | 23:02 | |
| *** grantc is now known as grantc_offline | 23:19 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!