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
