aphenine: Teresa and Claire (angels, anime, claymore)aphenine ([personal profile] aphenine) wrote in [site community profile] dw_dev_training,
@ 2009-07-29 12:43 pm UTC
  • Previous Entry
  • Add to Memories
  • Tell someone about this!
  • Next Entry
Entry tags:introduction, sql, wiki
Hello everybody!

I got a dreamhack account a few days ago and I'm trying to get my head around the Dreamwidth code base, in the hopes that I can contribute something. I just thought I'd introduce myself. I was also going to ask a question, but someone lovely and unexpectedly answered it on LJ. *grin*

I've never coded in Perl before, so it's a bit of a learning curve for me. However, I have web coded in PHP before and I've used MySQL before and I have also used *Nix environments before, so I'm not starting totally from scratch.

I think the dominant reason I signed up for a dreamhack account was that I kept looking at DW and thinking "if it was simple, I could change that". In the end, my curiosity got the better of me and I just had to find out if it really was simple or not. Since then, I've been far too amused sitting in the MySQL console pulling up a test comment and post directly from the database. SELECT * FROM logtext2; has not lost its power to make me squee for the last few minutes. But, a question. No, two questions. Why log for posts? And why talk for comments?

So far the only thing I've really contributed is an entry in the Dreamhack wiki giving an overview of some of the database tables. It's found here. It was in the wanted list and I thought, hey, what the hell.


(11 comments) - (Post a new comment)
(Flat) (Top-level comments only)

yvi: Dreamsheep in Germany's national colors (Dreamsheep - Germany)


[personal profile] yvi
2009-07-29 01:20 pm UTC (link)
Welcome!

So far the only thing I've really contributed is an entry in the Dreamhack wiki giving an overview of some of the database tables. It's found here

Oh, that's really cool. I have very limited mySQL experience - I can basically select a database, look at what columns it has and see what's in there. Sometimes I even manage a few WHERE commands. Which is why this took about three tries longer than it should have :) Any documentation of the databases is great!

So, I can't help you, I just wanted to welcome you :)

(Reply to this)  (Thread


aphenine: Teresa and Claire (angels, anime, claymore)


[personal profile] aphenine
2009-07-29 02:10 pm UTC (link)
Thank you for the welcome.

I remember I started by knowing very little about databases. My first thought was, basically, aha, a glorified struct in which to store my persistent data for my web application, with a complicated and annoying interface to get the data I want. My poor Computer Science friend facepalmed at my complete over-simplification of his entire database module. In retrospect, I have immense sympathy for him...

And yey, bug squishing.

(Reply to this)  (Thread from start)  (Parent)  (Thread


yvi: Kaylee half-smiling, looking very pretty (Firefly - Kaylee)


[personal profile] yvi
2009-07-31 07:50 am UTC (link)
You know, now I am tempted to go through the databases a bit more. It would be neat to have all of them on the wiki in some way. And some of the functions for Entry and User objects as well.

(Reply to this)  (Thread from start)  (Parent


denise: Image: Me, facing away from camera, on top of the Castel Sant'Angelo in Rome (me, standing outside a broken phone booth)


[staff profile] denise
2009-07-29 01:34 pm UTC (link)
Welcome!

I'm not really sure what the names signify! The only suggestion I have is that it was 1999 and Brad didn't have conventional vocabulary already established, so he made his own. I'm guessing 'talk' because commenting is like talking, and 'log' because journal entries are like an event log? ('blog' being short for 'web log' and all...)

(The answer to 'why' around here is usually 'Brad'. *G*)

(Reply to this)  (Thread


aphenine: Teresa and Claire (angels, anime, claymore)


[personal profile] aphenine
2009-07-29 02:11 pm UTC (link)
Thank you.

That makes a lot of sense.

(Reply to this)  (Thread from start)  (Parent)  (Thread


azurelunatic: cameo-like portrait of <user name="azurelunatic"> in short blue hair.  (_support, cameo)


[personal profile] azurelunatic
2009-07-30 04:55 am UTC (link)
Just from hanging around IRC and the comms, I am left with the nagging wish to make a parody of Clue, including Brad, in his dorm room, with BML.

(Reply to this)  (Thread from start)  (Parent)  (Thread


aphenine: Teresa and Claire (angels, anime, claymore)


[personal profile] aphenine
2009-07-30 10:12 pm UTC (link)
*grin*

(Reply to this)  (Thread from start)  (Parent


janinedog: (support)


[personal profile] janinedog
2009-07-29 03:03 pm UTC (link)
Yeah, I'm pretty sure this is the reason. The first version of LJ was a script called "bradlog", after all. I don't know when the terms "entries" (or "posts") and "comments" came about, but I'm pretty sure the database structure was in place before the terms did.

(Reply to this)  (Thread from start)  (Parent)  (Thread


pne: A picture of a plush toy, halfway between a duck and a platypus, with a green body and a yellow bill and feet. (Martin)


[personal profile] pne
2009-07-30 07:35 am UTC (link)
The first version of LJ was a script called "bradlog", after all.

That was my first thought, too.

Compare also the names of the BML files for posting and reading comments: talkpost.bml & talkread.bml (again with the "talk" theme).

(Reply to this)  (Thread from start)  (Parent


aphenine: Teresa and Claire (angels, anime, claymore)


[personal profile] aphenine
2009-07-30 10:17 pm UTC (link)
Ooh, bradlog. It certainly all fits.

(Reply to this)  (Thread from start)  (Parent


badgerbag: (action grrl)


[personal profile] badgerbag
2009-07-29 05:28 pm UTC (link)
Yay! I'm hoping to dig into the code a bit this weekend and I'll read your wiki page!

(Reply to this



(11 comments) - (Post a new comment)
(Flat) (Top-level comments only)