Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 13 Jan 2013, at 1:38am, Ted Heng wrote: > Thanks for all the help. I was able to get my SQLite database imported from > the dump file after correcting several issues with the exported SQL > statements like VARCHAR with no length and a few other stuff. The fact that >

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Hi Simon, Thanks for all the help. I was able to get my SQLite database imported from the dump file after correcting several issues with the exported SQL statements like VARCHAR with no length and a few other stuff. The fact that I have to use REAL for DATETIME field will be an issue, but

[sqlite] Warning when querying FTS3 table

Hi All, I'm using the latest System.Data.SQlite downloaded from the website. When I query a FTS3 table (called FreeText) using the code below I get the following warning in the VS output window. SQLite error (1): no such table: main.FreeText_stat >From reading the docs I believe FreeText_stat

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 9:22pm, Ted Heng wrote: > Here's another problem. I presumed the problem is with the dump value in > fraction instead of in the format 'MMDD ...', etc. Can I change the date > format of the dump? SQLite doesn't have a date format. You can choose

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

It looks like all the DATE field are exported as TIMESTAMP by SQLite. Can we change this so it export it in regular date format? There is only one TIMESTAMP column in a table as well in SQL Server. On Jan 12, 2013, at 1:22 PM, Ted Heng wrote: Solved the BLOB issue --

Re: [sqlite] Concurrent read performance

Keith,I started Experiment 5 soon after the original post, which was to do as you suggest and run concurrent queries on a single connection shared across multiple threads. For both shared cache databases (file- and memory-backed) it didn't seem to make any difference in my test case -- queries

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Solved the BLOB issue -- Replace X' with 0X and removed the enclosing apostrophe ('). Here's another problem. I presumed the problem is with the dump value in fraction instead of in the format 'MMDD ...', etc. Can I change the date format of the dump? Operand type clash: numeric is

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 versionandlater

On 1/12/2013 1:20 PM, a...@zator.com wrote: I wish I had thought before, especially, because I remember that some time ago, I had problems for the same reason, it seems, Visual Studio has some problems with the address of the current working directory. In fact, it uses different directories

Re: [sqlite] Concurrent read performance

If your application can reasonably multi-leave "in-engine" operations -vs- out-of-engine operations, then you might want to try multiple threads against a single connection. In any case, make sure that you are not opening and closing connections. Open the connections when your application

Re: [sqlite] Concurrent read performance

What about using 2 or more databases? Wayne Bradney wrote: >>>All access in SQLite is serialized. Apologies if I'm missing something >>>fundamental here, but that's not what I'm seeing with a file-backed database >>>when shared cache is OFF.My test has a single table

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 7:32pm, Ted Heng wrote: > INSERT INTO "Z_METADATA" VALUES (1, '052A3800-692C-4A92-ACE8-F6CE6A3B204A', >

Re: [sqlite] Concurrent read performance

Increasing cache_size didn't seem to have an effect. I think I'm going to lean towards taking the 15% or so hit and use a file-backed db without shared cache for now -- I'll have to see what the impact of that will be on write performance. If that's OK, then maybe a ramdisk will get back some

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Here's one problem. I got the exported SQL statements and Microsoft SQL Server Management Studio complains about this statement. Here's the exact error message. Msg 102, Level 15, State 1, Line 45568 Incorrect syntax near

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 7:13pm, Ted Heng wrote: > There are some compatibilities with SQL statements between SQLite and SQL > Server like X' for blob etc. The syntax produced by the SQLite shell tool is fairly conservative, attempting to be compatible with other SQL engines.

Re: [sqlite] Concurrent read performance

>>All access in SQLite is serialized. Apologies if I'm missing something >>fundamental here, but that's not what I'm seeing with a file-backed database >>when shared cache is OFF.My test has a single table with 1M rows, and four >>queries that each yield 100K different rows. I run them two

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

There are some compatibilities with SQL statements between SQLite and SQL Server like X' for blob etc. Do we have a list of known compatibility issue that I can use to change the dump statements to the proper SQL Server syntax? Thanks, Simon. On Jan 12, 2013, at 11:01 AM, Simon Slavin

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 6:58pm, Ted Heng wrote: > I'm trying to export my SQLite database into SQL Server 2008, but it's very > difficult. I'm building an iOS App using Core Data with SQLite and it works > very well. Use a SQLite tool to dump to .csv or SQL format, then use a

[sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Hi, I'm trying to export my SQLite database into SQL Server 2008, but it's very difficult. I'm building an iOS App using Core Data with SQLite and it works very well. However, I need to synchronize it with my ASP.NET website. I really don't seem to find a good approach to accomplish this

Re: [sqlite] Concurrent read performance

read_uncommitted didn't seem to have any effect > From: mdblac...@yahoo.com > To: sqlite-users@sqlite.org > Date: Sat, 12 Jan 2013 11:47:55 -0600 > Subject: Re: [sqlite] Concurrent read performance > > Did you try read-uncommitted? > Sounds promising... > > 2.2.1 >

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 versionandlater

Igor: You're right. Thanks you and congratulations on your fine smell. As indicated in the OP, indeed I was using relative path with the "original" table. I wish I had thought before, especially, because I remember that some time ago, I had problems for the same reason, it seems, Visual

Re: [sqlite] Concurrent read performance

Wayne Bradney wrote: > 1. when shared cache is enabled, all reads are serialized, Yes. > I guess I MUST use a file-backed database to get concurrent reads, > even though I don't need the persistence and don't want to take the > I/O hit. If the in-memory database works, you do have enough memory

Re: [sqlite] Concurrent read performance

Also...does increasing cache_size help? Are you able to use a RAM disk? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wayne Bradney Sent: Saturday, January 12, 2013 11:39 AM To: sqlite-users@sqlite.org Subject: [sqlite]

Re: [sqlite] Concurrent read performance

On 12 Jan 2013, at 5:38pm, Wayne Bradney wrote: > "mode=memory=shared" > 1. when shared cache is enabled, all reads are serialized, and All access in SQLite is serialised. All transactions require locking the entire database. SQLite is very simple -- 'lite' -- so

Re: [sqlite] Concurrent read performance

Did you try read-uncommitted? Sounds promising... 2.2.1 http://www.sqlite.org/sharedcache.html PRAGMA read_uncommitted = ; -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wayne Bradney Sent: Saturday, January 12, 2013 11:39

[sqlite] Concurrent read performance

I have a requirement for which I'm proposing SQLite as a solution, and would appreciate some feedback to clarify my thinking. The application is a shared service (.NET/WCF) that caches relational data in-memory and serves it up when (read-only) requests come in (via operation contracts) from

Re: [sqlite] FTS questions

Test it yourself: create virtual test using fts4(context text); insert into test values ('c:\folders\video\עברית'); select * from test where context match 'עברית'; If you want a partial match add a wildcard select * from test where context match 'עברית*'; I don't have the codepage running so I

Re: [sqlite] FTS questions

Thanks for your reply Why I care the language: according to the documentation: "A term is a contiguous sequence of eligible characters, where eligible characters are all alphanumeric characters and all characters with Unicode codepoint values greater than or equal to 128. All other characters are

Re: [sqlite] FTS questions

I'm not sure I understand your problem. Why do you care what language it is? Aren't you just wanting to tokenize on backslash? Simple way is to replace all spaces in the path with another char (e.g. '_') then replace all backslashes with a space. Then you can just use the default tokenizer and

[sqlite] FTS questions

Hello all I'm new with sqlite3 and sql. I have data base that include path columns (file system path like c:\bla bla\myFiles\1.txt) On that columns I need to do 1) search for patterns in case the user want to find a file or directory 2) search for prefix path in case the user rename

[sqlite] FTS questions

Hello all I'm new with sqlite3 and sql. I have data base that include path columns (file system path like c:\bla bla\myFiles\1.txt) On that columns I need to do 1) search for patterns in case the user want to find a file or directory 2) search for prefix path in case the user rename

Re: [sqlite] convert a .sql file to a .db file

Thanks Simon! Ill try that out. -- View this message in context: http://sqlite.1065341.n5.nabble.com/convert-a-sql-file-to-a-db-file-tp66516p66521.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list