Best Programming Language for a Database

KornNut · 01-10-2005, 03:22 PM

I have to create a mock Ebay database. I have four months to complete the assignment. I am allowed to use any programming language that I choose.

I know the following languages: C++, Java, C#.

I was thinking about doing the program in PHP, because I have heard of some books that did entire examples of ebay databases.

+ Does any one have any suggestions on what program I should research and write this ebay-esque database in?

+ Does any one know any good books to buy that may demonstrate an ebay database or a database very much like ebay?

Iron_Cross · 01-10-2005, 07:24 PM

I really, really like C# for databases. I find it MUCH easier than Java. And I've never used C++ for a database, but if it's any easier than C#, I'd shoot myself

KornNut · 01-11-2005, 10:09 AM

The one thing that I do know is that it took some one literally 3 times as long to do the program in C++ than in Java. Probably because Java has alot of it already preformatted while in C++, you have to fool around with sockets.

I absolutely hate doing any network/database programming with C++. I run into so many problems. Whenever I use dynamically allocated strings or arrays with sockets, either not enough data is sent through the socket or junk data is sent through at the end of my data even if I determine what size the message is goign to be. So frustrating!!! And, if i decide to use buffers instead, I would be using more resources than I would need in almost each messgae (since each message would be of the same size).

Iron_Cross · 01-11-2005, 11:45 AM

What type of database are you going to be working with? Trust me, C# makes database applications super freaking easy. Personally, I'm not quite sure how you could NOT choose C# as your language of choice.

KornNut · 01-11-2005, 12:11 PM

I agree that C# is genearlly the best programming language to use.

Howerver, PHP has been referred to me because it is the exact language that yahoo, ebay, and amazon use. PHP is a programming language that works directly with HTML; it is a programming language made for databases.

http://www.devshed.com/c/a/PHP/Websi...PHP-and-MySQL/

However, I have never programmed a database. I honestly don't personally know which is a better programming language for a database: C# or PHP.

... only if I can just skip all of this programming and use D4 or FileMaker...

Iron_Cross · 01-11-2005, 01:03 PM

If you're using MySQL, php is fine. I just didn't say php for two reasons 1. You didn't list it in your first post 2. I wasn't sure what kind of database you were going to use.

If your using a MySQL database, PHP is perfectly fine. It's plenty easy and simple. So it's really up to you. Whichever you feel most comfortable with. Although, I will say this; if this program you're making is going to be based offline (meaning on local machine and not a server/website) then I'd use C#. If it's going to be web-based I'd use php. Unless the server you're using supports ASP.NET, in that case you can use C#.

KornNut · 01-11-2005, 01:59 PM

The database must be made for the client and server to run on seperate PCs.

The Ebay database must do searching, have webpages for each item, one must be able to browse the items, and group items. However the database does not need to have a lot of items 'for auction'.

Any answers to the following questions would be greatly appreciated:

+ I know C#, however I have not done any network/database programming under C#. If I were to choose C#, how long would it take to create a detailed ebay database?

+ How difficult is it to use scripts for C# (if there are any)?

+ I do not know PHP at all, so I would need to research the language before programming. If I were to choose PHP, how long would it take to create the database?

+ Would a fantasy baseball league database be easier to set up than a ebay database?

Any help is deeply appreciated.

Araunah · 01-11-2005, 04:33 PM

You might want to try the new .net framework.
You can use it with 3 different languages syntax, Visual Basic, Java or C#. You can download .net for free at : http://www.microsoft.com/downloads/d...isplaylang=en.

You can also download a free development tools call webmatrix at http://www.asp.net/webmatrix/

KornNut · 01-11-2005, 04:52 PM

Araunah, that seems more like a developer. If I were to use a web or a database developer, I would use D4 or Filemaker.

However, this is not for professional use. I am really only doing this as educationaly purposes on how to program a database.

Iron_Cross · 01-11-2005, 07:04 PM

Ok, if you're going to use mySQL, then choose php (well, you could use C#, but it would be harder because your server has to support asp.net) Now then, if you're going to use MS SQL, then by far choose C# (asp.net). Just make sure you server suppors asp.net.
If you end up using asp.net and ms sql, it should only take you a few days to write the program, it's not hard at all.

Member Login