Thanks a lot Clemens ! Thanks a lot :)
On Mon, Sep 21, 2015 at 2:58 PM, Clemens Ladisch wrote:
> Prakash Premkumar wrote:
> > Can you please tell me which grammar rule in parse.y file parses
> aggregate
> > function ?
>
> As you already were told, there are rules th
Thanks a lot for your reply Ambrus.
Can you please tell me which grammar rule in parse.y file parses aggregate
function ?
Thanks a lot for your time
Prakash
On Mon, Sep 21, 2015 at 2:07 PM, Zsb?n Ambrus wrote:
> On Mon, Sep 21, 2015 at 9:11 AM, Prakash Premkumar
> wrote:
> >
Hi,
I'm reading the sqlite parser grammar.
I could not find the grammar rules which parses aggregate functions like
MAX,MIN,SUM,COUNT,TOTAL.
Can you please tell me how the aggregate functions are parsed (the grammar
rule that parses them)
Thanks a lot for your time
Prakash
I tried with the following flags :
gcc -arch x86_64 -o sqlite3.o sqlite3.c shell.c
and
> gcc -m32 -o sqlite3.o sqlite3.c shell.c
but both results in the same error.
Can you please help me solve this ?
On Thu, Jul 2, 2015 at 2:47 PM, Andy Ling wrote:
> > I get the following error
Hi Andy,
I get the following error while trying to compile after linking with the
library
ld: warning: ignoring file
> /Users/prakash-2282/Downloads/sqlite-amalgamation-201506301510/libsqlite3.a,
> file was built for archive which is not the architecture being linked
> (x86_64):
>
Thanks a ton Andy for your reply.
can you specify how I should specify the include flags (-I).
The kore build complais that "sqlite3.h" header file is not found .
Thanks a lot for your time
On Thu, Jul 2, 2015 at 1:51 PM, Andy Ling wrote:
> > Can you please tell me how to compile it as a
please tell me how to compile it as a library on Mac OSX and Linux
platforms ?
On Wed, Jul 1, 2015 at 7:28 PM, Kees Nuyt wrote:
> On Wed, 1 Jul 2015 14:28:37 +0530, Prakash Premkumar
> wrote:
>
> >Hi,
> >
> >Can you please tell me how to compile sqlite as a lib
Hi,
Can you please tell me how to compile sqlite as a library and link with
other applications using the "-L" flag ?
Thanks a lot for your time .
Hello,
Can you please tell me how Sub queries in select are parsed ?
Can you please point out which rule in the parse.y file does the job of
parsing this ?
Thank you
Thanks a lot for your reply Simon. It was returning SQLITE_DONE. (But I
have checked for SQLITE_OK in my code). It's fixed now
Thank you
Prakash
On Tue, Dec 9, 2014 at 5:02 PM, Simon Davies <simon.james.dav...@gmail.com>
wrote:
> On 9 December 2014 at 10:56, Prakash Premkumar &
Hi,
I'm trying to use the sqlite_bind function calls to pass values to the
insert queries in sql.
Here's the code I'm trying to execute: http://pastebin.com/kMvAHsrk
I get an error after the sqlite3_step() function call :
The error message is "Unknown error".
Can you kindly help me fix this ?
The where clause in sqlite is encoded as a tree
Let's say I have select statement like :
SELECT * from employee where salary = 3+5*4+3;
The tree which takes care of operator precedence is :
=
/\
salary+
journaling mode is set, then the database file will very likely
> go corrupt. So you can go all the ways from no acid (data and journal in
> ram), to aci database (syncronous=normal) to fully acid. If you increase
> cache size enough you'll have the same as a "in memory" database
>
/overview.htm#TTCIN129
Does sqlite's in memory db have this feature ?
Thanks
Prakash
On Fri, Oct 17, 2014 at 11:54 AM, Prakash Premkumar <prakash.p...@gmail.com>
wrote:
> Is features like WAL (https://www.sqlite.org/wal.html) not available for
> in memory databases ?
>
> Thanks
&g
rg/wiki/DIMM>), where stored information is lost
> if
> the power is removed, although many efforts have been made to develop
> non-volatile RAM chips.
>
> Source: Wikipedia
> Il 17/ott/2014 11:48 "Prakash Premkumar" <prakash.p...@gmail.com> ha
> scritto:
>
> >
Prakash
On Fri, Oct 17, 2014 at 10:27 AM, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 10/17/2014 12:48 AM, Prakash Premkumar wrote:
>
>> Does in memory database in sqlite have journal files associated with it ?
>>
>
> No. The journal is in memory, too.
>
>
Hi,
Does in memory database in sqlite have journal files associated with it ?
If there's a system failure before an in memory database is backed up ?
Will there be data loss ? Or Can you kindly tell me how sqlite handles this
?
Thanks
Prakash
___
Hi,
>From what I understand from reading the followig doc:
http://www.sqlite.org/lockingv3.html
sqlite supports only file level locking.Is there any attempts to improve
the granularity of locking to table level or row level ?
Thanks a lot.
Prakash
lav...@bigfraud.org> wrote:
>
> On 16 Oct 2014, at 7:50am, Prakash Premkumar <prakash.p...@gmail.com>
> wrote:
>
> > Does sqlite implement the pointers in the System R Algorithm ?
>
> SQLite does not implement the System R Algorithm, so no, it doesn't
> implement the
Thanks a lot for your time.
Regards
Prakash
On Wed, Oct 15, 2014 at 5:36 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 15 Oct 2014, at 12:54pm, Prakash Premkumar <prakash.p...@gmail.com>
> wrote:
>
> > I'm trying to understand the sqlite select query optimi
Hi,
I'm trying to understand the sqlite select query optimizer. It works by
assigning costs to each relation in FROM clause. As far as I understand, it
primarily uses the logarithmic estimate of the number of rows in the
relation.
Query optimization algorithms like IBM System R algorithm assigns
Will I get any performance benefits if I directly generate the Vdbe program
instead of generating the sql string ?
My application emits out sql strings for execution. Instead if I generate
the Vdbe program myself , will I get performance benefits since, I am
bypassing the parser.
Thanks
Prakash
lue. I guess it is an index into a table of cursors required for
> processing the statement and there will be assertions to satisfy.
>
> -Ursprüngliche Nachricht-
> Von: Prakash Premkumar [mailto:prakash.p...@gmail.com]
> Gesendet: Montag, 06. Oktober 2014 11:59
> An: General
Hi,
struct SrcList has a field int iCursor, if I'm manually filling up this
struct ,can I assign any integral value to iCursor,so that this value can
be used by OpenRead or OpenReadWrite opcode when it accesses this
particular table ?
Thanks
Prakash
Hi,
Instead of generating an sql query for a select statement, I would like to
bypass the parser and fill in struct Select by myself based on the data I
have and Pass it to sqlite3Select() function. Can you please give me some
pointers in this direction ?
I think eliminating parsing would be an
Thanks a lot Clemens
Regards
Prakash
On Sun, Oct 5, 2014 at 2:56 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Prakash Premkumar wrote:
> > On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt <k.n...@zonnet.nl> wrote:
> >> On Fri, 3 Oct 2014 18:39:29 +0530, Pra
Thanks a lot for your reply Kees, sqlite3_prepare calls other functions,
can you kindly tell me which is the exact function that does the conversion
?
Thanks
Prakash
On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt <k.n...@zonnet.nl> wrote:
> On Fri, 3 Oct 2014 18:39:29 +0530, Prakash
Can you please tell me which function is sqlite actually generates the Vdbe
program for a give sql string ?
Thanks
Prakash
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
QLite Api as intended and works
> first?
>
> -Ursprüngliche Nachricht-----
> Von: Prakash Premkumar [mailto:prakash.p...@gmail.com]
> Gesendet: Mittwoch, 24. September 2014 12:54
> An: General Discussion of SQLite Database
> Betreff: Re: [sqlite] Results of Joins in sqlite
>
>
t2 where t2.rowid=?;
> SELECT <...t3 fields> FROM t3 where t3.rowid=?;
>
>
>
> -Ursprüngliche Nachricht-
> Von: Prakash Premkumar [mailto:prakash.p...@gmail.com]
> Gesendet: Mittwoch, 24. September 2014 09:32
> An: General Discussion of SQLite Database
> Betreff:
rows(one pointer per row).
The end data structure will look like a graph.
I want the API to return this graph./ is there an alternative ?
API call : graph* sqlite3_join(select_stmt*)
Thanks
Prakash
On Wed, Sep 24, 2014 at 12:45 PM, Clemens Ladisch <clem...@ladisch.de>
wrote:
> Prakash
which table.
Thanks
Prakash
On Wed, Sep 24, 2014 at 11:03 AM, Prakash Premkumar <prakash.p...@gmail.com>
wrote:
> Hi,
>
> Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining
> them.
> The result rows will have 8 columns each.
>
> Let's say an out
Hi,
Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining
them.
The result rows will have 8 columns each.
Let's say an output of the join is:
r11,r21,r31
r11,r21,r32
r11,r21,r33
where r1i is the i th row in T1, r2i is the i th row in T2 and r3i is the
ith row in T3:
sqlite
s then maybe that is
> an indication that you really need to change the approach or acquire a
> different tool. Maybe you are trying to nail it with a set of pliers.
> Doable, but not as neat as using a hammer in the first place, and also hard
> on the pliers.
>
> -Ursprüngliche Nachricht
ying to implement "stored procedures"?
>
> -Ursprüngliche Nachricht-
> Von: Prakash Premkumar [mailto:prakash.p...@gmail.com]
> Gesendet: Montag, 22. September 2014 15:37
> An: General Discussion of SQLite Database
> Betreff: [sqlite] Expose struct Mem and struct Vdbe to other
Hi,
Let's assume I am writing a c code which directly invokes the sqlite_step
statement.
After the execution of the statement, I would like to access the pResultRow
of Vdbe (which obtained by pVbe = (Vdbe*) pStmt ).
How can I expose the struct Vdbe,Mem and the likes to external applications.
Thanks Clemens and hick
On 22 Sep 2014 14:22, "Clemens Ladisch" <clem...@ladisch.de> wrote:
> Prakash Premkumar wrote:
> > Can you please tell me where is the definition of the struct
> sqlite3_stmt ?
>
> There is no definition of struct sqlite3
Hi,
Can you please tell me where is the definition of the struct sqlite3_stmt ?
A search in sqlite3.c yields on the typedef statement of the struct ,
typedef struct sqlite3_stmt sqlite3_stmt;
Thanks for your help.
___
sqlite-users mailing list
Can you kindly tell me where in the source code is the number of registers
for Vdbe allocated ?
Thanks
Prakash
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks a lot Richard for your help. I apologize for not including the
script. I will make it a point to add the scripts from hereon.
On Fri, Sep 19, 2014 at 10:30 AM, Richard Hipp wrote:
> You start by presenting us with a stand-alone script that we can run to see
> your
The schema is as follows :
create table employee (name text,age int);
create table location (name text,addr text);
create table company (name text,cname text);
Thanks
On Fri, Sep 19, 2014 at 10:13 AM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Sep 19, 2014 at 12:35 AM, Prakash
The opcode I'm interested in is
10 column 2 1 3 00
On 19 Sep 2014 10:11, "Richard Hipp" <d...@sqlite.org> wrote:
> On Fri, Sep 19, 2014 at 12:35 AM, Prakash Premkumar <
> prakash.p...@gmail.com>
> wrote:
>
> > Let's take this example
> >
> > e
machine remember this allocation ?
Thanks for your help
On Fri, Sep 19, 2014 at 9:46 AM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Sep 19, 2014 at 12:10 AM, Prakash Premkumar <
> prakash.p...@gmail.com>
> wrote:
>
> > Thanks for your reply. I would like to kn
Thanks for your reply. I would like to know how the register allocation
decision is made and the part of the code which does it . can you please
help me find that? Thanks
On 18 Sep 2014 20:20, "Richard Hipp" <d...@sqlite.org> wrote:
> On Thu, Sep 18, 2014 at 10:10 AM
?
Can you point me to the portion of the source code which makes this
decision?
Can you kindly explain me the concept?
Thanks for you help.
Regards,
Prakash Premkumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
Hi,
Can you please tell me which function/set of functions convert the SQL
query to Vdbe program ?
Thanks
Prakash
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
How do I set the sqlite compile time option SQLITE_DEBUG ?
Can you please specify how I should set it in the command line ?
Thanks
Prakash
___
sqlite-users mailing list
sqlite-users@sqlite.org
47 matches
Mail list logo