Database Problem - Page 2

belask · #16 (**permalink**) 09-20-10, 20:53

Quote:

Originally Posted by mike_bike_kite

You don't need SQL to do what you state but wouldn't your system be better if it could hold details on:

The author of a given poem
The different styles of poem
The different periods when the poetry was produced
Links to similar poems or poets
Users of the system
Feedback on poems from users

... in other tables.

Temptation is getting better of me

Yeah i have decided, i will stick with SQL. I already have coded a test poem site with it. It's working fine except for a few problems regarding Unicode characters and line breaks in poems. I will raise these problems in another thread.

Teddy · #17 (**permalink**) 09-21-10, 16:03

In that case, I highly suggest reading up on basic relational concepts. Rudy, one of our forum goers, has a good write up here:

Fundamentals of Relational Database Design -- r937.com

belask · #18 (**permalink**) 02-08-11, 21:40

Quote:

Originally Posted by Teddy

In that case, I highly suggest reading up on basic relational concepts. Rudy, one of our forum goers, has a good write up here:

Fundamentals of Relational Database Design -- r937.com

Thanks Teddy, i have comeback here after a long time because now i think i will be needing relational tables very soon. Let me check the link you gave.
btw during this time i have gained some command in using sql, php & mysql. so the problem, because of which i started this thread, has been solved. Thank you guys.

healdem · #19 (**permalink**) 02-09-11, 03:21

Use a realtional database
I think you possibly misunbderstand the separation between the storage / manipualtion of the data and the presentation of the data. there are some tools thast can blur the dividing line such as MS Access and Filemaker which allow you to write a front end to view data which is stored elsewhere anbd pure databse engines which 'just' store the data, ranging from MySQL, MS SQL server, DB2 and so on. there are some other similiar to Access/JET storage mechanisms such as SQL Lite. ig you use a server storage mechanms then you need a corresponding front end to view the data. yes all the db's come with a command line tool or GUI tool or both which allow you to view the data in virtually any form you want. heck you can either extract the data from the db using XML or write a query that generates the XML tags anbd view the resulting text in a browser.

Personally I wouldn't use a non realtionl db to store 'stuff' unless it had special needs (eg an embedded db, on non related data, and I dont' come accross a great deal of that.

who ever suggested a flat file was I suspect not being serious.

belask · #20 (**permalink**) 02-09-11, 18:53

Quote:

Originally Posted by healdem

Use a realtional database
I think you possibly misunbderstand the separation between the storage / manipualtion of the data and the presentation of the data. there are some tools thast can blur the dividing line such as MS Access and Filemaker which allow you to write a front end to view data which is stored elsewhere anbd pure databse engines which 'just' store the data, ranging from MySQL, MS SQL server, DB2 and so on. there are some other similiar to Access/JET storage mechanisms such as SQL Lite. ig you use a server storage mechanms then you need a corresponding front end to view the data. yes all the db's come with a command line tool or GUI tool or both which allow you to view the data in virtually any form you want. heck you can either extract the data from the db using XML or write a query that generates the XML tags anbd view the resulting text in a browser.

Personally I wouldn't use a non realtionl db to store 'stuff' unless it had special needs (eg an embedded db, on non related data, and I dont' come accross a great deal of that.

who ever suggested a flat file was I suspect not being serious.

thanks but this issue has been solved, i have been using mysql for quite some time. Couldn't find a way to mark this thread as solved