Previous Entry Share Next Entry
Relational Magic
twitch sigil
saxifrage00
one catalogue has many cards

one collection has many cards

one collection has many decks

one deck has many cards

Note to self: Dig out relational database design textbook. I'm sure I'm missing something in this picture.

  • 1

Kindling in expensive bindings! SQL is a four-letter word!

Note to self: Dig out relational database design textbook.

Considering that your girlfriend spent four years coding relational database engine infrastructure, there's certainly no lack of those to be had between the two of us, I'm sure ;-) I've got Date, Chamberlin...

Re: Kindling in expensive bindings! SQL is a four-letter word!

Indeed, there seems to be no dearth of reference material -- now I just need to recall how to apply it all.

Tangentially, I find it funny that you can't stand OOP, and yet you are completely comfortable with relational DBs. In my own mind they're almost one and the same.

Relational databases are going to heyall! ;-)

In *my* mind they're completely separate things.

However, I'm *not* completely comfortable with relational DBs: I think they're tools of the Devil, or some other such strong language denoting eeeeeeevil.

I'm not a database programmer: I'm a systems programmer, and the system I was working on happened to be the engine of a large DBMS. It was all the process model stuff; all I did was pass big chunks of data around at a low enough level that I didn't care if it was SQL or results or a late-night pizza order or whatever. One SQL statement was pretty much the same as the next to me -- my code didn't parse them or process them, so any apps I wrote for testcases tended to consist of variations on the theme "SELECT * FROM MYTABLE" :-)

Re: Relational databases are going to heyall! ;-)

Well, then... In that case, your text books might be too scary and low-level for my purposes. The conceptual level at which I need to work with the database is the same level as when working with objects and properties in OOP, which is why I equate them.

i.e. a collection object contains many card objects, and a card object consists of a list of properties... A relational database is just a convenient way of structuring objects such that desired sets can be easily extracted.

Re: Relational databases are going to heyall! ;-)

What is your goal in this? Pure interest? Work?

Re: Relational databases are going to heyall! ;-)

He wishes to reproduce a linux version of the wheel. The lot of most linux users.

Re: Relational databases are going to heyall! ;-)

*sticks tongue out at _locke*

Re: Relational databases are going to heyall! ;-)

Some people just don't know what a tongue is for.

Re: Relational databases are going to heyall! ;-)

Win32.MagicDB is a Pinto. I want to make a Batmobile. ;-)

Re: Relational databases are going to heyall! ;-)

I think you might have to develop bronze working first. ;)

Re: Relational databases are going to heyall! ;-)

Yes, I am having some trouble re-inventing SQL...

  • 1
?

Log in

No account? Create an account