As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Read the rest of this entry »

I’ve searched for if there was a good solution for database driven application which uses tags. Finally i found a blog entry discussing tags and database schemas.

In that entry “Toxi Solution” is the best solution. Simply the schema is like this :

I liked this schema and using it for 4 months in my projects. I’m not only using this for tags on my projects that most of table “references” are done like this. This is an old and good system for referencing tables.

For future references you can download a copy from Focus on Code : Tags_ Database schemas.mht (204KB)

If you’re searching for a database solution for your Delphi/Builder applications Advantage Database can be a good option.

I’ve using advantage local server for two years. It’s a very stable local server. It has most of the modern SQL features. It has a good table based encryption. ( With advantage local server you cannot only encrypt the table’s connection, you can encrypt datas that table has. So we can say it’s secure if our application is also secure ). The performance is supreme whether you’re running long, loooong, loooooooooong queries using multiple tables, lots of SQL functions, etc.

And two good points with Advantage. The producer of Advantage, Sybase iAnywhere distributes a program for doing all the of the operations over local tables (creating,manipulating,running queries, etc) with a user friendly gui. Additionally they distribute Delphi/Kylic/Bc++ components for doing all of the operations on tables.

Lets write some advantages of the advantage local server :

Read the rest of this entry »