Reply
Best tools to build database?
Old 08-11-2009, 01:50 PM Best tools to build database?
Junior Talker

Posts: 3
Trades: 0
Hi all,

I'd like to build a database of images (artwork) and articles (about works of art) that can be searched by: name of artist, title of work, date work was created, author of article, title of article, title of artwork discussed in article, and date article was written.

I was thinking about using MySQL and PHP but was wondering if there was a better way to do this. Nothing against MySQL or PHP but I'd hate to find out there was a better way to do it after it's finished.

Any suggestions would be greatly appreciated.

Thanks,
SR
sr2115 is offline
Reply With Quote
View Public Profile
 
 
When You Register, These Ads Go Away!
Old 08-11-2009, 05:32 PM Re: Best tools to build database?
alex021's Avatar
Skilled Talker

Posts: 96
Name: Alex
Trades: 0
MySQL and PHP are fine for what you want. You can also have a look at prebuild websites like joomla and dupal which possibly will make it abit easyer for you
alex021 is offline
Reply With Quote
View Public Profile
 
Old 08-14-2009, 01:51 AM Re: Best tools to build database?
Average Talker

Posts: 17
Name: Mike Shinoda
Location: Australia
Trades: 0
Agreed, these are both good tools to provide the flexibility you need to meet this job
chatterbox01 is offline
Reply With Quote
View Public Profile Visit chatterbox01's homepage!
 
Old 08-15-2009, 03:50 PM Re: Best tools to build database?
Super Talker

Posts: 101
Trades: 0
PHP/MYSQL is the best combination. If you want to use asp/asp.net then MS SQL is good for it. You most probably need a customized solution since you need the search functionalities (filtering the database by various criteria)
__________________
AccuWebHosting.Com - Windows Hosting Expert
ASP.NET 3.5 | SQL 2005 Database | US Based Hosting Company | 24 X 7 Support | Daily Backups | Uptime Guarantee | Affiliates - $50 Per Sale
| Website Hosting
twhdir is offline
Reply With Quote
View Public Profile
 
Old 08-17-2009, 02:55 AM Re: Best tools to build database?
Novice Talker

Posts: 8
Name: Kailash
Location: twitter.com/webhosttalk
Trades: 0
PHP/MySQL with Linux are good combination. Also, you may get free third party script/CMS meet to your requirement so you will not even need to write a piece of code.

Last edited by Kailash1; 08-17-2009 at 03:18 AM..
Kailash1 is offline
Reply With Quote
View Public Profile Visit Kailash1's homepage!
 
Old 08-19-2009, 12:14 PM Re: Best tools to build database?
Junior Talker

Posts: 3
Trades: 0
Quote:
Originally Posted by alex021 View Post
MySQL and PHP are fine for what you want. You can also have a look at prebuild websites like joomla and dupal which possibly will make it abit easyer for you
Thanks for your response and suggestion of joomla. I was pleasantly surprised by the interface, it seems very user friendly.

A concern with joomla is that content can't be assigned to multiple categories, a function I think I'd need to cross reference images, articles, artists, authors and dates.
They do offer ways around this so I'm still considering.
(http://docs.joomla.org/Can_articles_...or_sections%3F )

Last edited by sr2115; 08-19-2009 at 04:22 PM..
sr2115 is offline
Reply With Quote
View Public Profile
 
Old 08-19-2009, 12:26 PM Re: Best tools to build database?
Junior Talker

Posts: 3
Trades: 0
twhdir, thanks for your reply.
You mentioned a "customized solution" because of the search functionalities I need. I'd like to investigate that more...Do you know of any examples I can look at that seem similar to what I need?

General Question
Using PHP and MySQL, would I have to install the database on a server? If so it may be a problem with space...Do you know of any solutions that can be done on web to avoid installing on a server?

Last edited by sr2115; 08-19-2009 at 12:29 PM..
sr2115 is offline
Reply With Quote
View Public Profile
 
Old 08-27-2009, 01:38 AM Re: Best tools to build database?
Banned

Posts: 5
Name: dealsforums
Trades: 0
Thanks for your suggestions... really helpful...
dealsforums is offline
Reply With Quote
View Public Profile
 
Old 08-27-2009, 11:22 AM Re: Best tools to build database?
Junior Talker

Posts: 4
Name: Richard
Location: NC
Trades: 0
PHP plus MySQL is, arguably, the standard solution for something like what you want.
__________________
Raleigh Web Design
ditch182 is offline
Reply With Quote
View Public Profile Visit ditch182's homepage!
 
Old 09-08-2009, 09:07 PM Re: Best tools to build database?
Average Talker

Posts: 24
Trades: 0
try GUI client
tmjacsone is offline
Reply With Quote
View Public Profile
 
Old 10-05-2009, 01:23 PM Re: Best tools to build database?
Novice Talker

Posts: 10
Name: Francis
Trades: 0
I think PHP and Mysql is the best combination and one plus point is with mysql is that it gives you Graphical User Interface since Oracle doesn't give you GUI.
you could use SqlServer also.
__________________
Bluehost Review and $3.95/month Bluehost Coupon
Hostmonster Review and $3.95/month Hostmonster Coupon
Ciewinski is offline
Reply With Quote
View Public Profile
 
Old 10-13-2009, 04:58 AM Re: Best tools to build database?
whwjohn's Avatar
Average Talker

Posts: 15
Name: John
Trades: 0
Combination of PHP and Mysql is the best tool to build database.
whwjohn is offline
Reply With Quote
View Public Profile Visit whwjohn's homepage!
 
Old 10-18-2009, 05:32 PM Re: Best tools to build database?
Junior Talker

Posts: 2
Trades: 0
Well, I think Navicat lite(phpmyadmin replacement)8.1.18 is a very good database development free tool, It supports all the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc.
__________________
I like plywood crates & NZ Mattress
wlb1 is offline
Reply With Quote
View Public Profile
 
Old 10-23-2009, 02:46 PM Re: Best tools to build database?
freezea's Avatar
Average Talker

Posts: 27
Trades: 0
Of course the answer is PHP/MYSQL.
__________________
RAQ Report: Web-based Excel-like Java reporting tool.
freezea is offline
Reply With Quote
View Public Profile
 
Old 11-07-2009, 02:30 AM Re: Best tools to build database?
Banned

Posts: 3
Name: Iftikhar
Trades: 0
Hi,

as some organizations involved in emailing monitoring, developed some tools, databases in use by mail servers to filter inbound mail, rejecting it and bouncing back, please help me to build a small database of mail servers rejecting freemail like Yahoo Mail.

(if you are aware of another freemail service provided, showing the same problems - Gmail, Hotmail ... , please provide me with some details).

The first mail relay server, I discovered, rejecting self-testing at Yahoo Mail was Yahoo Operations Europe - smtp mail relay server in London,
generating dislike notice to the world
"I don't like the recipient..."

Another one was mail server at Columbia University.

Today another one from California, generating the following notice

Undeliverable:

Delivery has failed to these recipients or distribution lists:
...
Diagnostic information for administrators:
...

Please add your comments to this list.
bizexpert is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Best tools to build database?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 



Page generated in 0.15553 seconds with 13 queries