Re: [sqlite] Advice needed for a new group member
Hi Mike, After trying your sqlite3Explorer, I decided to use sqlite 3.08 as you advised. It is a great work! Since it's been written in Delphi, it encourages me to continue my revision project. And, especially importing existing MDB tables, made me gain quite a long time. Thanks a lot! Ahmet Aksoy mike cariotoglou wrote: Definitely 3.x. why go with an old version ? -Original Message- From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] Sent: Saturday, January 01, 2005 3:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Advice needed for a new group member Hi Mike, I'll check your wrapper as son as possible. Do you think that version 3.x to be preferred to version 2.8.x? My sql clauses are generally very simple. I'm using no triggers, etc. Do you think that version 2.8.x will be enough for me? (Considering I've been using MsAccess.) Thanks a lot. Ahmet Aksoy mike wrote: When used correctly, sqlite is the fastest SQL engine I have seen (I am also using D7). So, yes, it would be a good choice. You need some API wrapper for sqlite, there are a few around including my own :) (see contrib)
Re: [sqlite] Advice needed for a new group member
Tim Anderson wrote: -Original Message- From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] Sent: 03 January 2005 11:07 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Advice needed for a new group member Hi Mike, There are some reasons for me to prefer older versions: Ahmet, Good points, but there are several strong reasons to prefer Sqlite 3.0. Some of the ones which matter to me are: 1. Supports blobs. 2. Supports case-insensitive comparison. 3. Doesn't store everything as strings (saves space). I also have a simple Sqlite 3.0 wrapper for D7: http://www.itwriting.com/sqlitesimple.php Tim Hi Tim, Of course, you're right! They are all important points in general. But, in my case now, I have no need for blobs, and no large spaces. Anyway, it would be quite nice if I could make case-insensitive comparisons; but it is not a must. In my previous project I had used some database components in order to access MSAccess, and bind it to a TDBGrid. I will gain some time if I can use some ready and tested components in my project. Last week I've tried Aducom components for version 2.8.x, and 3.x. Old version works nice with the examples, but I couldn't obtain similar results for the new version. I also tried Zeos components for version 2.8, but I could not succeed even opening existing databases. Also, I didn't try to convert my existing MsAccess tables yet. I think it will show me the required choice. I will check your wrappers also, as soon as possible. Are there any sample databases and/or sample projects for Delphi on the internet which I can download ? Thanks a lot. Ahmet Aksoy
RE: [sqlite] Advice needed for a new group member
> -Original Message- > From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] > Sent: 03 January 2005 11:07 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Advice needed for a new group member > > Hi Mike, > There are some reasons for me to prefer older versions: Ahmet, Good points, but there are several strong reasons to prefer Sqlite 3.0. Some of the ones which matter to me are: 1. Supports blobs. 2. Supports case-insensitive comparison. 3. Doesn't store everything as strings (saves space). I also have a simple Sqlite 3.0 wrapper for D7: http://www.itwriting.com/sqlitesimple.php Tim
Re: [sqlite] Advice needed for a new group member
Hi Mike, There are some reasons for me to prefer older versions: 1- Generally they are more stable. 2- Most of the related problems are known 3- There are more writings about them 4- You can find more utilities working with them 5- You can find more sample codes for them Especially lack of working examples on version 3.x, make me hesitate as an end user. Ahmet Aksoy mike cariotoglou wrote: Definitely 3.x. why go with an old version ? -Original Message- From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] Sent: Saturday, January 01, 2005 3:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Advice needed for a new group member Hi Mike, I'll check your wrapper as son as possible. Do you think that version 3.x to be preferred to version 2.8.x? My sql clauses are generally very simple. I'm using no triggers, etc. Do you think that version 2.8.x will be enough for me? (Considering I've been using MsAccess.) Thanks a lot. Ahmet Aksoy mike wrote: When used correctly, sqlite is the fastest SQL engine I have seen (I am also using D7). So, yes, it would be a good choice. You need some API wrapper for sqlite, there are a few around including my own :) (see contrib)
RE: [sqlite] Advice needed for a new group member
Definitely 3.x. why go with an old version ? -Original Message- From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] Sent: Saturday, January 01, 2005 3:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Advice needed for a new group member Hi Mike, I'll check your wrapper as son as possible. Do you think that version 3.x to be preferred to version 2.8.x? My sql clauses are generally very simple. I'm using no triggers, etc. Do you think that version 2.8.x will be enough for me? (Considering I've been using MsAccess.) Thanks a lot. Ahmet Aksoy mike wrote: >When used correctly, sqlite is the fastest SQL engine I have seen (I >am also using D7). So, yes, it would be a good choice. >You need some API wrapper for sqlite, there are a few around including >my own :) (see contrib) > > >
Re: [sqlite] Advice needed for a new group member
Hi Mike, I'll check your wrapper as son as possible. Do you think that version 3.x to be preferred to version 2.8.x? My sql clauses are generally very simple. I'm using no triggers, etc. Do you think that version 2.8.x will be enough for me? (Considering I've been using MsAccess.) Thanks a lot. Ahmet Aksoy mike wrote: When used correctly, sqlite is the fastest SQL engine I have seen (I am also using D7). So, yes, it would be a good choice. You need some API wrapper for sqlite, there are a few around including my own :) (see contrib)
Re: [sqlite] Advice needed for a new group member
Op vrijdag 31 december 2004 02:23, schreef mike cariotoglou: > In the home page of www.sqlite.org there is a "contrib" link in the right > upper area. > It points to http://www.sqlite.org/contrib Thanks Bert
RE: [sqlite] Advice needed for a new group member
In the home page of www.sqlite.org there is a "contrib" link in the right upper area. It points to http://www.sqlite.org/contrib -Original Message- From: Bert Verhees [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 11:02 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Advice needed for a new group member Op donderdag 30 december 2004 13:37, schreef mike: > When used correctly, sqlite is the fastest SQL engine I have seen (I > am also using D7). So, yes, it would be a good choice. > You need some API wrapper for sqlite, there are a few around including > my own :) (see contrib) Excuse, me, can you please point me to the location where I can find your wrapper. Thanks Bert > > -Original Message- > From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 30, 2004 12:00 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Advice needed for a new group member > > Hi, > I'm both new to the group, and sqlite. > I want to redesign one of my old projects. > It is a kind of mapping program, which shows ports on a world map. > Map is drawn using geographical coordinates of seashores. Also the > coordinates of the ports are used in the program. > You can make searches on port lists, and draw the selected part of the > map which contains the port. Also, you can see the local details if > you point a location on the map. You can change the coordinates and > scale of the map easily. > In the project I'm using MSAccess. Now there are about 3000 ports on > the database. That number will increase in near future. > There are very few editing on the database. Records are mostly readonly. > In order to gain some extra speed, and remove licencing problems > while distributing my program, I made some search on the internet, and > found sqlite as it fits best to my needs. > I'm using delphi7 pro for programming. > Do you think that sqlite will be a correct choice for such a project? > Which delphi components should I use? > Thanks in advance. > Ahmet Aksoy
Re: [sqlite] Advice needed for a new group member
Hi, please see http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards, rene Bert Verhees wrote: Op donderdag 30 december 2004 13:37, schreef mike: When used correctly, sqlite is the fastest SQL engine I have seen (I am also using D7). So, yes, it would be a good choice. You need some API wrapper for sqlite, there are a few around including my own :) (see contrib) Excuse, me, can you please point me to the location where I can find your wrapper. Thanks Bert -Original Message- From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 12:00 AM To: sqlite-users@sqlite.org Subject: [sqlite] Advice needed for a new group member Hi, I'm both new to the group, and sqlite. I want to redesign one of my old projects. It is a kind of mapping program, which shows ports on a world map. Map is drawn using geographical coordinates of seashores. Also the coordinates of the ports are used in the program. You can make searches on port lists, and draw the selected part of the map which contains the port. Also, you can see the local details if you point a location on the map. You can change the coordinates and scale of the map easily. In the project I'm using MSAccess. Now there are about 3000 ports on the database. That number will increase in near future. There are very few editing on the database. Records are mostly readonly. In order to gain some extra speed, and remove licencing problems while distributing my program, I made some search on the internet, and found sqlite as it fits best to my needs. I'm using delphi7 pro for programming. Do you think that sqlite will be a correct choice for such a project? Which delphi components should I use? Thanks in advance. Ahmet Aksoy
Re: [sqlite] Advice needed for a new group member
Op donderdag 30 december 2004 13:37, schreef mike: > When used correctly, sqlite is the fastest SQL engine I have seen (I am > also using D7). So, yes, it would be a good choice. > You need some API wrapper for sqlite, there are a few around including my > own :) (see contrib) Excuse, me, can you please point me to the location where I can find your wrapper. Thanks Bert > > -Original Message- > From: Ahmet Aksoy [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 30, 2004 12:00 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Advice needed for a new group member > > Hi, > I'm both new to the group, and sqlite. > I want to redesign one of my old projects. > It is a kind of mapping program, which shows ports on a world map. Map is > drawn using geographical coordinates of seashores. Also the coordinates of > the ports are used in the program. > You can make searches on port lists, and draw the selected part of the map > which contains the port. Also, you can see the local details if you point > a location on the map. You can change the coordinates and scale of the map > easily. > In the project I'm using MSAccess. Now there are about 3000 ports on the > database. That number will increase in near future. > There are very few editing on the database. Records are mostly readonly. > In order to gain some extra speed, and remove licencing problems while > distributing my program, I made some search on the internet, and found > sqlite as it fits best to my needs. > I'm using delphi7 pro for programming. > Do you think that sqlite will be a correct choice for such a project? > Which delphi components should I use? > Thanks in advance. > Ahmet Aksoy
Re: [sqlite] Advice needed for a new group member
Op woensdag 29 december 2004 22:59, schreef Ahmet Aksoy: > Hi, > I'm both new to the group, and sqlite. > I want to redesign one of my old projects. > It is a kind of mapping program, which shows ports on a world map. Map > is drawn using geographical coordinates of seashores. Also the > coordinates of the ports are used in the program. > You can make searches on port lists, and draw the selected part of the > map which contains the port. Also, you can see the local details if you > point a location on the map. You can change the coordinates and scale of > the map easily. > In the project I'm using MSAccess. Now there are about 3000 ports on the > database. That number will increase in near future. > There are very few editing on the database. Records are mostly readonly. > In order to gain some extra speed, and remove licencing problems while > distributing my program, I made some search on the internet, and found > sqlite as it fits best to my needs. > I'm using delphi7 pro for programming. > Do you think that sqlite will be a correct choice for such a project? I guess it is, it can store data, also large numbers of data, it can very fast retrieve data, as I understand your database is embedded, that is also a reason why sqlite can be used. There are some hickups in the sqlite-sql-parser which you should know about, I don't know if they are fixed in the latest versions. One annoying thing is that when using OR in the WHERE part in the same table sqlite does not make use of the indexes. I always avoid this, by using UNION, there are some more small things, they are documented on the sqlite-website > Which delphi components should I use? I use mostly http://www.aducom.com/sqlite/ for Delphi, easy to use, works good and easy, and you can connect it to data-aware components of Delphi. What also is a good component is the dbXpress driver, but sadly it is only available for sqlite 2.8.x, but still I use it. I once had the plan to rewrite it to sqlite 3.x, but I have no time. You can find it on: http://www.bcp-software.nl/artikelen/sqlite.html But it is easy to use regards Bert Verhees > Thanks in advance. > Ahmet Aksoy
