I need help making a searchable database

toranokaze · 05-27-2010, 01:32 PM

I want to organize all my notes and e books into a searchable data, but I'm not sure where to go here: SQL, Acess, C++, xlm...

GunMaster357 · 05-29-2010, 06:14 AM

First things first :

What kind of usage : Personnal / Professionnal ?
How many items do you intend to enter into this base ?
What kind of search do you wish to perform ?

C++ is a programming language but not a database.
XML is a description language, can be used to store data but not a database per se.
SQL is a database language: OK but which one? MySQL, Oracle, SYBASE, PostgreSQL... And no interface to speak of.

Access is a database, has a language (VBA) you can learn and can do a nice interface job.

But there's an even more important question: is there someone outside that has already done it?

In other words, is there a ready made program that can do what you need? That way you wont loose ay time in organizing your data, building your database and programming the interface?

Unless, of course, you absolutely want to learn how to do it by yourself...

I'm an IT professional and work for one of the biggest real estate company in France. I routinely use database programs and create interfaces for data access.

toranokaze · 06-03-2010, 06:35 AM

What kind of usage : Personnal / Professionnal
more personal than professional in that I will be the only one to use the data base.

How many items do you intend to enter into this base: I want to

orgainze my notes, search able books, peer reviewed papers, so lower to mid thousands most likely under 10k enteries

What kind of search do you wish to perform: keyword based searches, for instances if I enter "speed of light" I would want my personal writing , and a page from my physics book.

The closest program I have found is OneNote by Microsoft and I'm not sure if it will do all that I need. But I'm a quick study and have a lot of time on my hand, far more time than money.

GunMaster357 · 06-06-2010, 10:01 AM

You might want to have a look there

http://www.softplatz.com/software/pe...notes-manager/

Some of these softwares are free.

squirell nutkin · 06-06-2010, 07:10 PM

Is excel a database software?

toranokaze · 06-06-2010, 09:45 PM

No excel is spreadsheets

toranokaze · 06-06-2010, 09:46 PM

Quote:

Originally Posted by GunMaster357

You might want to have a look there

http://www.softplatz.com/software/pe...notes-manager/

Some of these softwares are free.

My anti-virus flag that site

GunMaster357 · 06-07-2010, 02:44 AM

Strange, it's not flagged for me neither at home nor at the office with 2 different anti-virus suites (BitDefender and McAfee).

05-27-2010, 01:32 PM	#1
toranokaze I'm still a jerk Join Date: Oct 2007 Location: Little Mexico Posts: 1,817	I need help making a searchable database I want to organize all my notes and e books into a searchable data, but I'm not sure where to go here: SQL, Acess, C++, xlm... __________________ "Without deviation from the norm progress is not possible." - Frank Zappa It is the ignorance of ignorance that lead to the death of knowledge The Virgin Mary does not weep for her son, for he is in paradise. She weeps for the world , for we are in suffering.

05-29-2010, 06:14 AM	#2
GunMaster357 Professor Join Date: Apr 2010 Location: Brest (FRANCE) Posts: 1,837	First things first : What kind of usage : Personnal / Professionnal ? How many items do you intend to enter into this base ? What kind of search do you wish to perform ? C++ is a programming language but not a database. XML is a description language, can be used to store data but not a database per se. SQL is a database language: OK but which one? MySQL, Oracle, SYBASE, PostgreSQL... And no interface to speak of. Access is a database, has a language (VBA) you can learn and can do a nice interface job. But there's an even more important question: is there someone outside that has already done it? In other words, is there a ready made program that can do what you need? That way you wont loose ay time in organizing your data, building your database and programming the interface? Unless, of course, you absolutely want to learn how to do it by yourself... I'm an IT professional and work for one of the biggest real estate company in France. I routinely use database programs and create interfaces for data access. __________________ "War is God's way of teaching Americans geography." - Ambrose Bierce

06-03-2010, 06:35 AM	#3
toranokaze I'm still a jerk Join Date: Oct 2007 Location: Little Mexico Posts: 1,817	What kind of usage : Personnal / Professionnal more personal than professional in that I will be the only one to use the data base. How many items do you intend to enter into this base: I want to orgainze my notes, search able books, peer reviewed papers, so lower to mid thousands most likely under 10k enteries What kind of search do you wish to perform: keyword based searches, for instances if I enter "speed of light" I would want my personal writing , and a page from my physics book. The closest program I have found is OneNote by Microsoft and I'm not sure if it will do all that I need. But I'm a quick study and have a lot of time on my hand, far more time than money. __________________ "Without deviation from the norm progress is not possible." - Frank Zappa It is the ignorance of ignorance that lead to the death of knowledge The Virgin Mary does not weep for her son, for he is in paradise. She weeps for the world , for we are in suffering. Last edited by toranokaze; 06-03-2010 at 06:41 AM.

06-06-2010, 10:01 AM	#4
GunMaster357 Professor Join Date: Apr 2010 Location: Brest (FRANCE) Posts: 1,837	You might want to have a look there http://www.softplatz.com/software/pe...notes-manager/ Some of these softwares are free. __________________ "War is God's way of teaching Americans geography." - Ambrose Bierce

06-06-2010, 07:10 PM	#5
squirell nutkin has a second hand user title Join Date: Feb 2006 Location: in a Nut House Posts: 2,017	Is excel a database software? __________________ And now I'm finished posting.

06-06-2010, 09:45 PM	#6
toranokaze I'm still a jerk Join Date: Oct 2007 Location: Little Mexico Posts: 1,817	No excel is spreadsheets __________________ "Without deviation from the norm progress is not possible." - Frank Zappa It is the ignorance of ignorance that lead to the death of knowledge The Virgin Mary does not weep for her son, for he is in paradise. She weeps for the world , for we are in suffering.

06-07-2010, 02:44 AM	#8
GunMaster357 Professor Join Date: Apr 2010 Location: Brest (FRANCE) Posts: 1,837	Strange, it's not flagged for me neither at home nor at the office with 2 different anti-virus suites (BitDefender and McAfee). __________________ "War is God's way of teaching Americans geography." - Ambrose Bierce

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)