Topic awaiting preservation: How many of you design database yourself? (Page 1 of 1)

Hi, guys. May I ask you something, please?
Have you ever design any database for commercial purpose before?
Now I am studying database stuff at tech. It is difficult but really exciting, you know.
Just curious to know how many of you actually designing database stuff.
Any comment will be great.
Cya.

Hiroki Kozai

Hiroki, I have done a fair amount of databasse work using Oracle. I'm no expert but I know my way around pretty ok.

. . : slicePuzzle

I've used a lot of database for web applications,
some heavyweights for 'real' applications (think mssql),
and of course, written my very own subset of a sql database for applications that didn't have the need for a full blown sql server.

So yeah,
chances are, you'll use some kind of database for any given project in the real world.

so long,
TP

I do alot of database stuff...almost all the PHP I do these days involves a database in one way or the other...I'm mainly on the SQL bandwagon

what is database?

dont answer it, not interested.

---------------------------
I'll Procrastinate Tomorrow.

I do db-designs if needed, mainly in MySQL.
I'm not great at it but they seem to do the job quite nicely.
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

My job mostly consist in coding database driven extranet, portals... in PHP with PostgreSql and some times with MySql.

I rarely design the whole DB 'coz I'm never aware of all the desired/sold features until 2weeks before their release :

Many moons ago I created my own simple database in Pascal. I've taught the use of Access and Paradox and use MySQL a lot.

Why?

___________________
Emps

FAQs: Emperor

HI, guys. How are you? I am doing bloody database assinment since this morning.
I am stuck with making form. I haven't done any progress since afternoon.
I am exausted. It is 0:00 am in NZ now. I am still in the class room with my friend.
We are having really hard time.
But doing this is very important to me.
So I will do my best.
Many thanks for your replies.
Have a good night.
Cya.

Hiroki Kozai

Wow, Emps, that was like the final project we did when learning Pascal, a database from the ground up. And it was a very pretty thing indeed. Mmmmmmhmmm. I've only done basic Access since though.

[This message has been edited by quisja (edited 06-13-2003).]

How do you 'make a database'?

I'm a big flat-file database system man... I perfer to have it all out there in ASCII...


Code - CGI - links - DHTML - Javascript - Perl - programming - Magic - http://www.twistedport.com
ICQ: 67751342

Petskull: With the project I'm working on which requires lots of caches and stuffs, I tend to become a serialized objects cache system man. To retrieve some important amount of datas, it's 10.000x faster than the DB approach.

Mathieu "POÏ" HENRI

I once cobbled together a flat file setup that used muti-dimensional arrays and a series of switch statements to approximate the the functionality of a real database.

It was a painful experience and I ended up just installing MySQL when I finally figured out that round was really a good shape for a wheel....

quisja: And I got an A for it too

PS: I can't rightly remember - quisja might be more help on this as it was a decade ago and the code is trapped on some enourmous floppy disc somewhere

___________________
Emps

FAQs: Emperor

I use a lot of MySQL right now, and in previous incarnations I have done quite a bit of Oracle design, been an Oracle 6 and 7 DBA, done QA Data management, and back in the mid-80s I wrote a 13-way Btree index handler to make old IBM sequential tape files into ISAMs, so I guess that would also qualify as "making a database" ....


Bug-free software only exisits in two places
A programmer's mind and a salesman's lips

I've never tried to write my own database before. (I'm impressed, Emps!) The sheer geekiness of the idea almost appeals to me. I may have to take up that challenge someday.

I work a lot with mySQL and postgreSQL; a bit with MS SQL Server (ughh) and some Oracle 9i occassionally.

I once made some web-based training for Access. We (the company for which I work) were really pushing Access as a report writer for our software (which runs on an Oracle db). The backend for the training piece was all mySQL. That was funny.
"Access isn't good enough to actually run the training...but, here, you use it!"
I'm sure that was convincing to our customers.

It was basically defining a record which stored the data needed for each item, then an array to hold all the items, and the array went into one flat file. It was a pretty simple affair, but could do search, adding and deleting records and making simple reports. I wouldn't recommend it as anything except a learning excercise.

Typically I wouldn't even give a crap about database design, since I am a graphics person. Letely, however, I have been working freelance with a company that insists on creating administration of content for all of their clients (nice).

In maintaining their standards, I have to assume that every element of my design work would/could possibly be a changeable aspect. So I have accidentally managed to pick up many of the fundamentals of database communication with web applications (primarilty MySQL). What a funny world, sometimes I have just as much fun with this as graphic work...

I have done a lot of Access design back when I did a lot of VB programming. There really is a sort of "art' to designing a good db.
At home I have messed around with MySQL and PHP but I have yet to do anything real useful. I'd like to eventualy write a really cool PHP-MySQL app. For now I'm with Petskull in the flat files. In time.....

There is a great book on database design that helped me greatly. It's call "Database Design for Mere Mortals" very good book

Later,

C:\


~Binary is best~

quote:

---

Typically I wouldn't even give a crap about database design, since I am a graphics person.

---

And yet a PSD file is only a database ... of actions, layers etc. You just don't see Photoshop as a database interface, but look at the structure of the workspace ... tables (layers, paths, channels, etc) ... the table editor (input screen) working on one "record" aat a time ... editable tables of tools, brushes, colors ... etc. etc. Hell ... it even has transaction processing and rollback.



Bug-free software only exisits in two places
A programmer's mind and a salesman's lips

[This message has been edited by trib (edited 06-14-2003).]

I just got started on a book, "MySQL/PHP Database Applications" because of a research project at the university this summer. Only a couple chapters into it, but if you are just starting working with databases (databasi perhaps?) with a web interface, I'd really recommend it. And it's not real heavy reading either.

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

...never thought of it that way trib! I guess you're right!

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.