Re: [sqlite] Long long int constants in sources

On Wed, 25 Dec 2019 at 01:24, Clemens Ladisch wrote: > Max Vlasov wrote: > > bcc 5.5 compiler ... didn't like long long constants > >such as -2251799813685248LL > > If you want to make this particular compiler happy, use > -2251799813685248i64. > Thanks, this helped

Re: [sqlite] Long long int constants in sources

On Tue, 24 Dec 2019 at 23:58, Warren Young wrote: > On Dec 24, 2019, at 12:32 PM, Max Vlasov wrote: > > > > I didn't mention it was for sqlite > > static compiling with Delphi 32 bit, that supports (also quite old) OMF > > static libraries format > > Would it

Re: [sqlite] Long long int constants in sources

On Tue, 24 Dec 2019 at 21:37, Warren Young wrote: > On Dec 24, 2019, at 3:19 AM, Max Vlasov wrote: > > > > an "ancient" bcc 5.5 compiler > > Yes, [almost 20 years old][1] now. Even in these times of slowing > technology, that’s still a very long time in comp

[sqlite] Long long int constants in sources

ages, like [ ) expected in function ] or [ If statement missing ) ], but in all those cases the lines contained long long constants. Is this something that appeared unintentionally and might be fixed or long long int constants are first-class citizens now? Th

Re: [sqlite] [EXTERNAL] "Optional" incoming parameters for virtual tables

-40 > It seems that as a general rule it's not good to have close estimatedCost values since they will sometimes yield the same LogEst values. rRun evaluations in the sources are too complex to analyze Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] "Optional" incoming parameters for virtual tables

ly have in mind that sometimes it is safe to implement a data piece in a single entity so file mask may acquire something like comma-list (or semocolon) "*.txt;*.csv" Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.s

Re: [sqlite] [EXTERNAL] "Optional" incoming parameters for virtual tables

On Wed, 17 Apr 2019 at 15:08, Hick Gunter wrote: > ... > > SELECT contents from textfiles( 'mypath', NULL, 0); > SELECT contents from textfiles where search_path = 'mypath' and > is_recursive = 1; > SLEECT contents from textfiles where search_path = 'mypath' and > name_pattern IN

Re: [sqlite] [EXTERNAL] "Optional" incoming parameters for virtual tables

On Wed, 17 Apr 2019 at 12:52, Hick Gunter wrote: > Your xBestIndex function should be returning a cost that is proportional > to the "effort required to fulfill the query". My own VT implementations > have been returning the total number of records for queries with no > constraints and assuming

[sqlite] "Optional" incoming parameters for virtual tables

with small values? I tested it with a couple of vt implementations, but the number of columns in both required/optional pool are low and I expect some trouble when the number will go up. Thanks, Max ___ sqlite-users mailing list sqlite-users@mailinglists.

Re: [sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

ones. Max On Fri, 15 Mar 2019 at 18:00, Richard Hipp wrote: > On 3/15/19, Max Vlasov wrote: > > > > But 3.27.2 said > > malformed database schema ({sqlite_autoindex_mytablename}_1) - orphan > > index. > > This error message arises from enhanced early dete

[sqlite] Malformed schema (orphan index) on particular db with the version 3.27.2

databases to check. But if this is due some bug, fixing it would probably save much time for me :) Thanks Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Exception handling during create table from a virtual one

On Fri, Oct 26, 2018 at 5:50 PM Clemens Ladisch wrote: > > Аfter the exception is thrown > > If I continue the execution > > You must return from the callback function normally, or abort the process. > Anything else will corrupt SQLite's internal state. > > Thanks, probably it's better

[sqlite] Exception handling during create table from a virtual one

I can provide small copies of the original db (1024 bytes) and malformed (2048) Thanks, Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] BUG REPORT

To whom it may concern, Whilst using an ODBC driver for SQLite acquired from: http://www.ch-werner.de/sqliteodbc/ I came across a potential bug in SQLite. I have an application running VB.NET on a Windows 7 32-bit machine and have installed the sqliteodbc.exe from the website

Re: [sqlite] [EXTERNAL] Re: sqlite3_progress_handler(D,N,X,P)

On Fri, May 25, 2018 at 10:29 AM, x wrote: > You could have interrupt checks just before the return of a result row > yourself by creating a Step fct that called sqlite3_step and then checked > for an interrupt. It’s when the sqlite3.c code’s being run interrupt is > most

Re: [sqlite] Map a field type to a best suited sqlite3_result_* call

y. But for any unrecognized it will return "integer", but I'd rather have "text". Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Map a field type to a best suited sqlite3_result_* call

ways better to rely on the approved logic of sqlite itself. Thanks, Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite equivalent of SQL Over(Partition)

timization for the column sub-query. But at least it's formally possible. Max On Fri, Apr 6, 2018 at 8:20 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 5 Apr 2018, at 11:41am, DThomas <d...@thomasres.net> wrote: > > > Select DISTINCT Sites.Customer, Sites.Digit, >

Re: [sqlite] Access to sqlite3_api_routines outside of a loadable extension context

tion (or inline using the SQLITE_CORE define) and use the > EXTRA_INIT hook to do initialization. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > >-Original Message- > >From: sqli

[sqlite] Access to sqlite3_api_routines outside of a loadable extension context

Hi, I'm considering creating a virtual table or user function that might possible work either as a loadable extension or as a general, statically created one. In order to avoid repeating during developing, I thought that I might use sqlite3_api_routines structure as a universal access to sqlite

[sqlite] Unexpected optimization

Hi, I noticed an unexpected optimization at the sqlite side. Currently I can not reproduce this with some arbitrary test data (probably I will eventually). Anyway the logic behind this (pseudo-code query) Select , (Select count(*) from LookUpTable where LookUpTable.Value=TableValue) as

Re: [sqlite] finding the number of records until a value is different

order by id limit 1), case when (select bc from testdata where id > curid order by id limit 1) = bc then grp else grp + 1 end from filter where nextid not null ) select bc, count(*) from filter group by grp I'll be glad to reduce expressions here to some more readable constructs, but I

Re: [sqlite] All versions compatible "very big" estimatedCost (Virtual tables)

On Tue, Mar 28, 2017 at 11:26 AM, Max Vlasov <max.vla...@gmail.com> wrote: > > > So, what is the maximum reasonable value of estimatedCost that will not > turn sqlite into possible overflow errors while telling at the same time > that I consider some variant very, ver

Re: [sqlite] All versions compatible "very big" estimatedCost (Virtual tables)

On Tue, Mar 28, 2017 at 12:51 PM, Dominique Devienne wrote: > On Tue, Mar 28, 2017 at 11:00 AM, Hick Gunter wrote: > > > > > The "estimated cost" is described as "how many disk IO operations are > > expected". Version higher than 3.8.2 allow setting an

[sqlite] All versions compatible "very big" estimatedCost (Virtual tables)

that will not turn sqlite into possible overflow errors while telling at the same time that I consider some variant very, very expensive? Or maybe changing cheap from 1 to 0 will do the trick? Thanks Max ___ sqlite-users mailing list sqlite-users@mailingli

[sqlite] Best settings for concurency

sqlite3_step and COMMIT call ? Thanks for help and excuse me for bad English. --- With best regards, Max Terentiev. Business Software Products. AMS Development Team. supp...@bspdev.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] trimming with tab and other special characters

On Tue, Nov 29, 2016 at 4:19 PM, Igor Tandetnik wrote: That's the exact opposite of your interpretation. For backslash escapes, > you need to rely on "facilities of your programming language". If you > cannot, and must use raw SQL queries, there are still ways to represent >

Re: [sqlite] trimming with tab and other special characters

.de> wrote: > Max Vlasov wrote: > > trim(col, char(9)) > > works, while > > trim(col,'\t') > > does not. > > SELECT trim('ttthello\tt\\\', '\t'); > hello > > Works as designed. > > SQL does not use backslash escaping. > Use char(9) or an a

[sqlite] trimming with tab and other special characters

Hi, the search in the mailing list about the trim function reveals possible escaping support for the second parameter of the function, but in my case (sqlite 3.15.1) trim(col, char(9)) works, while trim(col,'\t') does not. Can someone clarify on that? Thanks Max

Re: [sqlite] import-prefixed symbols in sqlite3.obj file

On Thu, Nov 10, 2016 at 1:51 PM, Dominique Devienne <ddevie...@gmail.com> wrote: > On Thu, Nov 10, 2016 at 11:38 AM, Max Vlasov <max.vla...@gmail.com> wrote: > >> __imp_EnterCriticalSection > > > Is this post [1] related to your issue? > Maybe you're not us

[sqlite] import-prefixed symbols in sqlite3.obj file

s. Thanks, Max ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to wipe out data of a closed database

On Mon, Oct 24, 2016 at 4:28 PM, Wade, William wrote: > It sounds like you've got a way forward on leaks via the malloc() system > within the process space. > > 1) The region of the C process stack that was reached by some deep call stack. > 2) Processor registers. > 3)

Re: [sqlite] Best way to wipe out data of a closed database

On Mon, Oct 24, 2016 at 1:36 PM, Richard Hipp wrote: > > Memsys5 is also faster than your global system memory allocator > (before the extra overhead of zeroing, at least). But on the other > hand, you have to know the maximum amount of memory SQLite will want > at the very

Re: [sqlite] Best way to wipe out data of a closed database

Simon, thanks never heard of secure_delete, interesting, but probably no use in case of VFS Layer that leaves only encrypted data on disk. As for zero-malloc option, it looks promising. On Mon, Oct 24, 2016 at 1:34 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Oct 2016, at

[sqlite] Best way to wipe out data of a closed database

the base as a whole but also fragments of database sectors anywhere in the process memory space. One of the trick possible is to add additional zeroing out to the global free handler, but this can probably introduce performance penalties. Is there any other way to do this? Thanks, Max

[sqlite] NULL check in shell.c

){ +explain_data_delete(pArg); + } /* print usage stats if stats on */ if( pArg && pArg->statsOn ){ -- Thanks, Max Radermacher ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-

[sqlite] Changes to VFS starting 3.8.3

On Thu, Mar 10, 2016 at 5:26 PM, Richard Hipp wrote: > Perhaps your in-memory VFS was relying on some unspecified behavior > that changed? Some tests finally led to the source of my problems. When I implemented the handlers of vfs interface before, I made xFileControl return SQLITE_ERROR

[sqlite] Changes to VFS starting 3.8.3

Thanks, I suspect there's indeed some special behavior not obvious at the moment. I'll try to gather some additional information if it's possible or detect this specific behavior On Thu, Mar 10, 2016 at 5:26 PM, Richard Hipp wrote: > On 3/10/16, Max Vlasov wrote: > &g

[sqlite] Changes to VFS starting 3.8.3

age that no specific vfs-related changes for 3.8.3 were reported, only a major change that can affect structure and vfs is initial common table expressions implementation. What are the changes that might trigger the change? Thanks, Max

[sqlite] Default of "PRAGMA synchonous" for WAL mode

On Tue, 8 Mar 2016 at 13:25, Reinhard Max wrote: > On Tue, 8 Mar 2016 at 12:46, Richard Hipp wrote: > >> Documentation bug. Fixed at >> https://www.sqlite.org/docsrc/timeline?c=3540d6 > > Thanks, but https://www.sqlite.org/pragma.html#pragma_synchronous > still s

[sqlite] Default of "PRAGMA synchonous" for WAL mode

On Tue, 8 Mar 2016 at 12:46, Richard Hipp wrote: > Documentation bug. Fixed at https://www.sqlite.org/docsrc/timeline?c=3540d6 Thanks, but https://www.sqlite.org/pragma.html#pragma_synchronous still says: "NORMAL is the default when in WAL mode." cu Reinhard

[sqlite] Default of "PRAGMA synchonous" for WAL mode

Hi, the documentation for "PRAGMA synchronous"[1] says that the default for databases in WAL mode is NORMAL (1). But when I open a database in WAL mode or switch an open database to WAL mode, querying PRAGMA synchronous returns 2 (checked in 3.8.6, 3.8.10 and 3.11.1). Is this a bug in the

[sqlite] Magic number in sqlite source code

he end of the >on-page record. Happy New Year! Thanks, Max 2015-12-31 2:54 GMT+03:00 Domingo Alvarez Duarte : > Hello Duncan ! > > I saw a very good point on your suggestion ! > > I'll use it when writing/refactoring code. > > Thanks a lot ! > > > > Wed De

[sqlite] Sorting by greatest count amount

On Thu, 6 Aug 2015 at 17:51, Reinhard Max wrote: > On Thu, 6 Aug 2015 at 17:41, jose isaias cabrera wrote: > >> SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY pmuk; > > For ordered results you need an ORDER BY clause, and if you want to > order by a cal

[sqlite] Sorting by greatest count amount

On Thu, 6 Aug 2015 at 17:41, jose isaias cabrera wrote: > SELECT pmuk, count(*) FROM LSOpenJobs WHERE pmuk LIKE '% %' GROUP BY pmuk; For ordered results you need an ORDER BY clause, and if you want to order by a calculated column (count in this case), you have to give it a name: SELECT pmuk,

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

On Tue, 28 Jul 2015 at 20:55, rotaiv wrote: > I upgraded to the latest version and it decreased to 16 seconds. > With indexes, 5 seconds. :-D Is index creation time included in those 5 seconds? If your database gets created from scratch and only used once every time you do the syncing (as it

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

On Mon, 27 Jul 2015 at 17:48, Marc L. Allen wrote: > When would that specific LEFT JOIN ever do anything except return > NULLs for the right table? It only accepts rows from work where > fpath is null, and only joins those rows where fpath = home.fpath. > Since fpath must be null, home.fpath

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

On Mon, 27 Jul 2015 at 17:34, Marc L. Allen wrote: > Sorry.. confused does sqlite allow comparison between NULLs? No. > LEFT JOIN work ON work.fpath = home.fpath WHERE work.fpath IS NULL > > Should never match anything... it checks to see if work.fpath IS > NULL and if the same

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

On Mon, 27 Jul 2015 at 16:24, rotaiv wrote: > I am more than open to a more logical and/or more efficient query if > anyone has suggestions. One alternative was posted by Igor, but it might end up as the same query plan after the optimizer has done its thing (EXPLAIN will tell you). Adding

[sqlite] CVE-2015-3659

Hi, as the maintainer of the SQLite RPMs on SUSE, I am currently faced with a bug report concerning CVE-2015-3659[0]. >From the CVE's description it looks to me like the bug was in Apple's authorizer callback rather than SQLite's authorization mechanism, can anyone confirm this? Thanks,

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

nd updatin snapshot is quite difficult. What UPDATE do you propose? Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

t; Updated and got 0.060s (x2 faster)! ANALYZE does not change anything. Thank you very much for EXPLAIN QUERY PLAN! It's much more readable than just EXPLAIN which i used but did not understand :) Cheers, Max ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] Index rownum

. And firebird feels slow. So SQLite wins! Thanks, Max 2015-01-08 3:23 GMT+03:00 Richard Hipp <d...@sqlite.org>: > On 1/7/15, Max Vasilyev <maxrea...@gmail.com> wrote: > > Hi guys, > > Is it possible to get key number from the index? > > For example let's conside

[sqlite] Index rownum

of selected record before sorting. But how can I find which range of records to query so that selected record would be in this range? Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Scrolling Cursor implementation best practices (pagination and arbitrary sorting)

000 Query time: 1.133s So, next what I want is Oracle ROWNUM analog, aka counter() function. Here is a proposed implementation: http://www.sqlite.org/cvstrac/tktview?tn=4004 but it was rejected. If you would say I want something strange or exotic, please give me fast OFFSET implementation

Re: [sqlite] Artificially slow VACUUM by injecting a sleep() somewhere?

tion drops significantly (much time spent waiting for I/O), the sleeping indeed might be needed. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Search for text in all tables

enough bits to be used for table number and field number. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Search for text in all tables

ine. Compare this to a quick hack that outputs all raw data from a specific database to a specific media. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

On Wed, Oct 22, 2014 at 4:50 PM, dave <d...@ziggurat29.com> wrote: > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org > > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Max Vlasov > > Sent: Wednesday, October 22, 2014 5:25 AM >

[sqlite] Is msvcrt coupling now unavoidable (3.8.7)?

eateThread. Or can sqlite introduce some define that makes vs run time coupled by default, but by disabling it, uses CreateThread api? Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

t(*) FROM (SELECT *,t1.FloatValue / t2.FloatValue as divvalue FROM TestTable T1 Join TestTable T2 where abs(divvalue - round(divvalue)) > 0.499 or (T1.IntValue * T2.IntValue) % 1789 = 56 or substr(t1.strvalue, 1 + t1.intvalue % 20, 1 + t2.intvalue % 20) = t2.strvalue) 1124 msec 952 msec Max __

Re: [sqlite] Latest Sqlite grammar as machine understandable file

On Fri, Feb 21, 2014 at 5:24 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Feb 21, 2014 at 7:29 AM, Max Vlasov <max.vla...@gmail.com> wrote: > >> Is there a machine-readable (BNF or other) grammar as equivalent to >> the current syntax diagrams? > > An upd

Re: [sqlite] WITHOUT ROWID option

; (1) You could send "SELECT rowid FROM table" > > (2) Run both "PRAGMA index_list(table)" > > Is there a way for a virtual table implementation to report that there's no rowid support before first xRowId call takes place? Max _

[sqlite] CTE in views for older versions

ence about such incompatibility. Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why sqlite has no sqlite_bind_auto or similary named function

On Fri, Apr 18, 2014 at 8:08 PM, Andy Goth <andrew.m.g...@gmail.com> wrote: > On 4/18/2014 12:29 AM, Max Vlasov wrote: >> >> So it seems like if general queries allow affinity automatical >> selection while bind api does not have the corresponent function. I >>

[sqlite] Why sqlite has no sqlite_bind_auto or similary named function

general queries use a similar function probably, making some kind of sqlite_bind_auto should be no big deal. But probably this decision was deliberate. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] about the apparently arriving soon "threads"

le drop. It all still depends on the application. Once I stopped believing a 2-threaded Atom would show x2 in any of tests I made, when on one graphical one it finally made it. But still if number of threads are bigger than number of cores then it's probably a legacy of HyperThreading

Re: [sqlite] comma-separated string data

pret estimatedCost equal to -1 as a ban to use this index. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Difference in virtual tables logic triggered between version 3.7.15.2 to 3.8.0

On Sat, Apr 5, 2014 at 11:48 PM, Max Vlasov <max.vla...@gmail.com> wrote: > > This works for an old version of sqlite (3.6.10), but today Dominique > Devienne mentioned some doubt about this approach and I decided to > test it with some data with a recent version of sql

Re: [sqlite] comma-separated string data

nything outside while still generating table data. So the data for the virtual table is actually supplied at the time of the query itself from WHERE clause. This trick successfully works with joins and everything else. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Goodram C50 SSD slow in SQlite benchmark

ta connection due physical and interface limitations of the interface. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using a customized collate function to mimic integer array type.

ap the head around, but this one allows using comma (or other symbols splitted) lists stored in fields even in joins. See my reply about it at https://www.mail-archive.com/sqlite-users@sqlite.org/msg63453.html. Max ___ sqlite-users mailing list sqlite-use

Re: [sqlite] which of these is faster?

On Fri, Mar 14, 2014 at 4:51 PM, Richard Hipp wrote: >> > In the original problem, there was already an index on the term for which > the min() was requested. >. > Whit your CTE-generated random integers, there is not an index on the > values. So "SELECT min(x) FROM..."

Re: [sqlite] which of these is faster?

tion of "order by limit 1" pattern redirecting it to linear search. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Observations about CTE optimization

) select val from testval where endmark=1 Time: 2 sec 900 ms. Explain query plan: "SCAN TABLE testval" "COMPOUND SUBQUERIES 0 AND 0 (UNION ALL)" "SCAN SUBQUERY 1" For the modified CTE sqrt from the other post the difference for 100,000 queries was 27 se

Re: [sqlite] Suggestion to add "locate" as a broader version of "instr"

h can be replaced by something else. I suspect ordering here triggers temporary storage. I tested this function as "expression function" implemented based on that thread and an average speed of this one is about 4000 sqrt operations / second on a mobile Intel i3. No

Re: [sqlite] RPAD/LPAD

On Sat, Mar 8, 2014 at 10:52 AM, Max Vlasov <max.vla...@gmail.com> wrote: > On Fri, Mar 7, 2014 at 11:51 PM, Dominique Devienne <ddevie...@gmail.com> > wrote: >> >> basically register_function('rpad', 'x', 'y', 'printf(''%-*s'', y, >> x)') would register a 2-ar

Re: [sqlite] RPAD/LPAD

t all binding variables mentioned in the expression, actually provided (example ... 'somefunc', 'x', 'y', ':x + :y + :z') Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] RPAD/LPAD

On Sat, Mar 8, 2014 at 2:16 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Eduardo Morras wrote: >> So, if a webapp that uses SQLite doesn't check it's input, functions that >> renames SQLite internals can be injected >> >> SELECT register_simp

Re: [sqlite] RPAD/LPAD

On Fri, Mar 7, 2014 at 6:39 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Max Vlasov wrote: >> >> Nice suggestion. This probably falls into case when a small new part >> needed on sqlite side > > Actually, no change to SQLite itself would be needed. It's

Re: [sqlite] RPAD/LPAD

ach, but would create a more universal solution. Just quick thoughts, probably there are plenty of obstacles here :) Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Virtual table API performance

and probably there are platform where compiled code for bind api and virtual tables api behaves a little differently making the costs more diffrent. But imagine that hard task of fine tuning and refactoring just to get a noticeable difference for a particular platform. Max ___

Re: [sqlite] Virtual table API performance

tion from this table and from virtual table. The virtual one took longer, but the values - 56 seconds vs 43 second not different enough to conclude something. I'm not sure my tests defend sqlite virtual tables sufficiently, but currently I don't have evidence of significant inefficiency either.

Re: [sqlite] Virtual Table "Functions"

pported and it was their own modified version of sqlite. Hope OP reads this post also and will have an answer for us. Probably this will help providing following information regarding his issues. Max ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Question about how sqlite recovers after a power loss

on is that journal file presence is not a mark to force database into some actions. It's rather a supplement for the error state of the base. So if the base is in error state and there's no journal file, it's bad. But reverse is ok and might appear with so

Re: [sqlite] Latest Sqlite grammar as machine understandable file

On Fri, Feb 21, 2014 at 5:24 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Feb 21, 2014 at 7:29 AM, Max Vlasov <max.vla...@gmail.com> wrote: > >> >> The only one a little similar I found is >> http://www.sqlite.org/docsrc/artifact/873cf35adf14cf3

Re: [sqlite] Latest Sqlite grammar as machine understandable file

On Fri, Feb 21, 2014 at 4:47 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Feb 21, 2014 at 7:29 AM, Max Vlasov <max.vla...@gmail.com> wrote: > >> Is there a machine-readable (BNF or other) grammar as equivalent to > > Not that I am aware of. > I just no

[sqlite] Latest Sqlite grammar as machine understandable file

pretty outdated (no CTE) Thanks Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Once again about random values appearance

On Mon, Feb 17, 2014 at 7:00 PM, RSmith <rsm...@rsweb.co.za> wrote: > > > On 2014/02/17 09:59, Max Vlasov wrote: >> >> . >> So >> >>Select nanosec() - nanosec() from ... >> >> returns non-zero values for most of the times, s

Re: [sqlite] Once again about random values appearance

On Mon, Feb 17, 2014 at 2:27 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 17 Feb 2014, at 7:59am, Max Vlasov <max.vla...@gmail.com> wrote: > > > So the nanosec example modified > > > > Select v-v from > > ( > > Select nanos

Re: [sqlite] Once again about random values appearance

On Mon, Feb 17, 2014 at 1:22 AM, James K. Lowden <jklow...@schemamania.org>wrote: > On Fri, 14 Feb 2014 08:32:02 +0400 > Max Vlasov <max.vla...@gmail.com> wrote: > > > From: Max Vlasov <max.vla...@gmail.com> > > To: General Discussion of SQLite Datab

[sqlite] Suggestion to add "locate" as a broader version of "instr"

tle bulky at last, but I managed to do "comma-list to dataset" query I suppose implementing "locate" and doing "instr" as a call to "locate" would cost the developers probably no more than a hundred of bytes for the final binary Thanks Max _

Re: [sqlite] Once again about random values appearance

d the rndid in outer query should have known (fixed) value and the values from where clause should be shown identical. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Once again about random values appearance

On Thu, Feb 13, 2014 at 4:26 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov <max.vla...@gmail.com> wrote: > > > Hi, > > > > probably was discussed and modified before, but I still can not > understand > >

[sqlite] Once again about random values appearance

.13 and 3.6.16, so .13 showed identical values, while .16 different. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

On Fri, Jan 24, 2014 at 9:16 PM, Ralf Junker <ralfjun...@gmx.de> wrote: > On 24.01.2014 10:06, Max Vlasov wrote: > >> BCC 5.5 (freely downloadable) compiles any version of sqlite3 to >> object files linkable to Delphi 5 and later, the only drawback I >> >>

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

lite and BDE may cost you performance penalties depending on the library you use. Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite as a platform performance comparison tool

is best handled with a single sqlite3_exec Is such comparision correct? So maybe even for memory-based operation there is something that makes this comparision invalid? Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Virtual Table: misuse error on sqlite3_declare_vtab()

Simon, don't know what exactly wrong in your particular case, but I'd suggest setting debugger breakpoints everywhere in your x-handlers and notice the moment after which calls are ceased (or you get a error code). Max On Fri, Oct 4, 2013 at 6:07 PM, Simon <turne...@gmail.com> wrote:

Re: [sqlite] Why latest places.sqlite from firefox can't be opened by some older versions of sqlite

On Sat, Aug 31, 2013 at 10:14 PM, Richard Hipp <d...@sqlite.org> wrote: > On Sat, Aug 31, 2013 at 2:03 PM, Max Vlasov <max.vla...@gmail.com> wrote: > >> Hi, >> >> I noticed that opening places.sqlite of my installation of Firefox >> can't be made for exa

  1   2   3   4   5   >