Thread: SQL Library

  1. #1
    Chad Johnson
    Join Date
    May 2004
    Posts
    154

    SQL Library

    I use Access at work, and we need an SQL server to get live data off a database (think that's how it is), but at home I don't have an SQL server installed on my computer. When I execute access queries on tables embedded in the Access database, they work just fine.

    Is there a way to use SQL in an application without having an SQL server? What libraries can I use? What kind of database could I use it on?

  2. #2
    Registered User
    Join Date
    Sep 2001
    Posts
    4,912
    I can't think of why you would want to use SQL in an application with having an SQL server. SQL is a language designed for communicating with databases. You could probably make a program that recieves SQL requests from other programs and does something with them other than access a database, but you're spinning your wheels with that one. It's really not clear what you're asking. It sounds like you don't fully understand what is happening on your network and why you need SQL, so the only thing I can recommend is that you go read about the subject. Do you have a specific question where you can give us more information about what you're trying to do.

    To answer your other questions, in C++ there is no standard SQL/database library, but there are many APIs available for this purpose, and using streams in C++ you could make your own from scratch. I do however, see no relevancy to C++ in your questions, so this may be better at the Tech Board (mods?). You can use an SQL client on any database that accepts SQL. MySQL is free an good for learning, etc... but if this is for work and you'll be using Access, etc.. you may want something more professional.

  3. #3
    Chad Johnson
    Join Date
    May 2004
    Posts
    154
    Well basically I have been wanting to make some Bible software, and I want to be able to search for keywords easily. I know you can search for things easily with SQL.

    I would like to use SQL if possible to search through it. Is there a way I can do this?

    Or is there a better way? I want users to be able to download the program and the Bible database file and not have to install a whole bunch of stuff to go along with the program.

  4. #4
    Chad Johnson
    Join Date
    May 2004
    Posts
    154
    I am looking into sqlite (http://www.sqlite.org).

  5. #5
    Registered User
    Join Date
    Sep 2001
    Posts
    4,912
    In my opinion, SQL is a bit too high-level for this kind of a project, but maybe I'm just not looking at it properly. It is easy to make search algorthms in C++, and since it is just your program that is accessing the database, maybe you should make your own file format (really not that hard - something close to a standard text file should be fine). If you had the program access the database online, then maybe SQL and a distributed database would be a better option, but for this type of a project, making your own search algorithm is your best bet. www.aihorizon.com has some articles on making efficient search functions, etc...

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. What's an import library?
    By chiefmonkey in forum C++ Programming
    Replies: 1
    Last Post: 06-19-2009, 05:00 PM
  2. Property Set Library (PSL) - Announcement
    By vultur_gryphus in forum Projects and Job Recruitment
    Replies: 0
    Last Post: 05-29-2008, 06:04 AM
  3. Pro*C Compilation.
    By asif_oracle in forum C Programming
    Replies: 4
    Last Post: 04-01-2008, 09:41 AM
  4. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 09:09 AM
  5. very weird .h problem
    By royuco77 in forum C++ Programming
    Replies: 1
    Last Post: 09-11-2005, 07:55 AM