Re: [sqlite] New word to replace "serverless"

[Nataraj S Narayan]

Hi

How about recursive one like GNU?
Say, "SQLiteS/TL" exapanding to "Sqlite is Server Less/Thread Less"

Nataraj S Narayan

Richard Hipp writes:

> For many years I have described SQLite as being "serverless", as a way
> to distinguish it from the more traditional client/server design of
> RDBMSes.  "Serverless" seemed like the natural term to use, as it
> seems to mean "without a server".
>
> But more recently, "serverless" has become a popular buzz-word that
> means "managed by my hosting provider rather than by me."  Many
> readers have internalized this new marketing-driven meaning for
> "serverless" and are hence confused when they see my claim that
> "SQLite is serverless".
>
> How can I fix this?  What alternative word can I use in place of
> "serverless" to mean "without a server"?
>
> Note that "in-process" and "embedded" are not adequate substitutes for
> "serverless".  An RDBMS might be in-process or embedded but still be
> running a server in a separate thread. In fact, that is how most
> embedded RDBMSes other than SQLite work, if I am not much mistaken.
>
> When I say "serverless" I mean that the application invokes a
> function, that function performs some task on behalf of the
> application, then the function returns, *and that is all*.  No threads
> are left over, running in the background to do housekeeping.  The
> function does send messages to some other thread or process.  The
> function does not have an event loop.  The function does not have its
> own stack. The function (with its subfunctions) does all the work
> itself, using the callers stack, then returns control to the caller.
>
> So what do I call this, if I can no longer use the word "serverless"
> without confusing people?
>
> "no-server"?
> "sans-server"?
> "stackless"?
> "non-client/server"?


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

Re: [sqlite] undefined symbol: Tcl_TranslateFileName

[Nataraj S Narayan]

Ravi

Just curious. Why do ya need Tcl at all with Perl?
Ought to some advantage?

regards

Nataraj

On Wed, Nov 2, 2016 at 2:56 PM, ravi.shan...@cellworksgroup.com <
ravi.shan...@cellworksgroup.com> wrote:

> Hi guys,
>
> I am using a module called Tcl-1.05 in perl. But when i try to
> load a tclsqlite3.5.3.so file it throws an error like this.
>
> Module Name - Tcl-1.05
> Link :
> http://search.cpan.org/~vkon/Tcl-1.05/Tcl.pm
>
> Perl verison - 5.8.8
> Tcl version - 8.5
>
> The tclsqlite3.5.3.so file exists at the specified location. Need your
> suggestion.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is SQLite a DBMS?

[Nataraj S Narayan]

Gee...
I started out in late 80's as a Dbase III+ coder.
Then it was the defacto DBMS on the PC.
Wonder if it still relevant in any serious application in these days.

regards
Nataraj


On Mon, Sep 2, 2013 at 11:58 AM, Darren Duncan wrote:

> I don't think that being ACID and SQL compliant is the definition of a
> DBMS, far from it.  While it is true that typically anything which is ACID
> and SQL compliant is a DBMS, lots of things can be a DBMS without being
> either ACID or SQL compliant.  See dBASE for example. -- Darren Duncan
>
>
> On 2013.09.01 3:11 AM, Stefan Keller wrote:
>
>> Hi,
>>
>> Wikipedia answers with yes and why (= because it's ACID and SQL compliant)
>> within the first three sentences!
>> http://en.wikipedia.org/wiki/**SQLite
>>
>> Yours, S.
>>
>>
>> 2013/9/1 kimtiago 
>>
>>  Hi,
>>>
>>> I need to know if SQLite is a DBMS and why.
>>>
>>> Please its urgent.
>>>
>>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: Which version of SQLite?

[Nataraj S Narayan]

Hi dvn

What can be done with ruby I/O? Rewrite the code in assembly? I work
on Arm linux.
Does Ruby support the kind of stuff?

regards

Nataraj

On 12/16/11, Don V Nielsen <donvniel...@gmail.com> wrote:
> Ruby is awesome, especially when working with Sqlite...using ActiveRecord.
>  But its I/O is really slow, so propagating a database is not its thing.
>
> dvn
>
> On Wed, Dec 14, 2011 at 8:32 PM, Nataraj S Narayan
> <natara...@gmail.com>wrote:
>
>> Hi
>>
>> I am also an ex-clipper. I miss the old 'code blocks' days. I think
>> Ruby comes closest to Clipper with its own code blocks.
>>
>> regards
>>
>> Nataraj
>>
>> On Thu, Dec 15, 2011 at 7:17 AM, Jeff Matthews <j...@xexam.net> wrote:
>> >
>> >
>> > I want to use SQLite in a C# app I am developing.
>> >
>> >
>> >
>> > My database knowledge drops off around 1996, when I gave up Clipper
>> > programming.   I have since learned a little about some of the new
>> methods
>> > used by database gurus.  But I remember Clipper like it was yesterday
>> since
>> > I did so much of it.
>> >
>> >
>> >
>> > Here is a short snippet of the logic I recall using back when:
>> >
>> >
>> >
>> > Select (0)  //  Provides allocation for a new file handle for opening a
>> > database
>> >
>> > Use Customers   //  Will open Customers dbf, where in those days, each
>> table
>> > was its own file, and thus, we had multiple dbf files in an app to use
>> > relational data.
>> >
>> > Set Index to Phone, LastName  //  The indexes were also stored in
>> separate
>> > files.
>> >
>> > Set Order to 2  //  This would mean that our seeks would use the
>> > LastName
>> > index's sort order
>> >
>> >
>> >
>> > seek "MATTHEWS"  //   Try to find the first instance of search string in
>> the
>> > index and move record pointer to the row, or if not found, eof()
>> >
>> >
>> >
>> > numrecs=0
>> >
>> > if found();
>> >
>> >do while trim(upper(LastName))="MATTHEWS" .and. !eof()
>> //
>> > cycle through the records and stop if eof() is hit
>> >
>> >delete   // delete the entire row
>> >
>> >numrecs=numrecs+1
>> >
>> >skip  // go to next record
>> >
>> >enddo
>> >
>> > endif
>> >
>> > showMessage(ltrim(str(numrecs,0))+" records deleted.")
>> >
>> >
>> >
>> > That's it.
>> >
>> >
>> >
>> > I am not wanting to have to deal with excitingly new ways to do all
>> > this,
>> > such as DataSets or Entities, unless someone says, "But, you must!" or
>> > "You're crazy not to."
>> >
>> >
>> >
>> > So, which is the best SQLite download for me to use in C# using the
>> closest
>> > syntax and logic flow as set forth above?  I am ready to download and
>> start
>> > hacking.
>> >
>> >
>> >
>> > Thanks.
>> >
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: Which version of SQLite?

[Nataraj S Narayan]

Hi

I am also an ex-clipper. I miss the old 'code blocks' days. I think
Ruby comes closest to Clipper with its own code blocks.

regards

Nataraj

On Thu, Dec 15, 2011 at 7:17 AM, Jeff Matthews  wrote:
>
>
> I want to use SQLite in a C# app I am developing.
>
>
>
> My database knowledge drops off around 1996, when I gave up Clipper
> programming.   I have since learned a little about some of the new methods
> used by database gurus.  But I remember Clipper like it was yesterday since
> I did so much of it.
>
>
>
> Here is a short snippet of the logic I recall using back when:
>
>
>
> Select (0)  //  Provides allocation for a new file handle for opening a
> database
>
> Use Customers   //  Will open Customers dbf, where in those days, each table
> was its own file, and thus, we had multiple dbf files in an app to use
> relational data.
>
> Set Index to Phone, LastName  //  The indexes were also stored in separate
> files.
>
> Set Order to 2  //  This would mean that our seeks would use the LastName
> index's sort order
>
>
>
> seek "MATTHEWS"  //   Try to find the first instance of search string in the
> index and move record pointer to the row, or if not found, eof()
>
>
>
> numrecs=0
>
> if found();
>
>                do while trim(upper(LastName))="MATTHEWS" .and. !eof()   //
> cycle through the records and stop if eof() is hit
>
>                                delete   // delete the entire row
>
>                                numrecs=numrecs+1
>
>                                skip  // go to next record
>
>                enddo
>
> endif
>
> showMessage(ltrim(str(numrecs,0))+" records deleted.")
>
>
>
> That's it.
>
>
>
> I am not wanting to have to deal with excitingly new ways to do all this,
> such as DataSets or Entities, unless someone says, "But, you must!" or
> "You're crazy not to."
>
>
>
> So, which is the best SQLite download for me to use in C# using the closest
> syntax and logic flow as set forth above?  I am ready to download and start
> hacking.
>
>
>
> Thanks.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to get the Trigger's Raise err in Application

[Nataraj S Narayan]

Hi

The problem is solved after a recompile of QT with  options:-

-system-sqlite  -v -I//sqlite-3.6.17 -L//sqlite-3.6.17/.libs ,

whereas previously i had compiled sqlite as plugin.

Now the trigger message is caught promptly by :-

 sqlite3 *handle = *static_cast(v.data());
if (handle != 0)
{ // check that it is not NULL
qDebug("Error: %s", sqlite3_errmsg(handle));
QMessageBox::about(0,"Trigger",sqlite3_errmsg(handle));
}

regards

Nataraj

On Fri, Oct 30, 2009 at 6:50 PM, greensparker
 wrote:
>
> Jan,
>my system dont have any file named llibsqlite , in my filesystem
> but i have
>   /usr/lib/libsqlite.so
>   /usr/lib/libsqlite.so.0
>   /usr/lib/libsqlite.so.0.8.6
>   /usr/lib/libsqlite3.so
>   /usr/lib/libsqlite3.so.0.8.6
>
> my pro file have
>
> LIBS += /usr/lib/libsqlite.so
> INCLUDE +=/usr/include
> QT += sql
> HEADERS += mainMenu.h
> SOURCES += main.cpp \
>mainMenu.cpp
>
> And getting the following err
> mainMenu.o: In function `mainMenu::createMainMenu()':
> /home/bala/test1/mainMenu.cpp:69: undefined reference to `sqlite3_errmsg'
> collect2: ld returned 1 exit status
> make: *** [test] Error 1
>
>
> jan-118 wrote:
>>
>> afaik on unix you need this
>>
>> LIBS += -L/usr/lib -llibsqlite
>>
>>
>>
>> greensparker schrieb:
>>> Im in Debian Linux.,
>>> This is my pro file
>>>
>>> QT += sql
>>> LIBS +=/usr/lib/libsqlite.so
>>> INCLUDE +=/usr/include
>>> HEADERS += mainMenu.h
>>> SOURCES += main.cpp \
>>> mainMenu.cpp
>>>
>>> headers in my mainMenu.cpp file
>>>
>>> #include "mainMenu.h"
>>> #include 
>>> #include "DBConnection.h"
>>> #include// path = usr/local/include/sqlite3.h
>>>
>>> same err im getting
>>> :69: undefined reference to `sqlite3_errmsg'
>>> collect2: ld returned 1 exit status
>>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context: 
> http://old.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26129984.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite Qt problem

[Nataraj S Narayan]

Hi

I am using sqlite3 from Qt

have added a trigger to a table
i have setup an Abort  message in the trigger

My problem is that i am unable to get the message from a qt app, while
i am getting an exact message from Ruby language -

"db.execute( "insert into param_details (param_code,param_value)
values (?,?)",12,'786786')
SQLite3::SQLException: First Digit Should Be 9"


But in Qt

Getting "Error: library routine called out of sequence "

believe something wrong with at

sqlite3 *handle = *static_cast(v.data()); in


   1.
QString StrQuery = "insert into
PARAM_DETAILS(PARAM_CODE,PARAM_VALUE) values
   2.
  (12,'8443211326')";
   3.

   4.
  /* if(!(q5.exec(StrQuery)))
   5.
 {
   6.
   qDebug() << q5.lastError();
   7.
 }*/
   8.
if(!(q5.exec(StrQuery)))
   9.
  {
  10.
  QVariant v = q5.driver()->handle();
  11.

  12.
  if (v.isValid() && qstrcmp(v.typeName(), "sqlite3*")==0)
  13.
  {
  14.
  // v.data() returns a pointer to the handle
  15.
  sqlite3 *handle = *static_cast(v.data());
  16.
  if (handle != 0)
  17.
  { // check that it is not NULL
  18.
  qDebug("Error: %s", sqlite3_errmsg(handle));
  19.
  QMessageBox::about(0,"Hello",sqlite3_errmsg(handle));
  20.
  }
  21.
  }
  22.
  }

please help

regards

Nataraj
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem with inserting non NULL values into sqlite table

[Nataraj S Narayan]

Hi

How do I catch a error raised by a trigger from a programming language
like  C++ or freepascal?

Do we have a call back to do the same?

regards

Nataraj




On Thu, Oct 29, 2009 at 8:36 PM, T  wrote:
>
> hello everyone !
>
> I`m trying to use sqlite database with c++, but something isnt working
> right...
>
> The problem I`m dealing here is that i cant insert other datas into the
> table i`ve created except NULL, because i get following error message:
>
> Error in select statement : INSERT INTO a (a,b,c,d) VALUES (NULL, NULL,
> something_else, NULL) [no such column: something_else].
>
>
> when i write :
>
> insert(4, aa, "NULL", "NULL", "NULL");
>
> then NULL "values" are inserted
>
> I guess i`ve made some mistake with using pointers, but i dont see it.. I`m
> not very experienced programmer..
>
> here is the main function:
>
>
>
> int main ()
> {
>
> char data_base_name [20];
> char *db_name;
> db_name = data_base_name;
>
> char tab_name [20];
> table_name=tab_name;
>
> open_db ("db_name");
>
> cout<<"Insert table name:"< cin>>tab_name;
>
> char a[10]="a";
> char aa[100]="NULL";
>
> select_stmt ("DROP TABLE a");
>
> create_table (4, a, "b", "c", "d");
>
> insert(4, aa, "NULL", "something_else", "NULL");
>
> sqlite3_close(db);
>
> getchar ();
>
> return 0;
> }
>
>
>
>
>
>
> function create_table is working ok, if i`m not wrong..
> here it is:
>
>
>
>
> int create_table (int no_col, char *fmt, ...)
>
> {
> int i;
> char f[500] = "CREATE TABLE ";
>
> va_list ptr;
> va_start (ptr, fmt);
>for (i=0; i<(no_col-1); i++)
>{
>strcat (fmt, ",");// fmt = a ,b ,c ,d
>strcat(fmt, (va_arg (ptr, char*)));
>}
> va_end (ptr);
>
> fmt1 = fmt;   //fmt1- global pointer
>
> strcat (f, table_name);   // "CREATE TABLE x
> strcat (f, " ("); // "CREATE TABLE x "(
> strcat (f, fmt);  // "CREATE TABLE x ( a,b,c,d
> strcat (f,")");   // "CREATE TABLE x (a,b,c,d)"
>
> char * stmt = f  ;
> printf ("\nstmt = %s\n", stmt);
> select_stmt (stmt);
>
> return 0;
> }
>
>
>
>
>
>
> insert function:
>
>
>
>
> int insert (int no_col, char *fmt2, ... )
> {
> int i;
> va_list ap;
> va_start (ap, fmt2);
>
> for (i=0; i<(no_col-1); i++)
> {
>strcat (fmt2, ",");
>strcat (fmt2, (va_arg(ap, char*)));
> }
> va_end (ap);
>
> char k[500]= "INSERT INTO ";
> strcat (k, table_name );
> strcat (k, " ( ");
> strcat (k,  fmt1);
> strcat (k, ") ");
> strcat (k, "VALUES (");
> strcat (k, fmt2);
> strcat (k, ")");
> printf ("\nk = %s\n\n", k);
>
> char * stmt = k;
> select_stmt (stmt);
>
> return 0;
> }
>
>
>
>
>
>
>
> any help and auggestions very appreciated..
>
> T
>
>
>
>
>
>
>
>
> --
> View this message in context: 
> http://www.nabble.com/problem-with-inserting-non-NULL-values-into-sqlite-table-tp26114852p26114852.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users