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
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 mailing
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
[mailto:sqli
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
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 wi
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 is
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-users-boun...@ma
>>>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 r
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"? (Th
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
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
precision
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
[mailto:sqlite-us
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
q
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 th
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
-Origi
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
A
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 makin
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
p
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 JavaScript,
g
keywords? I feel like I'm looking 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 D
ot;Hey, stupid... *this* exists.. try
it." Heck, maybe Andl does it. I haven't looked.
Marc
-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
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 La
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 namele
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
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
im
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 (VALUE
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 'p
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 without
>>>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
relation
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
http://osdir.com/ml/
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
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
subjec
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 (s
>>>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 recursi
>>>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 impossib
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
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)])
m
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 th
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 r
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 CTE
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 does
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 }] join
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 Lan
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
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 Data
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 t
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
[mailto:sqlite-user
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 se
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 Messag
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 }] join
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 }] join
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
ma
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
[mailto:sqli
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 ref
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 a
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
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. Fi
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) N/A
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_LOCK
59 matches
Mail list logo