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

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

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

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

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

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

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

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" >

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

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

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

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

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

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.

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

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, <

Re: [sqlite] 1TB limit on encrypted database

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

Re: [sqlite] 1TB limit on encrypted database

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

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

[sqlite] 1TB limit on encrypted database

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

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

> 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

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

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

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

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

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

> > 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

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

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

[sqlite] SQLite running sum side effect

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

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

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.

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

> 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 <

[sqlite] PRAGMA foreign_key_list

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

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

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

> -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

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

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

[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

Re: [sqlite] Valid characters for indentifiers

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

Re: [sqlite] Valid characters for indentifiers

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.