Re: [sqlite] Best way to develop a GUI front-end

[J Decker]

On Tue, Nov 14, 2017 at 8:14 PM, jungle boogie 
wrote:

> Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800
>
>> I'll throw my 2 cents in...
>>
>> A Node.js server, and use a web frontend, or electron/nwjs which are
>> browsers that include node, and can be standalone apps.
>>
>>
> Funny you should mention that. I've been looking at node.js and curious
> how sqlite would be implemented. Can you recommend a npm package for it?
> Have you implemented something in node with sqlite?
>
> I use my own package ... sqlite is available in
https://www.npmjs.com/package/sack.vfs#sqlite-interface with a very simple
interface. no promises callbacks or other complications.


> This one is quite active on github and on the npmjs site:
> https://github.com/sequelize/sequelize
>
> Initially I was interested in tcl/tk, and still am, but I'm not sure about
> the tcl/tk packaging that would be necessary to make use on multiple
> computers. Also, I don't know how network database connections would work
> out, would it be the same as web based stuff or more complicated, etc.
>
>
> Thanks,
> j.b.
>
> ___
> 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] Best way to develop a GUI front-end

[Simon Slavin]

On 15 Nov 2017, at 4:14am, jungle boogie  wrote:

> Funny you should mention that. I've been looking at node.js and curious how 
> sqlite would be implemented. Can you recommend a npm package for it?

SQLite is implemented as promises, allowing it to be programmed as if the 
commands are being executed asynchronously.





If you aren’t already used to programming with sqlite3, try the "better:=" one.

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

Re: [sqlite] Best way to develop a GUI front-end

[jungle boogie]

Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800

I'll throw my 2 cents in...

A Node.js server, and use a web frontend, or electron/nwjs which are
browsers that include node, and can be standalone apps.



Funny you should mention that. I've been looking at node.js and curious 
how sqlite would be implemented. Can you recommend a npm package for it?

Have you implemented something in node with sqlite?

This one is quite active on github and on the npmjs site:
https://github.com/sequelize/sequelize

Initially I was interested in tcl/tk, and still am, but I'm not sure 
about the tcl/tk packaging that would be necessary to make use on 
multiple computers. Also, I don't know how network database connections 
would work out, would it be the same as web based stuff or more 
complicated, etc.



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

Re: [sqlite] Best way to develop a GUI front-end

[Igor Korot]

Hi,
Did you look at wxPython (or wxPhoenix)?
It was recenty saw a new release..
Thank you.

On Tue, Nov 14, 2017 at 3:39 PM, Peter Da Silva
 wrote:
> On 11/14/17, 3:33 PM, "sqlite-users on behalf of Balaji Ramanathan" 
>  balaji.ramanat...@gmail.com> wrote:
>> I am leaning towards tcl/tk given the endorsement from both Peter and DRH. 
>> So, I downloaded tcl/tk version 8.6.7 from magicsplat 
>> (http://www.magicsplat.com/tcl-installer/index.html), and then ran 
>> tclsh.exe.  In the resulting command window, I typed "sqlite3 db1 > my sqlite database" as instructed on this page on the sqlite website: 
>> https://sqlite.org/tclsqlite.html .  And all I got was "invalid command name 
>> sqlite3".  So, I am stuck.  What did I do wrong?
>
> % package require sqlite3
> 3.20.1
> % sqlite3 db1 :memory:
> %
>
>> BTW, the www.tcl-lang.org website has been down for at least the past 3 days 
>> it looks like.  Not sure how to interpret the reliability of a technology 
>> whose home website is down for days at a time.
>
> Try https://www.tcl.tk/ ?
>
> ___
> 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] Best way to develop a GUI front-end

[Peter Da Silva]

On 11/14/17, 3:33 PM, "sqlite-users on behalf of Balaji Ramanathan" 
 wrote:
> I am leaning towards tcl/tk given the endorsement from both Peter and DRH. 
> So, I downloaded tcl/tk version 8.6.7 from magicsplat 
> (http://www.magicsplat.com/tcl-installer/index.html), and then ran tclsh.exe. 
>  In the resulting command window, I typed "sqlite3 db1  database" as instructed on this page on the sqlite website: 
> https://sqlite.org/tclsqlite.html .  And all I got was "invalid command name 
> sqlite3".  So, I am stuck.  What did I do wrong?

% package require sqlite3
3.20.1
% sqlite3 db1 :memory:
%

> BTW, the www.tcl-lang.org website has been down for at least the past 3 days 
> it looks like.  Not sure how to interpret the reliability of a technology 
> whose home website is down for days at a time.

Try https://www.tcl.tk/ ? 

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

Re: [sqlite] Best way to develop a GUI front-end

[J Decker]

I'll throw my 2 cents in...

A Node.js server, and use a web frontend, or electron/nwjs which are
browsers that include node, and can be standalone apps.

On Tue, Nov 14, 2017 at 1:33 PM, Balaji Ramanathan <
balaji.ramanat...@gmail.com> wrote:

> Thank you everyone for your suggestions.
>
> Looked at Xojo.  Not sure if the free version will stick around.  And there
> is no way to save and reuse reports from one session to another in the free
> version.  Creating and recreating the report every time is going to become
> tedious very soon.
>
> Continuing to use Access as a front end and connecting to my db using odbc
> is definitely an option.  I wanted to move away fully from Access, so I am
> going to keep that as a backup option.
>
> I am leaning towards tcl/tk given the endorsement from both Peter and DRH.
> So, I downloaded tcl/tk version 8.6.7 from magicsplat (
> http://www.magicsplat.com/tcl-installer/index.html), and then ran
> tclsh.exe.  In the resulting command window, I typed "sqlite3 db1  my sqlite database" as instructed on this page on the sqlite website:
> https://sqlite.org/tclsqlite.html .  And all I got was "invalid command
> name sqlite3".  So, I am stuck.  What did I do wrong?
>
> BTW, the www.tcl-lang.org website has been down for at least the past 3
> days it looks like.  Not sure how to interpret the reliability of a
> technology whose home website is down for days at a time.
>
> Balaji Ramanathan
>
> On Tue, Nov 14, 2017 at 6:00 AM, <
> sqlite-users-requ...@mailinglists.sqlite.org> wrote:
>
> >
> > -- Forwarded message --
> > From: Peter Da Silva 
> > To: SQLite mailing list 
> > Cc:
> > Bcc:
> > Date: Mon, 13 Nov 2017 22:03:34 +
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> > Since sqlite originated as a Tcl extension it’s got excellent Tcl
> > bindings, and Tcl has an excellent platform-independent GUI in Tk, so it
> > seems to me that would be the best and simplest way to create a GUI front
> > end for sqlite.
> >
> >
> >
> > -- Forwarded message --
> > From: Richard Hipp 
> > To: SQLite mailing list 
> > Cc:
> > Bcc:
> > Date: Mon, 13 Nov 2017 17:06:20 -0500
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> > On 11/13/17, Peter Da Silva  wrote:
> > > Since sqlite originated as a Tcl extension it’s got excellent Tcl
> > bindings,
> > > and Tcl has an excellent platform-independent GUI in Tk, so it seems to
> > me
> > > that would be the best and simplest way to create a GUI front end for
> > > sqlite.
> >
> > +1
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> >
> >
> >
> > -- Forwarded message --
> > From: Tim Streater 
> > To: SQLite mailing list 
> > Cc:
> > Bcc:
> > Date: Mon, 13 Nov 2017 22:22:29 +
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> > On 13 Nov 2017, at 21:54, Balaji Ramanathan  >
> > wrote:
> >
> > > Is there a third party free tool like MS Access that would allow me
> > to
> > > connect to a SQLite db in the back-end and enable me to create a custom
> > > front-end to it with forms and reports?  All my searches for this kind
> of
> > > tool only lead me to tools like SqliteStudio, which is a GUI front end
> > for
> > > SQLite, but not a programmable one like I want.  If anyone can point me
> > > towards a programmable GUI front-end development tool (preferrably
> > > open-source, but just free and well-maintained is sufficient), I would
> > > appreciate it greatly.
> >
> > There is Xojo (www.xojo.com) which has SQLite built in and has reports
> > (which I have never used). It's cross-platform and you create your own
> GUI
> > front end with windows, buttons etc. It's free to use for development,
> but
> > if you want to compile and build a stand-alone application (.exe or .app)
> > then you buy a licence. There is a Lite licence to build for one platform
> > which is not a high cost.
> >
> >
> >
> > --
> > Cheers  --  Tim
> >
> >
> > -- Forwarded message --
> > From: Bart Smissaert 
> > To: SQLite mailing list 
> > Cc:
> > Bcc:
> > Date: Mon, 13 Nov 2017 23:52:18 +
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> > As you are familiar with VBA I can see two other options:
> >
> > 1. Use Christian Werner's ODBC driver from Access (or Excel):
> > http://www.ch-werner.de/sqliteodbc/
> >
> > 2. Use Olaf Schmidt's COM dll with Access (or Excel):
> > http://www.vbrichclient.com/#/en/About/
> >
> > RBS
> >
> >
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

Re: [sqlite] Best way to develop a GUI front-end

[Balaji Ramanathan]

Thank you everyone for your suggestions.

Looked at Xojo.  Not sure if the free version will stick around.  And there
is no way to save and reuse reports from one session to another in the free
version.  Creating and recreating the report every time is going to become
tedious very soon.

Continuing to use Access as a front end and connecting to my db using odbc
is definitely an option.  I wanted to move away fully from Access, so I am
going to keep that as a backup option.

I am leaning towards tcl/tk given the endorsement from both Peter and DRH.
So, I downloaded tcl/tk version 8.6.7 from magicsplat (
http://www.magicsplat.com/tcl-installer/index.html), and then ran
tclsh.exe.  In the resulting command window, I typed "sqlite3 db1 https://sqlite.org/tclsqlite.html .  And all I got was "invalid command
name sqlite3".  So, I am stuck.  What did I do wrong?

BTW, the www.tcl-lang.org website has been down for at least the past 3
days it looks like.  Not sure how to interpret the reliability of a
technology whose home website is down for days at a time.

Balaji Ramanathan

On Tue, Nov 14, 2017 at 6:00 AM, <
sqlite-users-requ...@mailinglists.sqlite.org> wrote:

>
> -- Forwarded message --
> From: Peter Da Silva 
> To: SQLite mailing list 
> Cc:
> Bcc:
> Date: Mon, 13 Nov 2017 22:03:34 +
> Subject: Re: [sqlite] Best way to develop a GUI front-end
> Since sqlite originated as a Tcl extension it’s got excellent Tcl
> bindings, and Tcl has an excellent platform-independent GUI in Tk, so it
> seems to me that would be the best and simplest way to create a GUI front
> end for sqlite.
>
>
>
> -- Forwarded message --
> From: Richard Hipp 
> To: SQLite mailing list 
> Cc:
> Bcc:
> Date: Mon, 13 Nov 2017 17:06:20 -0500
> Subject: Re: [sqlite] Best way to develop a GUI front-end
> On 11/13/17, Peter Da Silva  wrote:
> > Since sqlite originated as a Tcl extension it’s got excellent Tcl
> bindings,
> > and Tcl has an excellent platform-independent GUI in Tk, so it seems to
> me
> > that would be the best and simplest way to create a GUI front end for
> > sqlite.
>
> +1
>
> --
> D. Richard Hipp
> d...@sqlite.org
>
>
>
> -- Forwarded message --
> From: Tim Streater 
> To: SQLite mailing list 
> Cc:
> Bcc:
> Date: Mon, 13 Nov 2017 22:22:29 +
> Subject: Re: [sqlite] Best way to develop a GUI front-end
> On 13 Nov 2017, at 21:54, Balaji Ramanathan 
> wrote:
>
> > Is there a third party free tool like MS Access that would allow me
> to
> > connect to a SQLite db in the back-end and enable me to create a custom
> > front-end to it with forms and reports?  All my searches for this kind of
> > tool only lead me to tools like SqliteStudio, which is a GUI front end
> for
> > SQLite, but not a programmable one like I want.  If anyone can point me
> > towards a programmable GUI front-end development tool (preferrably
> > open-source, but just free and well-maintained is sufficient), I would
> > appreciate it greatly.
>
> There is Xojo (www.xojo.com) which has SQLite built in and has reports
> (which I have never used). It's cross-platform and you create your own GUI
> front end with windows, buttons etc. It's free to use for development, but
> if you want to compile and build a stand-alone application (.exe or .app)
> then you buy a licence. There is a Lite licence to build for one platform
> which is not a high cost.
>
>
>
> --
> Cheers  --  Tim
>
>
> -- Forwarded message --
> From: Bart Smissaert 
> To: SQLite mailing list 
> Cc:
> Bcc:
> Date: Mon, 13 Nov 2017 23:52:18 +
> Subject: Re: [sqlite] Best way to develop a GUI front-end
> As you are familiar with VBA I can see two other options:
>
> 1. Use Christian Werner's ODBC driver from Access (or Excel):
> http://www.ch-werner.de/sqliteodbc/
>
> 2. Use Olaf Schmidt's COM dll with Access (or Excel):
> http://www.vbrichclient.com/#/en/About/
>
> RBS
>
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 119, Issue 14

[Balaji Ramanathan]

Very interesting.  Thank you David.  I have never used a recursive CTE
before, so I am still trying to understand exactly how it works.  But it
does work, so I will definitely take a closer look.  Thank you.

Balaji Ramanathan

On Tue, Nov 14, 2017 at 6:00 AM, <
sqlite-users-requ...@mailinglists.sqlite.org> wrote:

> -- Forwarded message --
> From: David Raymond 
> To: SQLite mailing list 
> Cc:
> Bcc:
> Date: Mon, 13 Nov 2017 17:20:58 +
> Subject: Re: [sqlite] Running sums and averages
> As other folks have mentioned, doing it in an external language is going
> to be easiest.
>
> That being said, CTE's are almost a full language in themselves.
>
> I'm just gonna go with 1 value here for the example, but how about
> something like...
>
> with recursive foo (RowNumber, F1, sumF1, OverallAvgF1, avgF1, F1notNull)
> as(
>   select
>   rowNumber,
>   F1,
>   ifnull(F1, 0.0),
>   ifnull(F1, 0.0),
>   ifnull(F1, 0.0),
>   F1 is not null
>   from mytable where RowNumber = 1
>
>   union all
>
>   select
>   mytable.RowNumber,
>   mytable.F1,
>   foo.sumF1 + ifnull(mytable.F1, 0.0),
>   (foo.sumF1 + ifnull(mytable.F1, 0.0)) / mytable.RowNumber,
>   (foo.sumF1 + ifnull(mytable.F1, 0.0)) / (foo.F1notNull + (mytable.F1 is
> not null)),
>   foo.F1notNull + (mytable.F1 is not null)
>
>   from
>
>   foo inner join mytable on mytable.RowNumber = foo.RowNumber + 1)
>
> select RowNumber, F1, sumF1, OverallAvgF1, avgF1 from foo;
>
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 1TB limit on encrypted database

[Richard Hipp]

On 11/14/17, Andrew Stewart  wrote:
> Richard,
> If I am trying to change the max_page_count use the SEE.EXE program,
> how do I get the value to be updated in the database.  Every time I try
> changing this and then exit see.exe, the value has not changed.  Do I need
> the updated encryption extension first?

The PRAGMA only changes the one database connection in which it runs.

To make the setting persistent, recompile with
-DSQLITE_MAX_PAGE_COUNT=20

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

Re: [sqlite] 1TB limit on encrypted database

[Andrew Stewart]

Richard,
If I am trying to change the max_page_count use the SEE.EXE program, 
how do I get the value to be updated in the database.  Every time I try 
changing this and then exit see.exe, the value has not changed.  Do I need the 
updated encryption extension first?

Andrew Stewart
Argus Control Systems Ltd.

-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Richard Hipp
Sent: Tuesday, November 14, 2017 11:33 AM
To: SQLite mailing list 
Subject: Re: [sqlite] 1TB limit on encrypted database

On 11/14/17, Andrew Stewart  wrote:
> Hi,
> I appear to have reached an issue with a 1TB limit on
> an encrypted database.  The page_size is 1024.  The max_page_count is
> 1073741823.  I don't appear to be able to change either of these numbers.
> Any assistance would be appreciated.

You can try:

   PRAGMA max_page_count=20;

Probably you should also look into increasing the page size:

   PRAGMA page_size=8192;
   VACUUM;

For that last step, make sure you have upgraded to a recent version of the 
encryption extension as some of the older versions had issues.
Also, note that the VACUUM will take some time and will require a couple TB of 
temporary disk space while it is running.

--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Notice: This electronic transmission contains confidential information, 
intended only for the person(s) named above. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or any other use of this email is strictly prohibited. If you have received 
this transmission by error, please notify us immediately by return email and 
destroy the original transmission immediately and all copies thereof.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 1TB limit on encrypted database

[Richard Hipp]

On 11/14/17, Andrew Stewart  wrote:
> Hi,
> I appear to have reached an issue with a 1TB limit on an
> encrypted database.  The page_size is 1024.  The max_page_count is
> 1073741823.  I don't appear to be able to change either of these numbers.
> Any assistance would be appreciated.

You can try:

   PRAGMA max_page_count=20;

Probably you should also look into increasing the page size:

   PRAGMA page_size=8192;
   VACUUM;

For that last step, make sure you have upgraded to a recent version of
the encryption extension as some of the older versions had issues.
Also, note that the VACUUM will take some time and will require a
couple TB of temporary disk space while it is running.

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

[sqlite] 1TB limit on encrypted database

[Andrew Stewart]

Hi,
I appear to have reached an issue with a 1TB limit on an 
encrypted database.  The page_size is 1024.  The max_page_count is 1073741823.  
I don't appear to be able to change either of these numbers.  Any assistance 
would be appreciated.

Andrew Stewart
Argus Control Systems Ltd.

Notice: This electronic transmission contains confidential information, 
intended only for the person(s) named above. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or any other use of this email is strictly prohibited. If you have received 
this transmission by error, please notify us immediately by return email and 
destroy the original transmission immediately and all copies thereof.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to develop a GUI front-end

[dmp]

> Date: Mon, 13 Nov 2017 15:54:42 -0600
> From: Balaji Ramanathan 
> To: sqlite-users@mailinglists.sqlite.org
> Subject: [sqlite] Best way to develop a GUI front-end
>
> Hi,
>
> I have been using SQLite without any programming language so far.  I
> maintain the data in 
> ~
> ~
> ~
> Is there a third party free tool like MS Access that would allow me to
> connect to a SQLite db in the back-end and enable me to create a custom
> front-end to it with forms and reports?  All my searches for this kind of
>  tool only lead me to tools like SqliteStudio, which is a GUI front end
> for SQLite, but not a programmable one like I want.  If anyone can point
> me towards a programmable GUI front-end development tool (preferrably
> open-source, but just free and well-maintained is sufficient), I would
> appreciate it greatly.
>
> Thank you very much.
> Balaji Ramanathan

Hello,

I have several times posted, indicating the release of my database GUI,
Ajqvue. It is a well maintained, mature open source project that was
started in 2005 then renamed in 2016, because of a cease-desist from
Oracle.

The project language is in Java and was started on Sourceforge and is
now hosted on GitHub.

https://github.com/danap/ajqvue

Ajqvue is a framework that so happens to have as its main plugin a
database interface. The interface is more in line with a spreadsheet
application rather than a tree db/table selector display, with a manual
query entry form. The database interface is JDBC, which most of the
databases have available. For SQLite I have been using:

https://github.com/xerial/sqlite-jdbc

Ajqvue comes with several additional plugins for analysis, and plotting.
I believe the most versatile aspect of Ajqvue though is the ability
through the Query Bucket to save composed SQL queries. Those queries
can then be dragged/dropped into plugins to allow data processing.

A plugin of a custom form should be relatively easy to create if you
know Java. There is a tutorial available on the documentation page
of the site along with videos demonstrating the desktop application.
Once a plugin is created it can be sourced locally, LAN, or on the
Internet.

If you do create a plugin GUI I recommend Swing over JavaFX. I have
had issues on various, Linux platforms with JavaFX and just switched
the charting plugin from JavaFX to JFreeChart.

Dana Proctor
Ajqvue Project Manager
http://ajqvue.com


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

Re: [sqlite] Simple Search using LIKE or something else

[Stephen Chrzanowski]

Thanks Warren.  I'll bookmark this and have a read over it maybe this
weekend.  (Busy work week, and I'd just rather chill with Factorio,
The Crew, or some other thing that lowers the stress. :] )

On Tue, Nov 14, 2017 at 10:58 AM, Warren Young  wrote:
> On Nov 13, 2017, at 3:26 PM, Stephen Chrzanowski  wrote:
>>
>> I'm not using a C compiler.
>
> This article appears to sort that out:
>
> http://rvelthuis.de/articles/articles-cobjs.html
>
> Basically, you download the free CLI-only version of the C++Builder Berlin 
> compiler, build sqlite3.c to sqlite3.obj — possibly along with other C code 
> of your own, plus extensions — and then link that into your Delphi project 
> using the instructions provided.
>
> Then no worries about random DLLs floating around.
> ___
> 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] Best way to develop a GUI front-end

[Warren Young]

On Nov 13, 2017, at 2:54 PM, Balaji Ramanathan  
wrote:
> 
> In the past, I have maintained my data in an Access database

That’s the sort of application that the open source world just is not very good 
at recreating.  F/OSS people hear “database” and think SQLite or Postgres or 
MySQL, which is not at all the same thing as Access or FileMaker Pro.  The 
F/OSS world is disproportionately populated by developers; they think, “why 
would I want a GUI builder and a simplified scripting engine for a database?”

Yes, I’m painting with broad strokes here.  I’ve written multiple 
database-based applications in the past using both the F/OSS DBMSes listed 
above and FileMaker Pro *and* ye olde Borland Paradox.  I think there’s a place 
for both kinds of “database,” but the F/OSS world doesn’t seem to want to spend 
many resources on the latter sort.

I’ve just done some Googling, and have come up with two poor alternatives:

   http://kexi-project.org/
   https://www.libreoffice.org/discover/base/

The primary problem with Kexi is that it’s tied into KDE, and hence isn’t 
easily portable to Windows and macOS.  You have to port over huge chunks of KDE 
to get it to work, so few people bother, hence the ports wither and die.  So, 
if you can run on Linux or run a Linux VM on your host, it may do fine for you. 
 Otherwise, you probably can’t use it.

The primary problem with Base is that it’s Java-based, which means it only 
works with the embedded Java HSQLDB library or with DBMSes it can connect to 
externally via client-server APIs or shims like JBDC and ODBC.  That makes it 
difficult to use with SQLite.  Not impossible, but certainly not as easy as, 
say, MySQL.  It’s probably your best bet if you want something like Access for 
free (both senses) and can give up on the SQLite requirement.

>I am familiar with programming in C and Java, but none of my
> programming has been for the windows platform (except for the programming
> inside MS Access, which was done in VBA).  I have never developed GUI front
> ends with forms, buttons, etc.

The others’ recommendations for Tcl/Tk isn’t too bad.  Tk is uncommonly easy to 
write GUIs with.  The only easier *programmatic* method for building a GUI is 
HTML and its imitators.  (Adobe Flex, Microsoft XAML, etc.)

The main problem with Tk GUIs is that they tend not to look “native,” even if 
you use the new “themed Tk” widgets available since Tk 8.5: 

http://www.tkdocs.com/resources/backgrounder.html

Additionally, Tcl is a brain-bender of a language.  It is not much like any 
other programming language.  It’s vaguely like a Lisp-flavored C shell, but it 
takes an experienced eye to make even that tenuous connection.  Expect a 
learning curve.

I’m glad I learned Tcl, long ago, because it broke my mold of what a 
programming language had to be.  It’s therefore worth doing even if you never 
touch Tcl again after learning it.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to develop a GUI front-end

[Drago, William @ CSG - NARDA-MITEQ]

> > This will work with any .NET/Visual Studio language (C#/F#/VB):
>
> Not sure this will work with VBA though.
> VB .NET is very different from VBA (or VB6), so that won't be that easy,
> unless I am missing something.
>
> RBS

It's not that hard to go from VBA to VB .NET. The part I failed to explain is 
that is does require a transition from one to the other.

-Bill
CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient and may contain material that is proprietary, 
confidential, privileged or otherwise legally protected or restricted under 
applicable government laws. Any review, disclosure, distributing or other use 
without expressed permission of the sender is strictly prohibited. If you are 
not the intended recipient, please contact the sender and delete all copies 
without reading, printing, or saving.

Beginning April 1, 2018, L3 Technologies, Inc. will discontinue the use of all 
@L-3Com.com email addresses. To ensure delivery of your messages to this 
recipient, please update your records to use william.dr...@l3t.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Error: ambiguous column name

[Hick Gunter]

A bare field name is legal in SQL only when it is unique; otherwise it needs to 
be qualified by table name or table alias. In a self join, the table name is 
identical, so using aliases is mandatory.

Result column names are not well defined in the SQL standard (apart from the 
use of the AS clause in the SELECT list), but most SQL engines will attempt to 
use something from either the SELECT statement itself (e.g. the text of an 
expression), or the table declaration. Result column names are not required to 
be unique, nor are they guranteed not to change between releases of the 
underlying SQL engine.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Rob Golsteijn
Gesendet: Dienstag, 14. November 2017 16:38
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] Error: ambiguous column name

Hi List,



Given a table created as:   create table aaa(a);

Sqlite reports an error "ambiguous column name: main.aaa.a" for the following 
query.


select * from aaa, aaa;
Error: ambiguous column name: main.aaa.a



And also for similar queries



select * from aaa INNER JOIN aaa;
select * from aaa CROSS JOIN aaa;

select * from aaa JOIN aaa;



Tested with sqlite version 3.21.0 and an old version 3.8.4.3.



I think the query is valid and should not result in an error. Typically Sqlite 
would name the resulting columns "a" and "a:1" in this case.

Workaround: add an alias for one of the tables in the join (both columns will 
be called "a").



Met Vriendelijke Groet, Kind Regards, 谨致问候,

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


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite running sum side effect

[petern]

If you want a controlled side effect, like a running sum, add your own
stateful extension functions.  Example:

static double g_sum;
static void FloatSumReset(sqlite3_context *context, int argc, sqlite3_value
**argv) {
  g_sum = sqlite3_value_double(argv[0]);
}
static void FloatSumAccum(sqlite3_context *context, int argc, sqlite3_value
**argv) {
  g_sum += sqlite3_value_double(argv[0]);
  sqlite3_result_double(context,g_sum);
}

Then, in SQLite:

sqlite> WITH num_list(x) AS (VALUES (1),(2),(3)), reset AS (SELECT
FloatSumReset(0)) SELECT x,FloatSumAccum(x) FROM reset,num_list;
x,FloatSumAccum(x)
1,1.0
2,3.0
3,6.0
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to develop a GUI front-end

[Donald Griggs]

Regarding:


*1. Use Christian Werner's ODBC driver from Access (or Excel):*
*http://www.ch-werner.de/sqliteodbc/* 

If you prefer an open solution to Excel or Access, you may want to pair
Werner's ODBC driver with LibreOffice Base or Calc.

http://www.libreoffice.org/

I've only glanced at the advice below, but it's likely reasonable:

> https://wiki.openoffice.org/wiki/Documentation/How_Tos/
> Using_SQLite_With_OpenOffice.org#Under_Windows
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to develop a GUI front-end

[Bart Smissaert]

> This will work with any .NET/Visual Studio language (C#/F#/VB):

Not sure this will work with VBA though.
VB .NET is very different from VBA (or VB6), so that won't be that easy,
unless I am missing something.

RBS

On Tue, Nov 14, 2017 at 4:09 PM, Drago, William @ CSG - NARDA-MITEQ <
william.dr...@l3t.com> wrote:

> > -Original Message-
> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On
> > Behalf Of Bart Smissaert
> > Sent: Monday, November 13, 2017 6:52 PM
> > To: SQLite mailing list 
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> >
> > As you are familiar with VBA I can see two other options:
> >
> > 1. Use Christian Werner's ODBC driver from Access (or Excel):
> > http://www.ch-werner.de/sqliteodbc/
> >
> > 2. Use Olaf Schmidt's COM dll with Access (or Excel):
> > http://www.vbrichclient.com/#/en/About/
> >
> > RBS
>
> Better yet, use the official SQLite provider for the .NET languages. This
> will work with any .NET/Visual Studio language (C#/F#/VB):
>
> http://system.data.sqlite.org/
>
> Building GUI apps with Visual Studio is very easy, and you can get the
> community edition of Visual Studio for free.
>
> https://www.visualstudio.com/vs/community/
>
> --
> Bill Drago
> Staff Engineer
> L3 Narda-MITEQ
> 435 Moreland Road
> Hauppauge, NY 11788
> 631-272-5947 / william.dr...@l3t.com
> CONFIDENTIALITY NOTICE: This email and any attachments are for the sole
> use of the intended recipient and may contain material that is proprietary,
> confidential, privileged or otherwise legally protected or restricted under
> applicable government laws. Any review, disclosure, distributing or other
> use without expressed permission of the sender is strictly prohibited. If
> you are not the intended recipient, please contact the sender and delete
> all copies without reading, printing, or saving.
>
> Beginning April 1, 2018, L3 Technologies, Inc. will discontinue the use of
> all @L-3Com.com email addresses. To ensure delivery of your messages to
> this recipient, please update your records to use william.dr...@l3t.com.
> ___
> 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

[sqlite] PRAGMA foreign_key_list

[Igor Korot]

 Hi,
I am curious - how hard will it be to add the constraint name to the
result of this view?

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

Re: [sqlite] Best way to develop a GUI front-end

[Don V Nielsen]

Ruby on Rails

On Tue, Nov 14, 2017 at 10:09 AM, Drago, William @ CSG - NARDA-MITEQ <
william.dr...@l3t.com> wrote:

> > -Original Message-
> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On
> > Behalf Of Bart Smissaert
> > Sent: Monday, November 13, 2017 6:52 PM
> > To: SQLite mailing list 
> > Subject: Re: [sqlite] Best way to develop a GUI front-end
> >
> > As you are familiar with VBA I can see two other options:
> >
> > 1. Use Christian Werner's ODBC driver from Access (or Excel):
> > http://www.ch-werner.de/sqliteodbc/
> >
> > 2. Use Olaf Schmidt's COM dll with Access (or Excel):
> > http://www.vbrichclient.com/#/en/About/
> >
> > RBS
>
> Better yet, use the official SQLite provider for the .NET languages. This
> will work with any .NET/Visual Studio language (C#/F#/VB):
>
> http://system.data.sqlite.org/
>
> Building GUI apps with Visual Studio is very easy, and you can get the
> community edition of Visual Studio for free.
>
> https://www.visualstudio.com/vs/community/
>
> --
> Bill Drago
> Staff Engineer
> L3 Narda-MITEQ
> 435 Moreland Road
> Hauppauge, NY 11788
> 631-272-5947 / william.dr...@l3t.com
> CONFIDENTIALITY NOTICE: This email and any attachments are for the sole
> use of the intended recipient and may contain material that is proprietary,
> confidential, privileged or otherwise legally protected or restricted under
> applicable government laws. Any review, disclosure, distributing or other
> use without expressed permission of the sender is strictly prohibited. If
> you are not the intended recipient, please contact the sender and delete
> all copies without reading, printing, or saving.
>
> Beginning April 1, 2018, L3 Technologies, Inc. will discontinue the use of
> all @L-3Com.com email addresses. To ensure delivery of your messages to
> this recipient, please update your records to use william.dr...@l3t.com.
> ___
> 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] Best way to develop a GUI front-end

[Drago, William @ CSG - NARDA-MITEQ]

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Bart Smissaert
> Sent: Monday, November 13, 2017 6:52 PM
> To: SQLite mailing list 
> Subject: Re: [sqlite] Best way to develop a GUI front-end
>
> As you are familiar with VBA I can see two other options:
>
> 1. Use Christian Werner's ODBC driver from Access (or Excel):
> http://www.ch-werner.de/sqliteodbc/
>
> 2. Use Olaf Schmidt's COM dll with Access (or Excel):
> http://www.vbrichclient.com/#/en/About/
>
> RBS

Better yet, use the official SQLite provider for the .NET languages. This will 
work with any .NET/Visual Studio language (C#/F#/VB):

http://system.data.sqlite.org/

Building GUI apps with Visual Studio is very easy, and you can get the 
community edition of Visual Studio for free.

https://www.visualstudio.com/vs/community/

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l3t.com
CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient and may contain material that is proprietary, 
confidential, privileged or otherwise legally protected or restricted under 
applicable government laws. Any review, disclosure, distributing or other use 
without expressed permission of the sender is strictly prohibited. If you are 
not the intended recipient, please contact the sender and delete all copies 
without reading, printing, or saving.

Beginning April 1, 2018, L3 Technologies, Inc. will discontinue the use of all 
@L-3Com.com email addresses. To ensure delivery of your messages to this 
recipient, please update your records to use william.dr...@l3t.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple Search using LIKE or something else

[Warren Young]

On Nov 13, 2017, at 3:26 PM, Stephen Chrzanowski  wrote:
> 
> I'm not using a C compiler.

This article appears to sort that out:

http://rvelthuis.de/articles/articles-cobjs.html

Basically, you download the free CLI-only version of the C++Builder Berlin 
compiler, build sqlite3.c to sqlite3.obj — possibly along with other C code of 
your own, plus extensions — and then link that into your Delphi project using 
the instructions provided.

Then no worries about random DLLs floating around.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Error: ambiguous column name

[Rob Golsteijn]

Hi List,



Given a table created as:   create table aaa(a);

Sqlite reports an error "ambiguous column name: main.aaa.a" for the following 
query.


select * from aaa, aaa;
Error: ambiguous column name: main.aaa.a



And also for similar queries



select * from aaa INNER JOIN aaa;
select * from aaa CROSS JOIN aaa;

select * from aaa JOIN aaa;



Tested with sqlite version 3.21.0 and an old version 3.8.4.3.



I think the query is valid and should not result in an error. Typically Sqlite 
would name the resulting columns "a" and "a:1" in this case.

Workaround: add an alias for one of the tables in the join (both columns will 
be called "a").



Met Vriendelijke Groet, Kind Regards, 谨致问候,

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

Re: [sqlite] Valid characters for indentifiers

[Clemens Ladisch]

Simon Slavin wrote:
> On 14 Nov 2017, at 7:56am, Clemens Ladisch  wrote:
>> The documentation claims ANSI SQL 1992 compatiblity; all identifiers
>> conforming to the standard are supported.
>
> SQLite is case-insensitive for entity names.  SQL92 says that case matters.

What I meant to say: all characters valid in SQL92 identifiers are also
valid in SQLite identifiers.


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

Re: [sqlite] Valid characters for indentifiers

[Simon Slavin]

On 14 Nov 2017, at 7:56am, Clemens Ladisch  wrote:

> The documentation claims ANSI SQL 1992 compatiblity; all identifiers
> conforming to the standard are supported.

SQLite is case-insensitive for entity names.  SQL92 says that case matters.

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