[sqlite] How to see SQLite debugging information

On Windows you will get a console and standard output if you are running a console application, and otherwise not. I think you need a simple console app to call your ActiveX DLL, or find some other way. Windows GUI app and standard output do not play well together. Regards David M Bennett FACS

[sqlite] User-defined types -- with Andl

This is the challenge that I accept, with Andl. SQL has been astonishingly successful, partly because of sound foundations and partly because it's a monopoly. It's not a bad language, but on the other hand it many ways it's not a language at all. Up until the 1992 version and including the SQLite

[sqlite] User-defined types -- in Andl

I've been reading this thread with great interest. It parallels the project I've been working on: Andl. Andl is A New Database Language. Andl does what SQL does, but it is not SQL. Andl has been developed as a fully featured database programming language following the principles set out by Date

[sqlite] User-defined types -- in Andl

Thank you for your thoughts. You covered quite a few topics. Is there a PDF? No, but that's a good idea. Did you check out the samples? They cover the entire language, and I could turn those into a PDF much faster than a real language. It would take about a month to write a decent tutorial and

[sqlite] User-defined types -- in Andl

I suggest you just read the samples off GitHub. They cover the entire language. Download the binary, run them and you see what they do. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] User-defined types -- in Andl

Thanks for pointing it out, but I knew that the best way to show off a language is with examples. That's why there are nine sample Andl scripts comprising dozens of individual examples in the Samples folder. My guess is if that you're asking me to write examples, the real lesson is that I didn't

[sqlite] User-defined types

Here is my best effort at translating this query into Andl. ( source_packages [?(release =~ '^(sid|stretch|jessie|wheezy|squeeze)$' ) { name, release, subrelease, version }] join source_package_status [?(bug_name =~ '^(CVE-|TEMP-)') { rowid:=package, bug_name, vulnerable, urgency }]

[sqlite] User-defined types

Here is my best effort at translating this query into Andl. ( source_packages [?(release =~ '^(sid|stretch|jessie|wheezy|squeeze)$' ) { name, release, subrelease, version }] join source_package_status [?(bug_name =~ '^(CVE-|TEMP-)') { rowid:=package, bug_name, vulnerable, urgency }]

[sqlite] User-defined types -- in Andl

There are nine sample scripts and dozens of examples in the Samples folder. Obviously that's the area I need to work on. Regards David M Bennett FACS MD Powerflex Corporation, creators of PFXplus To contact us, please call +61-3-9548-9114 or go to www.pfxcorp.com/contact.htm -Original

[sqlite] User-defined types -- in Andl

I hope you do try it. I'm looking for feedback. Sorry about the C#. Problem is, I'm way more productive in C# than any other language. C/C++ is just too slow to get things done and Java is still lagging. It would have taken far longer to do the SQLite C interface without .NET interop (JNI is

[sqlite] User-defined types -- in Andl

You need to see code to know if you're interested. But I take your point: the grammar is here: http://www.andl.org/downloads/. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] User-defined types -- in Andl

I think you'd be in a minority. I went through the first 50 questions about SQLite on Stack Overflow and only one was C++. Android/Java are dominant, with a smattering of C# and various other languages. Those are my target users, eventually. C/C++ is the drug of choice for low-level byte and bit

[sqlite] User-defined types -- in Andl

Thank you. Exactly so. One of the problems with this kind of project is finding 'good enough' challenges to tackle. I'll let you know how I get on. [BTW I don't remember the last time I saw SQL like this. Understanding it might be the challenge...] Regards David M Bennett FACS Andl - A New

[sqlite] User-defined types -- in Andl

After some code review... The main problem with this code is the use of integers to maintain bit flags tracking cell usage. The advantage is that when the Sudoku search phase with its associated backtracking has to make a copy of the game board, the amount of data to copy is low. The disadvantage

[sqlite] User-defined types -- in Andl

Yes, I had noticed those. Thank you. Both these and the 'challenge' depend on the recursive CTE. As noted elsewhere, I need to implement that before going any further with these. If you have any other challenges I would still be interested. Regards David M Bennett FACS Andl - A New Database

[sqlite] User-defined types

Here is my best effort at translating this query into Andl. ( source_packages [?(release =~ '^(sid|stretch|jessie|wheezy|squeeze)$' ) { name, release, subrelease, version }] join source_package_status [?(bug_name =~ '^(CVE-|TEMP-)') { rowid:=package, bug_name, vulnerable, urgency }]

[sqlite] User-defined types -- in Andl

That's about 30 hours from here. I might have to pass, for now. But if it's on Youtube I'd be interested. I think I understand recursive CTEs well enough now from the description in the documentation and studying the code. I'm impressed at the brevity of your solution, although in practice it

[sqlite] Is recursive CTE fully capable?

The question I'm trying to ask is whether recursive CTE (either as defined in the standard or as implemented in SQLite) carries the full capability of evaluating recursive queries on appropriate data structures, or are there queries that are beyond what it can do? As far as I can see recursive

[sqlite] Is recursive CTE fully capable?

Appropriate just means: set up the data structures any way you like in order to capture the right info and support suitable queries. I'm not trying to find a shortcut to solving NP complete problems. If I did, I probably wouldn't post it here. The question is: are there problems for which: a) a

[sqlite] Is recursive CTE fully capable?

Interesting. SQL has been Turing complete since PSM was added to the 1992 standard. (Not SQLite). I guess they mean "Turing complete with respect to the relation datatype". Andl already supports windowing (but not on SQLite). The Andl implementation of recursion queries is nearly done. I read

[sqlite] User-defined types -- in Andl

Just a quick progress report, in case anyone is interested. First, I added a RECURSE() function to Andl, similar to the CTE in SQLite. The Mandelbrot algorithm looks like this. xaxis := {{ x:=-2.0 }} recurse( {{ x:=x+0.05 }} [?(x<1.2)]) yaxis := {{ y:=-1.0 }} recurse( {{ y:=y+0.1 }} [?(y<1.1)])

[sqlite] User-defined types -- in Andl

If you have some test data I'll happily do that one. Meanwhile here is something similar, using the test data from the SQLite CTE page. orgchart name | boss - Alice | Bob | Alice Cindy | Alice Dave | Bob Emma | Bob Fred | Cindy Gail | Cindy ua := {{ name:= 'Alice', level := 0

[sqlite] Is recursive CTE fully capable?

>>>The task is to write some SQL code, including as many INSERT/UPDATE/DELETEs as you want to make other tables with information about the program, with a final SELECT which returns TRUE if and only if the program will halt. SQL with Recursive CTE is Turing Complete. The above is provably

[sqlite] Is recursive CTE fully capable?

>>>There are queries that cannot be formulated in first order predicate logic, and recursion is the single capability of SQL that exceeds FOPL power. True, wrt SQLite and its dialect, for which RCTE provides Turing Completeness. Untrue for dialects of SQL that include PSM. >>>Unless the

[sqlite] Mozilla wiki 'avoid SQLite'

I won't abuse the patience of our hosts by prolonging this debate, but I disagree strongly with this theme. I have almost certainly written more C/C++ code than you or most of the people on this list, and I never choose it first. I am personally at least 3 times as productive in C# as I am in C

[sqlite] Mozilla wiki 'avoid SQLite'

As I said, I won't fuel the fire. This is the wrong place for this kind of debate, and you should realise that. Your post reflects immaturity and narrow experience, but I won't be the one to broaden your outlook. Your post contains provable errors of fact, but I won't be correcting them. The

[sqlite] Mozilla wiki 'avoid SQLite'

Ditto. My C# code routinely gets close to native C performance whenever I get around to benchmarking it, which is not often these days. And I can actually write code that runs safely on my 8 cores or on my teraflop GPU if I really need the speed. But as I said, I really don't think this is the

[sqlite] This mailing list seems to be public

I was under the impression that this mailing list was restricted to members. However: http://sqlite.1065341.n5.nabble.com/Under-what-circumstances-can-a-table-be- locked-when-the-database-is-first-opened-td82371.html http://comments.gmane.org/gmane.comp.db.sqlite.general/95119

[sqlite] Mozilla wiki 'avoid SQLite'

>>>I think the best database language should reflect how earthlings think about the data, and the best computer programming language would reflect easily the result we want get from them. Care to expand on that? I'm developing a new database language: Andl. My starting point has been the

[sqlite] What should a database language do? [was: RE: Mozilla wiki 'avoid SQLite']

Thank you for your comments. My target is developers, particularly those who are strong on the business domain knowledge and UI/UX, but not so strong on the database stuff. My aim is that they can write code to do sophisticated queries and data manipulation without becoming an SQL guru and

[sqlite] What should a database language do? (was: RE: Mozilla wiki 'avoid SQLite')

Thank you for the comments. Andl already has regular expressions and compound datatypes. They do everything you list here. [Regex is pretty obvious, and user types are as per TTM.] Namespaces: interesting idea. I'm not sure a hierarchical model is the best choice, but I can definitely see that

[sqlite] Is recursive CTE fully capable?

A recursive function contains a computation and a decision: whether to terminate or go deeper. Any recursive function/query will fail to terminate if the termination condition is not satisfied. Here are two similar CTEs. The first terminates, the second does not. WITH RECURSIVE cnt(x) AS

[sqlite] Mozilla wiki 'avoid SQLite'

I agree. SQL is quite deficient in terms of set-oriented updates. INSERT is more or less UNION, but UPDATE and DELETE have no set-oriented forms. The relational algebra describes operations on sets of tuples, where the only operation on attributes is to compare them by name or equal value. SQL

[sqlite] Mozilla wiki 'avoid SQLite'

I don't have enough experience in any FP language to be productive. C# has a lot of FP like features (lambdas, LINQ, etc) that I do know how to use. And ultimately, the C# version could be recoded in C++ if it's worth doing. The question for now is: does a new database programming language have a

[sqlite] Mozilla wiki 'avoid SQLite'

I agree. It would be relatively easy to produce a new language with a syntax based on SQL, which was superficially familiar, but there are many necessary differences at the lower levels. One issue where bullet biting is needed is nulls and three-valued logic; another is duplicate rows and

[sqlite] Andl: release of recursive queries

The latest release of Andl supports recursive queries. There are sample programs for org chart, Mandelbrot set and a Sudoku solver. You can read about it as http://www.andl.org/posts/ or get it from GitHub https://github.com/davidandl/Andl. Regards David M Bennett FACS Andl - A New Database

[sqlite] Mozilla wiki 'avoid SQLite'

--Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of da...@andl.org Sent: Thursday, June 18, 2015 6:36 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Mozilla wiki 'avoid SQLite' I agree

[sqlite] Mozilla wiki 'avoid SQLite'

at APL. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of da...@andl.org Sent: Thursday, June 18, 2015 10:59 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Mozilla wiki 'avoid

[sqlite] Mozilla wiki 'avoid SQLite'

Agreed. Two points. 1. Andl can never replace SQL in one step. The challenge is to find some useful niche and demonstrate an end-to-end solution to a problem, and show that as a total solution it's better than could be done with SQL. It should have a cross-platform front end UI/UX (say

[sqlite] Question about the list

Some of the messages I receive have been cross-posted to two lists (eg from jkl): sqlite-users at mailinglists.sqlite.org sqlite-users at sqlite.org When I reply, the first list accepts my post and the second bounces it. That suggests there are two different lists, but it's not obvious what the

[sqlite] Tables and Columns of Database of Whatsapp

It's usually pretty safe to ignore what the law has to say about copyright, because by the time that matters you would have to be dealing with lawyers. That's not the problem. What you seriously want to avoid is doing things that attract the attention of lawyers, because they have a habit of

[sqlite] Under what circumstances can a table be locked when the database is first opened?

Question: Under what circumstances can a table be locked when the database is first opened? My program does: DROP TABLE IF EXISTS CREATE TABLE INSERT INTO (multiple times) SELECT * (for each row) Run it once and it works perfectly. Run it twice and the DROP TABLE triggers the error:

[sqlite] Under what circumstances can a table be locked when the database is first opened?

Thanks for the summary. Could be a useful addition to the docs. 1) single user. 2) I'm not 'using' anything. Just default open. 3) --> this could be it. How does this work exactly, and how do you avoid it/correct it (after the event)? 4) N/A 5) Latest download. 6) Windows 8.1 NTFS. 7) None. 8)

[sqlite] Under what circumstances can a table be locked when the database is first opened?

Locking mode: Is this documented anywhere? As I thought I said, it's a standalone program; run it to normal termination; then run it again. Single connection, no flags enabled at open (just the default). Yes, I've been using Process Explorer for at least 10 years, since it was at sysinternals.

[sqlite] Andl update

Just a note to say that Andl continues to move forward. Recent posts include a Thrift interface, Workbench and new syntax. Relevance: Andl is tightly integrated with Sqlite, and provides an alternative query language to SQL. Posts are here http://www.andl.org/posts/. Let me know if you have any

[sqlite] User-defined types -- in Andl

Andl does contain an Sudoku solver, far shorter than Pasma's. See http://www.andl.org/2015/06/recursive-queries-sudoku-solver/. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

Having read and understood the documentation on Sqlite data types, I'm really just looking for a single recommendation on which choices to make. I need to store generic data in 5 types: bool, binary, number/decimal, text/nvarchar, time/date/datetime. Decimal has more than 15 digits of

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

Hi Darren Yes, I get that, but the idea is that as far as possible the underlying database retains native values and types, so that (a) SQL queries work as expected (b) non-Andl programs can access the data. I could simply encode everything as my own private bit strings, but making maximum use of

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

Thanks for the response. It helps. > 1. Type name (string) to use in CREATE TABLE. > 2. Affinity. > 3. Datatype that will be returned by C API calls 4. Which C API call > to use to get and put data values. > > My current choices are: > Bool: TINYINT, INTEGER, value_int >>>Why not "BOOLEAN"?

[sqlite] Andl: choices for generic types: bool, binary, number/decimal, date/datetime, text/varchar

>>>Every SQLite database file has a text encoding that applies to the entire file: one of utf8, utf16be, or utf16le. The database text encoding is stored in the header. You can see the encoding for a particular database using: sqlite3 DATABASE.db .dbinfo >>>(NB: The ".dbinfo" command is

[sqlite] Correlated subquery throwing an error

Why not SELECT foo.*, (SELECT id, DIST(foo.x, foo.y, nearest.x, nearest.y) AS d FROM foo AS nearest WHERE d < 25 ORDER BY val, d LIMIT 1) AS id2 FROM foo Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From:

[sqlite] Correlated subquery throwing an error

OK, I get it now. You need a whole query to calculate a value for val, and then another query to find the lowest distance match on val. You can't do that with simple correlated queries or subqueries, except by repeating a lot of the work. The only reasonable prospect I could see for efficiency

[sqlite] NuGet problem

Trying to use NuGet to install Sqlite. The error is: "Could not install package 'sqlite.redist 3.8.4.2'. You are trying to install this package into a project that targets '.NETFramework,Version=v4.5', but the package does not contain any assembly references or content files that are compatible

[sqlite] NuGet problem

Thanks for the answer. At least now I know why. I have already written all the P/Invoke code. It's written, tested, working fine, using the sqlite3.dll size 658,797. Having the header and EXE is convenient too, in a development context. I was able to install the package you suggest, but there is

[sqlite] NuGet problem

Not much help for an automated build. That's what I use now, and I *hate* having to check third party DLLs into the source code tree. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] NuGet problem

Can someone tell me where the NuGet package gets built, so I can have a look and see what needs to be done? Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at

[sqlite] sqlite native NuGet package maintainers?

I have raised an issue for cannot install Nuget native DLL into .NET 4.5 project. I requested information about where this project is maintained and by whom. Any response appreciated. Regards David M Bennett FACS Andl - A New Database Language - andl.org -Original Message- From:

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

I agree with Duncan. The original SQL code and a list of bound values. This is a problem we know well and have already solved exactly this way in a different context. Yes, it would be a good new feature request. Regards David M Bennett FACS Andl - A New Database Language - andl.org

[sqlite] Slight problem with sqlite3_compileoption_get

I have been here many times. As I recall the steps interfacing to COM/IDL are: 1. Find out what ACTUAL types and ACTUAL calling convention were used by the DLL you are targeting. The C header file declarations are not definitive: you need to examine the options used to compile the DLL and often