Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: How to structure applications using a RDBMS

by toma (Vicar)
on Jul 19, 2002 at 07:58 UTC ( #183162=note: print w/replies, xml ) Need Help??

in reply to How to structure applications using a RDBMS

One way to reduce the number of SQL functions is to model the database schema in the database.

This approach uses tables to model the database table names, column names, datatypes, relationships, and the ordinality of the relationships.

This approach allows many queries to be automatically generated. Instead of using a lot of little wrapper functions, AUTOLOAD a function that performs a query on the schema, generates SQL code, and runs the query.

I haven't tried DbFramework but it looks like it does at least some of this and possibly much more.

There is an article about this approach, although it describes a Java implementation of the idea.

I used this approach on a database that has about 500 fully normalized tables. I use a GUI that is generated on the fly from the database metadata. There is also a database schema browser that is driven from the metadata. I would use this approach in the design of databases that have more than about 50 or 100 tables.

It should work perfectly the first time! - toma

  • Comment on Re: How to structure applications using a RDBMS

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://183162]
[stevieb]: I don't know what you mean. I write the code in C/C++ that accesses the ICs per the datasheet, wrap it for Perl, then use them. My code ensures that the functions/methods from Perl do the right thing for the chips/sensors etc
[stevieb]: At least that's what I'm working on right now. I've also been updating my automated test software Test::BrewBuild so it handles this work properly. It's not really easy meshing high level languages with low-level hardware :)
[stevieb]: this link is probably better for an overview of my test software
[stevieb]: the top-level Raspberry Pi distribution, that sucks in all sub modules. All of this software have imminent updated releases coming

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2017-06-25 23:15 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (572 votes). Check out past polls.