Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to create the custom database for my project. Kindly recommend me Good Book or Tutorials or Website which provide the detailed information.

The features want to implement are full text search, server/client application and encryption of text. As all the text is available in plain text.

The application would be cross platform compatible using MingW32 through Cygwin to make portable.

share|improve this question
Please take a hard look at the posts you are making on this site. Your last few questions (which I realize are spread out chronologically) have all been closed because they are too open-ended and/or not a good fit for the site. – JNK Mar 1 at 13:29

closed as not constructive by Mark Storey-Smith, Jon Seigel, Chris Travers, dezso, Joel Brown Mar 1 at 13:08

As it currently stands, this question is not a good fit for our Q&A; format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

1 Answer

Where I would recommend starting is looking through the PostgreSQL code base. It is BSD-licensed, has the features you need, and is well documented/commented. However please keep in mind that each aspect of what you are looking at is a very complex problem.

For example, it's not really possible to use an index to do full text searching of encrypted data. And big issues for full text searching include stemming words (so that if I search for "testing" I also get results for "tester").

To the extent you are able to re-use code, PostgreSQL would also be a good place to start. If you can't, at least looking at the methods for managing on-disk storage, indexing, full text search, etc. may be helpful.

The PostgreSQL site also has documentation introducing the source code's structure and the server's architecture.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.