Closed Thread Icon

Topic awaiting preservation: How many of you design database yourself? (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=6401" title="Pages that link to Topic awaiting preservation: How many of you design database yourself? (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: How many of you design database yourself? <span class="small">(Page 1 of 1)</span>\

 
Hiroki
Paranoid (IV) Inmate

From: NZ
Insane since: Dec 2002

posted posted 06-13-2003 05:28

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

Bugimus
Maniac (V) Mad Scientist

From: New California
Insane since: Mar 2000

posted posted 06-13-2003 05:38

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

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 06-13-2003 08:21

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

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 06-13-2003 08:42

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

iconoclast
Paranoid (IV) Inmate

From: SM Megamall
Insane since: May 2003

posted posted 06-13-2003 09:39

what is database?

dont answer it, not interested.

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

DmS
Paranoid (IV) Inmate

From: Sthlm, Sweden
Insane since: Oct 2000

posted posted 06-13-2003 11:08

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 }-

poi
Paranoid (IV) Inmate

From: France
Insane since: Jun 2002

posted posted 06-13-2003 11:28

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 :

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 06-13-2003 13:17

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

Hiroki
Paranoid (IV) Inmate

From: NZ
Insane since: Dec 2002

posted posted 06-13-2003 14:09

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

quisja
Paranoid (IV) Inmate

From: everywhere
Insane since: Jun 2002

posted posted 06-13-2003 14:59

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).]

Petskull
Maniac (V) Mad Scientist

From: 127 Halcyon Road, Marenia, Atlantis
Insane since: Aug 2000

posted posted 06-13-2003 15:43

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

poi
Paranoid (IV) Inmate

From: France
Insane since: Jun 2002

posted posted 06-13-2003 16:52

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

norm
Paranoid (IV) Inmate

From: [s]underwater[/s] under-snow in Juneau
Insane since: Sep 2002

posted posted 06-13-2003 18:02

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....

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 06-13-2003 19:10

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

trib
Paranoid (IV) Inmate

From: Den Haag, Netherlands
Insane since: Sep 2002

posted posted 06-13-2003 19:32

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

mobrul
Bipolar (III) Inmate

From:
Insane since: Aug 2000

posted posted 06-13-2003 20:18

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.

quisja
Paranoid (IV) Inmate

From: everywhere
Insane since: Jun 2002

posted posted 06-13-2003 20:52

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.

Thumper
Paranoid (IV) Inmate

From: Deeetroit, MI. USA
Insane since: Mar 2002

posted posted 06-14-2003 02:14

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...

CPrompt
Maniac (V) Inmate

From: there...no..there.....
Insane since: May 2001

posted posted 06-14-2003 02:26

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~

trib
Paranoid (IV) Inmate

From: Den Haag, Netherlands
Insane since: Sep 2002

posted posted 06-14-2003 10:27
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).]

Lord_Fukutoku
Paranoid (IV) Inmate

From: West Texas
Insane since: Jul 2002

posted posted 06-15-2003 04:40

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.

InI
Paranoid (IV) Mad Scientist

From: Somewhere over the rainbow
Insane since: Mar 2001

posted posted 06-15-2003 18:44

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.

Thumper
Paranoid (IV) Inmate

From: Deeetroit, MI. USA
Insane since: Mar 2002

posted posted 06-15-2003 19:21

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

InI
Paranoid (IV) Mad Scientist

From: Somewhere over the rainbow
Insane since: Mar 2001

posted posted 06-15-2003 20:11

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.

« BackwardsOnwards »

Show Forum Drop Down Menu