If you’ve written an application using Advantage Local Server and want your application to run on another machine you have to distribute some files with your application. These files are Advantage’s API dlls, charset configs, and configuration file.

Lets check which files to be copied :

Read the rest of this entry »

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 »

When using Zeos Database Objects you can encounter some problems about charset. The main charset problem will be that you’re using a charset different than latin1. In this case you can get some errors while showing or fetching data from mySQL.

We have a simple solution :

Read the rest of this entry »

If a field’s type is TEXT ( like LONGTEXT, MEDIUMTEXT etc) and we try to show it on a DBGrid it’ll be shown like (MEMO). But everyone in the world want to show some part of the TEXT field to user. For example you want to show user first 200 characters of the TEXT field.

To solve this situation;

Read the rest of this entry »