Database and Delphi..

P

Project X

Expert Member
Joined
May 16, 2006
Messages
1,615
Reaction score
1
I need help creating a Delphi program that will use a database to either...

1) Help lan party host to keep everything organized from the drinks sold,who pain,who won etc.

Or

2) A program to help admin keep track of all the people on his server,who paid,who used up all their bandwidth etc.

or
Elections for the class rep or something..

Now i need you guys to tell me which one will be the best (easiest) and ill also need to know where and how to start then from there ill do it myself and ask for help when im stuck;)

Thanks in advance!!!!
 
Are you in matric? :P

I reckon a tutor program might be easier, then you just have about three tables (users,lessons,questions and answers), then for the lessons you just display the database data. For QandA you display the question, and check that the answer the user entered is the same as the one stored in the DB. and then you can just use the user part of the DB to track highscores (QandA section) as well as number of questions answered, percentages etc)

(thats what I did) with Delphi and my Database for school. :P
 
Rule of thumb.

For each on screen input field requiring database updates, as well as retrieval from a database to show values on screen, you will need one hour of coding for each "side" of the transaction.
So, if you have two fields, Real Name and User Name (for example), that can be updated and displayed, that is 4 hours of coding.

It can be less for large apps with simple fields and experienced coders, and it can be longer for inexperienced people or small apps (small apps have a higher percentage of overhead to coding) - but in my years of doing this, that works fine.
Call it Moederloos's two-step Albrecht Function Point theory... :D

Use that to yard stick the different options you have.
 
So, if you have two fields, Real Name and User Name (for example), that can be updated and displayed, that is 4 hours of coding.
Click to expand...

Would that only apply to Delphi? I program primarily in Java and C++ and those times seem extremely high, even with error checking, etc. I mean, I shudder to think how long the programming exams would take for students to complete if that is the case :sick:
 
RavenServers said:
Would that only apply to Delphi? I program primarily in Java and C++ and those times seem extremely high, even with error checking, etc. I mean, I shudder to think how long the programming exams would take for students to complete if that is the case :sick:
Click to expand...

Its only valid for accounting purposes, The Invoice in other words.:)
 
...and why Delphi? While delphi is cool and all, i think .NET has surpassed Delphi by far now. Also taking into consideration that .NET was somewhat built on top of a Delphi Background and the fact that Borland literally stopped improving Delphi while Microsoft went from .NET 1 to .NET 3 faster than you can upgrade your apps, i'd say it's obvious where one should place your bets in terms of Database/Windows based apps.

You can literally in VB/C# drag-and-drop create your database app as mentioned.
 
Last edited:
.NET is lightyears ahead of Delphi. Heck, even TurboPascal has passed it :D
BTW isn't this thread in the wrong place?
 
froot said:
.NET is lightyears ahead of Delphi. Heck, even TurboPascal has passed it :D
BTW isn't this thread in the wrong place?
Click to expand...

Me trying to get used to .NET and SQL server 2008. Have a small project looming. Dang.
 
Well at school you only have a choice between Delphi and Java. Maybe thats why he is using Delphi?
 
RavenServers said:
Would that only apply to Delphi? I program primarily in Java and C++ and those times seem extremely high, even with error checking, etc. I mean, I shudder to think how long the programming exams would take for students to complete if that is the case :sick:
Click to expand...

Time it sometime.
5 mins to get the control on the form, name it and align it - minimum.
5 mins to set up database field & constraints.
5 mins to do DB code to SELECT, INSERT, UPDATE
Those figures can be even longer with different departments - SQL, Coding, Design, User Requirements, and so on

Brings you to 15 min already.
And that excludes all the modeling, indexing, stress tests, QC, documentation, user changes, fiddling and general bumph that goes with it.
An hour is about right.
 
Yes im in matric,i didn't have a choice really we only do Delphi..
Hawker that is a very good idea and I might just consider it thanks.
Will you be able to help me when i get stuck?

Timgual Im going to use access im not really familiar with any other database..:(
 
Project X said:
Yes im in matric,i didn't have a choice really we only do Delphi..
Hawker that is a very good idea and I might just consider it thanks.
Will you be able to help me when i get stuck?

Timgual Im going to use access im not really familiar with any other database..:(
Click to expand...

If you are using Delphi I would HIGHLY recommend looking at Firebird - they are both Interbase/Borland-based. As such, there are specific Delphi components especially for Firebird which makes development a lot easier. However, if you don't feel comfortable with (or feel you could quickly learn) Firebird, then go ahead - its not too much more effort to use other DBMS with ODBC/etc.
 
diabolus said:
...and why Delphi? While delphi is cool and all, i think .NET has surpassed Delphi by far now. Also taking into consideration that .NET was somewhat built on top of a Delphi Background and the fact that Borland literally stopped improving Delphi while Microsoft went from .NET 1 to .NET 3 faster than you can upgrade your apps, i'd say it's obvious where one should place your bets in terms of Database/Windows based apps.

You can literally in VB/C# drag-and-drop create your database app as mentioned.
Click to expand...

While you're right in principle, your terms are mixed. :p It's C# that was built on a Delphi background (by Anders Heilsberg). And Delphi does .NET!

.NET was built from the experience of Java runtime.
 
Eish...I remember my matric project.

Basically decided to start working on the project the last couple of days :(
only got an hours sleep in every night!! I was f***** to say the least!

So if I can give you some advice...Make sure you get it finished long before the deadline!!
 
Project X said:
Yes im in matric,i didn't have a choice really we only do Delphi..
Hawker that is a very good idea and I might just consider it thanks.
Will you be able to help me when i get stuck?

Timgual Im going to use access im not really familiar with any other database..:(
Click to expand...

Yea I should be able to help you with if you get stuck :P Good luck, :cool:
 
I remember my matrick project.... Java... was so damn awesome. I actually re-did my project about 4 times (after the original working model) before I gave in the final program.
 
Griever said:
Eish...I remember my matric project.

Basically decided to start working on the project the last couple of days :(
only got an hours sleep in every night!! I was f***** to say the least!

So if I can give you some advice...Make sure you get it finished long before the deadline!!
Click to expand...

Yea, thats what I did, I worked on it for 2 weeks during my holiday, then when I got to school I could just hand it in! Don't leave it to the last minute, things have nasty habit of not working (silly mistakes etc), so you need all the time you can get.
 
SecretCode said:
While you're right in principle, your terms are mixed. It's C# that was built on a Delphi background (by Anders Heilsberg). And Delphi does .NET!

.NET was built from the experience of Java runtime.
Click to expand...

Well what i really meant was the IDE [Visual Studio .NET] and the way you have the whole DataAdapter/DataGrid components thing which you literally drag-and-drop "code" ...that was part of the Delphi IDE before Microsoft picked up on it.

As for the actual "code" , can't comment on that, i'm fluent in too many to care. Whatever works without reinventing some new wheel, that's what i use.
 
hawker said:
Are you in matric? :P

I reckon a tutor program might be easier, then you just have about three tables (users,lessons,questions and answers), then for the lessons you just display the database data. For QandA you display the question, and check that the answer the user entered is the same as the one stored in the DB. and then you can just use the user part of the DB to track highscores (QandA section) as well as number of questions answered, percentages etc)

(thats what I did) with Delphi and my Database for school. :P
Click to expand...
By table do you mean something like panel or richedit or do you mean three forms?
Would i get penalized for actually coping the lesson database from an actual tutorial CD or something?
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X