[sqlite] .import not working the same in sqlite3.3.3 (exe)
Hi, My posts here do not seem to start a new thread at the forum site;; oh well... I have found, btw, that i have to stick with version 3.2.8 for my csv import; I have not worked out if it is the getting of the header line first, or the .import which is at fault.? Has anyone else found a problem with 3.3.3? randall
[sqlite] New benchmark comparisons
I haven't completed all the tests I want to run, but it makes for an interesting read: http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably add PostgreSQL to the list as well, but as far as I know they don't have an ADO.NET provider -- so I'll have to use OLEDB. Also coming up next week are comparisons vs. Sql Server Mobile, which is where SQLite is really racking up some wins recently. Robert
Re: [sqlite] bulk processes with dll or obj versions?
Randall wrote: Hi, I have a DOS wrapper running sqlite3.exe at present. Do either the dll version or obj wrapper versions accept ".import" or ".output" or equivalent as a bulk process to and from csv, or only line by record? If so, what are the commands? [noting that "copy" is removed from version 3 on?..] (or where can i find them?...) These features aren't built directly into the library, but implemented in the client. However it's very easy to implement those in code. If you'd like I can supply C source to parse the CSV text. Clay Dowling -- http://www.lazarusid.com/notes/ Lazarus Notes Articles and Commentary on Web Development
[sqlite] bulk processes with dll or obj versions?
Hi, I have a DOS wrapper running sqlite3.exe at present. Do either the dll version or obj wrapper versions accept ".import" or ".output" or equivalent as a bulk process to and from csv, or only line by record? If so, what are the commands? [noting that "copy" is removed from version 3 on?..] (or where can i find them?...) Thanks, Randall
Re: [sqlite] ANN: SQLiteSpy 1.5.1 released
That's great! Looking forward to it. --- Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello Joe Wilson, > > I want to thank you and everybody else to share their thoughts on SQLiteSpy > and let you know > that I very much value your feedback. I initially wrote SQLiteSpy for my own > personal needs > only, but it has since then certainly improved thanks to the responses I have > received by many > of its users. > > The recent disusion on the internal / external database issue made me realize > that there is > indeed a need for an internal database as well as an external DLL support for > SQLiteSpy. I hope > to be able to cater for both needs by keeping the internal SQLite engine plus > adding optional > support dynamically linking the SQLite3.dll in a future release. However, a > requirement will be > that all custom DLLs be interface-compatible with the latest original > sqlite3.dll for SQLiteSpy > to function properly. > > If you have further suggestions (appart from in-grid-editing - this is > already on the list ;-)), > please let me know! > > Regards, > > Ralf > > >But I guess the number of satisfied users of the statically-linked > >SQLiteSpy outnumber the users requiring a custom/older/newer > >sqlite3.dll DLL by 100 to 1, so it's my loss. :-) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [sqlite] SQLite usage (a project management question)
Sorry for that question...after two days with no sleep it seemd resonable. After six hours of sleep, i seem to think more clearly. John Stanton wrote: You don't have much text so you can easily take your choice, flat file or DBMS. The decision would be one based on how you intend to use the text.
Re: [sqlite] ANN: SQLiteSpy 1.5.1 released
Hello Joe Wilson, I want to thank you and everybody else to share their thoughts on SQLiteSpy and let you know that I very much value your feedback. I initially wrote SQLiteSpy for my own personal needs only, but it has since then certainly improved thanks to the responses I have received by many of its users. The recent disusion on the internal / external database issue made me realize that there is indeed a need for an internal database as well as an external DLL support for SQLiteSpy. I hope to be able to cater for both needs by keeping the internal SQLite engine plus adding optional support dynamically linking the SQLite3.dll in a future release. However, a requirement will be that all custom DLLs be interface-compatible with the latest original sqlite3.dll for SQLiteSpy to function properly. If you have further suggestions (appart from in-grid-editing - this is already on the list ;-)), please let me know! Regards, Ralf >But I guess the number of satisfied users of the statically-linked >SQLiteSpy outnumber the users requiring a custom/older/newer >sqlite3.dll DLL by 100 to 1, so it's my loss. :-)
Re: [sqlite] Re: ANN: SQLiteSpy 1.5.1 released
Hello Nahor, there is no need for you to use SQLiteSpy 1.4 to create SQLite 3.2.x compatible database files. You can do so with the latest version of SQLiteSpy as well. Here's how to do so: 1. Create a new database as usual. 2. Execute the following two SQL statements: PRAGMA legacy_file_format = 1; VACUUM; 3. The database is in 3.2.x format again. 4. Work with the database as usual, but do not "VACUUM" it without the legacy_file_format = 1. Btw, the not only applies to SQLiteSpy but to SQLite 3.3.x in general. Regards, Ralf >My application is currently using 3.2. If I create the db using >SQLiteSpy 1.5, it create one in the 3.3 format, making it unreadable by >my app. When I noticed the problem, I wanted to revert to SQLiteSpy 1.4 >but it's not available on your website anymore :(
Re: [sqlite] examples of syntax
> examples of syntax ... than the "syntax" page from the home page Try Googling for 'sql tutorial'. Regards
[sqlite] float data gets truncated
Hello, I am using sqlite with tclsqlite-2.8.15.so. I am finding that in some cases float values are getting truncated. For example 3.22 returns only 3. What is wrong ? Thanks -- View this message in context: http://www.nabble.com/float-data-gets-truncated-t1063314.html#a2766216 Sent from the SQLite forum at Nabble.com.
Re: [sqlite] SQLite usage (a project management question)
You don't have much text so you can easily take your choice, flat file or DBMS. The decision would be one based on how you intend to use the text. Eugen Stoianovici wrote: I need some help...I'm writing an app which scans some pictures and then performs ocr on those pictures saving a text buffer(around 50 bytes long) for later processing. This application will scan around 500 pages/day (hopefully) and the ocr info should remains stored for about 2 months. Here comes the question: would it be faster (for processing) to store that data in a sqlite table or in a text file? For every new scan, i have to see if the ocr result exists among the saved data and the only operations performed uppon that data is looping for string matches. Thanks
Re: [sqlite] ANN: SQLiteSpy 1.5.1 released
In general there are advantages and disadvantages about static linking of dll's. Major advantage is that if it works, you don't have to bother about dll's. But if you have more app's using the database then it might be a disadvantage. I like to use same version with all my apps and use a central dll. Another disadvantage is that if there is a bug in the dll everbody must wait for a new release and download. Otherwise the dll is immediately available. It might be a good option to support both. Use your static linking but allow the external dll to be used. THis is best of both worlds. albert Quoting Joe Wilson <[EMAIL PROTECTED]>: My dozen or so custom SQLite functions are not useful to anyone else, as they are very specific to my application's data. (Never mind the fact that they would not be accepted by DRH anyway). I commonly swap different sqlite3.dll versions in and out between runs while using Mike Cariotoglou's (excellent) SqliteExplorer and have no difficulty at all. I'm not sure why others have such problems will DLLs. But I guess the number of satisfied users of the statically-linked SQLiteSpy outnumber the users requiring a custom/older/newer sqlite3.dll DLL by 100 to 1, so it's my loss. :-) --- Ralf Junker <[EMAIL PROTECTED]> wrote: Hello Joe Wilson, the build-in database engine is a much praised feature of SQLiteSpy. It simplifies the life of many users, and mine as well, since there can be no incompatabilities with wrong DLLs and versions. I am sorry that you can not use SQLiteSpy with your custom DLL. Maybe you would like to contribute your changes to the SQLite sources, so they can become part of SQLite and SQLiteSpy as well? Apart from that, I monitor the development of SQLite closely and will always update SQLiteSpy to the latest version of SQLite as quickly as possible. Regards, Ralf >I'm not sure if this is a good feature, though: > > Built in SQLite Engine >SQLiteSpy comes as a single file executable with > the SQLite database engine already build into the > application. There is no need to distribute any DLLs, > which makes SQLiteSpy easy to deploy with customers. > >I have a custom sqlite3.dll so I would not be able >to use my databases with your app. Nor would your >users be able to upgrade to newer versions of >sqlite3.dll. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [sqlite] ANN: SQLiteSpy 1.5.1 released
Hi , Can I download SQLiteSpy some other link. It seems my ISP has some issues connecting to the site. Much better if someone can e-mail me SQLiteSpy straight away. Thanks in advance. Regards, Vishal Kashyap http://vishal.net.in On 2/2/06, Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello, > > the new SQLiteSpy 1.5.1 has just been released. SQLiteSpy is a single-exe > database manager for SQLite with the complete SQLite library already build > in. SQLiteSpy is the ideal tool for developers as well as customers who want > to explore the insides of their SQLite databases. > > SQLiteSpy is Freeware. You can download it from > > http://www.yunqa.de/delphi/sqlitespy/ > > The new version updates the internal database engine to SQLite 3.3.3 and > includes the following improvements: > > * Attached databases now show up in the schema tree view, including all their > tables, indexes, views and triggers. > > * New File -> Attach Database... menu item. > > * Attached databases can be easily detached using the schema tree view's > context menu. > > * ALTER TABLE ... ADD COLUMN automatically updates the schema tree view. The > schema tree view should now automatically adjust to any internal change to > the database schema. > > * Executing an SQL statement which does not return any data now shows all > columns on top of an empty result grid. This change was requested by many > users who felt confused when the grid was not cleared if no results were > returned. > > Best Regards, > > Ralf > > -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
