Deathside Posted 19 August 2006 Posted 19 August 2006 I actually do lots of unrelated stuff... but - to stick to just IT:- That much is true I do have a Masters degree in IT - I don't (I don't have a masters in anything) - I am a Microsoft Certified System Engineer (if that helps)?? I do some programming - I write some basic html in notepad (Does that count??) (PowerChordz.Com) I build my own PCs - I audit factories that mass produce PCs The company itself specialises in networking - The primary nature of my employer's business is retail
cisono Posted 19 August 2006 Posted 19 August 2006 Replying to Deathside's post... cisono: I do have a Masters degree in IT DS: I don't (I don't have a masters in anything) - I am a Microsoft Certified System Engineer (if that helps)?? cisono: It doesn't help me, but it certainly will help you! I am a Sun certified java programmer. cisono: I do some programming DS: I write some basic html in notepad (Does that count??) (PowerChordz.Com) cisono: Certainly does. Only real techies use a no-frill (or few frill) editor! cisono: I build my own PCs DS: I audit factories that mass produce PCs cisono: I can see a certain commonality there cisono: The company itself specialises in networking - DS: The primary nature of my employer's business is retail cisono: PCs? Electricals?
lookwhaticando Posted 19 August 2006 Posted 19 August 2006 Replying to Deathside's post... cisono: I do have a Masters degree in IT DS: I don't (I don't have a masters in anything) - I am a Microsoft Certified System Engineer (if that helps)?? cisono: It doesn't help me, but it certainly will help you! I am a Sun certified java programmer. cisono: I do some programming DS: I write some basic html in notepad (Does that count??) (PowerChordz.Com) cisono: Certainly does. Only real techies use a no-frill (or few frill) editor! cisono: I build my own PCs DS: I audit factories that mass produce PCs cisono: I can see a certain commonality there cisono: The company itself specialises in networking - DS: The primary nature of my employer's business is retail cisono: PCs? Electricals? Notepad, PAH! I just imagine the programs I'm creating Does that count? Nah, I just use an online text editor when I'm writing html/php stuff. I even handle a bit of SQL here and there.
cisono Posted 19 August 2006 Posted 19 August 2006 I just imagine the programs I'm creating Does that count? Not sure! Nah, I just use an online text editor when I'm writing html/php stuff. I even handle a bit of SQL here and there. SQL is everywhere. There is no way of avoiding it. It is not evil as long as you don't try to extract info from thousands of usenet groups and save it into an SQL database which you are not an admin of. Not recommended!
lookwhaticando Posted 19 August 2006 Posted 19 August 2006 Not sure! SQL is everywhere. There is no way of avoiding it. It is not evil as long as you don't try to extract info from thousands of usenet groups and save it into an SQL database which you are not an admin of. Not recommended! I do small scale stuff on SQL... databases with perhaps up to 20 tables, nothing huge. I have manipulated SQL databases with 261 or more tables, but only a few of those tables, never an entire database in that case
cisono Posted 19 August 2006 Posted 19 August 2006 I do small scale stuff on SQL... databases with perhaps up to 20 tables, nothing huge. I have manipulated SQL databases with 261 or more tables, but only a few of those tables, never an entire database in that case There were not that many tables, but there were millions of rows in each...
lookwhaticando Posted 19 August 2006 Posted 19 August 2006 There were not that many tables, but there were millions of rows in each... Most of the db's I've worked with are of my own creation - so they're quite compact, for the most part. Most complex table I had created contained about 25 rows of 20 fields... member list with assorted information. Member tables are what I've done most... forum databases, and the largest number of users in a forum I've worked with was 5,800-ish (until I decided to purge those with no posts... friggin' wasters)
cisono Posted 20 August 2006 Posted 20 August 2006 Most of the db's I've worked with are of my own creation - so they're quite compact, for the most part. Most complex table I had created contained about 25 rows of 20 fields... member list with assorted information. Member tables are what I've done most... forum databases, and the largest number of users in a forum I've worked with was 5,800-ish (until I decided to purge those with no posts... friggin' wasters) Hehe Yeah, I designed and created the database twice, but made a mistake second time round, using a primary/foregn key that was just too big (there was a reason for that). This slowed down mySQL a HUGE amoung, far more than anticipated. If I ever decided to redesign it now, there would be a few more tables as well, and more complexity . It was not that straightforward as a design either, as some of the specs I had (from standard protocols) turned out to not match the reality of the server the data came from (and over which I had no control whatsoever)...
lookwhaticando Posted 20 August 2006 Posted 20 August 2006 Hehe Yeah, I designed and created the database twice, but made a mistake second time round, using a primary/foregn key that was just too big (there was a reason for that). This slowed down mySQL a HUGE amoung, far more than anticipated. If I ever decided to redesign it now, there would be a few more tables as well, and more complexity . It was not that straightforward as a design either, as some of the specs I had (from standard protocols) turned out to not match the reality of the server the data came from (and over which I had no control whatsoever)... When it comes to creating SQL db's, I throw caution to the wind and just build it as I go along. I don't design myself a neat db with neat tables and easy fields. I decide what I want, then add it to the database. Needless to say, I've done a fair bit of reworking in my time as I felt the need to drop certain aspects of the table. My finest moment with PHP/SQL is creating an admin panel for a website a friend designed/built for me. I had made all kinds of changes to the website myself. His initial build had few dynamic pages, he added them as he went along. After a while I got in on the act (after a test run on another website we had worked on together). I made a few pages that requested information from the database, and it went from there. But adding a news item to the website, or a new member, for example, was all done via PHPMyAdmin... so I decided to build an admin panel (just incase I ever let anyone else add content to the site... not likely but you never know haha). I can know add/delete/edit almost all the content on the website from the admin panel. It's so cool, and I'm quite proud.
cisono Posted 20 August 2006 Posted 20 August 2006 When it comes to creating SQL db's, I throw caution to the wind and just build it as I go along. I don't design myself a neat db with neat tables and easy fields. I decide what I want, then add it to the database. Needless to say, I've done a fair bit of reworking in my time as I felt the need to drop certain aspects of the table. My finest moment with PHP/SQL is creating an admin panel for a website a friend designed/built for me. I had made all kinds of changes to the website myself. His initial build had few dynamic pages, he added them as he went along. After a while I got in on the act (after a test run on another website we had worked on together). I made a few pages that requested information from the database, and it went from there. But adding a news item to the website, or a new member, for example, was all done via PHPMyAdmin... so I decided to build an admin panel (just incase I ever let anyone else add content to the site... not likely but you never know haha). I can know add/delete/edit almost all the content on the website from the admin panel. It's so cool, and I'm quite proud. You can do that when there is little data and when the data is not very complex (conceptually). I found that I could have designed it better half way through populating it, when one table had over 5 million records and another over 8 million. I guess you did not bother with normalisation etc? (The computer science approach to database design)
lookwhaticando Posted 20 August 2006 Posted 20 August 2006 You can do that when there is little data and when the data is not very complex (conceptually). I found that I could have designed it better half way through populating it, when one table had over 5 million records and another over 8 million. I guess you did not bother with normalisation etc? (The computer science approach to database design) That's all I've got to say on that matter. hehe I was taught Java (well object-oriented programming, using java) in a computer science course... but I struggled. I'm just not a natural programmer type... I make too many tiny mistakes that kill programs.. missing semi-colons and all kinds of crap. That's my only encounter with the computer science discipline as an academic subject. Everything else I've done is self-taught, in a way... I see what someone else has done, and I try to modify it to work in the way I want it to. Only more recently have I actually attempted to code from scratch (not always successfully) But yeah... most programming concepts are beyond me
Recommended Posts
Archived
This topic is now archived and is closed to further replies.