I want to build a program but am unsure of where to start. I want to build something that would allow a user to enter different options/preferences and upon hitting the search button, it would pull like results from several in house databases. I'm not expecting this to happen overnight with my lack of skills but would just like a good starting point.
It is trivial. What database system are you using (or planning to use)?
Name:
Anonymous2012-07-30 14:59
I'm not sure about database systems either. Any suggestions? I'm really starting from the ground floor on this.
Name:
Anonymous2012-07-30 15:01
so a search engine?
Name:
Anonymous2012-07-30 15:07
Slightly. Let's say that you wanted to buy a 4x4 yellow cube. In the dimensions field you would enter 4x4, in the color field, you would enter yellow and in the shape field, you would enter cube. Using those parameters i want to pull information from said databases that match with the search.
Then you're just looking at constructing a database query programmatically, using the input values from the customer. Like adding in a "color = <color>" filter and such into the selection process.
Name:
Anonymous2012-07-30 15:19
>>6
I think you'll be able to do that with any tutorial on SQL for beginners.
Name:
Anonymous2012-07-30 15:20
That makes sense. Any suggestions on what i should be using to do all this?
>>11
Well is this going to be an application that will be run natively? Or is it going to consist of webpages that are accessed from a server on the local network / run from a public company website?
This is really easy, you can do it overnight, it almost looks like natural language:
-- Create your table
BEGIN TRANSACTION;
CREATE TABLE Cars(Id integer primary key autoincrement, Name text, Dimension text, Color text);
INSERT INTO Cars VALUES(1, 'Jeep Cherokee', '4x4', 'Brown');
INSERT INTO Cars VALUES(2, 'BMW M3', 'Coupe', 'Red');
INSERT INTO Cars VALUES(3, 'Mercedes E350', 'Cabriolet', 'Black');
COMMIT;
-- Then query it
SELECT * FROM Cars WHERE dimension like '4x4';
-- You get:
-- 1|Jeep Cherokee|4x4|Brown