[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-14 Thread Keith Medcalf

Windows 10 1511 includes both a 64-bit and 32-bit version of SQLite called:

C:\Windows\System32\winsqlite3.dll
C:\Windows\SysWow64\winsqlite3.dll

for the 64-bit and 32-bit versions respectively.

The version of SQLite contained in these libraries is:

2015-02-25 13:29:11 9d6c1880fb75660bbabd693175579529785f8a6b

SQLite version 3.8.8.3 2015-02-25 13:29:11
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

If I use that version of the amalgamation, I cannot seem to compile a working 
version of the client that will use it -- it crashes as soon as any command is 
issued.


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison
> Sent: Saturday, 14 November, 2015 11:51
> To: SQLite mailing list
> Subject: Re: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10
> 
> On Fri, Nov 13, 2015 at 11:55 PM, Stephen Chrzanowski
> 
> wrote:
> 
> > Prior to release or otherwise, it feels that if MSoft were to have
> skipped
> > the registry and just used the GROUP->KEY=VALUE setup in INI files only,
> > things would be much better as far as cleaning up viruses at LEAST,
> > especially if you start locking down these files at the NTFS level.  But
> > then again, if they used an actual SQL system (Like their own) for
> managing
> > registry entries, things would be so much easier with a DELETE
> statement.
> > Individual programs could have their OWN "registry" file instead of crap
> > ending up all over the place.  Backing up an entire application would be
> a
> > snap as relevant entries pointing at specific DLLs would come with the
> > application base or at least configured upon install..  Ohhh the
> mind
> > is wandering.
> >
> 
> Perhaps a bit off topic, but:
> 
> At my day job, we write software for backup / disaster recovery of Windows
> partitions, including virtual boot of previously physical environments. As
> a result, we have to do a bit of registry manipulation. Our software
> targets both Windows and Linux systems.
> 
> When we need to manage a registry hive from Linux land, we use a LGPL
> library called hivex.
> 
> When we need to do that in Windows, historically we had to load an offline
> registry hive into the running registry, make whatever changes were
> needed,
> then unload the file.
> 
> I recently discovered a redistributable Microsoft DLL called "offreg" for
> offline registry access. It avoids (in Windows) the need to attach an
> offline hive to the online registry.
> 
> For Windows applications that have a need for registry files, offreg.dll
> (combined with hivex for cross platform compatibility) greatly simplify
> registry maintenance. I wrote a wrapper around offreg.dll to make it
> source
> compatible with hivex (which we were already using) so that future
> projects
> wouldn't need quite so much "#ifdef WINDOWS" style code.
> 
> If a windows app was bound and determined to use a registry style
> datastore, offreg.dll could provide a lot of the benefits outlined above.
> Still no SQL interface.
> 
> Hmmm, maybe a VFS or virtual table for SQLite...
> 
> --
> Scott Robison
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users





[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-14 Thread Scott Robison
On Fri, Nov 13, 2015 at 11:55 PM, Stephen Chrzanowski 
wrote:

> Prior to release or otherwise, it feels that if MSoft were to have skipped
> the registry and just used the GROUP->KEY=VALUE setup in INI files only,
> things would be much better as far as cleaning up viruses at LEAST,
> especially if you start locking down these files at the NTFS level.  But
> then again, if they used an actual SQL system (Like their own) for managing
> registry entries, things would be so much easier with a DELETE statement.
> Individual programs could have their OWN "registry" file instead of crap
> ending up all over the place.  Backing up an entire application would be a
> snap as relevant entries pointing at specific DLLs would come with the
> application base or at least configured upon install..  Ohhh the mind
> is wandering.
>

Perhaps a bit off topic, but:

At my day job, we write software for backup / disaster recovery of Windows
partitions, including virtual boot of previously physical environments. As
a result, we have to do a bit of registry manipulation. Our software
targets both Windows and Linux systems.

When we need to manage a registry hive from Linux land, we use a LGPL
library called hivex.

When we need to do that in Windows, historically we had to load an offline
registry hive into the running registry, make whatever changes were needed,
then unload the file.

I recently discovered a redistributable Microsoft DLL called "offreg" for
offline registry access. It avoids (in Windows) the need to attach an
offline hive to the online registry.

For Windows applications that have a need for registry files, offreg.dll
(combined with hivex for cross platform compatibility) greatly simplify
registry maintenance. I wrote a wrapper around offreg.dll to make it source
compatible with hivex (which we were already using) so that future projects
wouldn't need quite so much "#ifdef WINDOWS" style code.

If a windows app was bound and determined to use a registry style
datastore, offreg.dll could provide a lot of the benefits outlined above.
Still no SQL interface.

Hmmm, maybe a VFS or virtual table for SQLite...

-- 
Scott Robison


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-14 Thread Stephen Chrzanowski
Prior to release or otherwise, it feels that if MSoft were to have skipped
the registry and just used the GROUP->KEY=VALUE setup in INI files only,
things would be much better as far as cleaning up viruses at LEAST,
especially if you start locking down these files at the NTFS level.  But
then again, if they used an actual SQL system (Like their own) for managing
registry entries, things would be so much easier with a DELETE statement.
Individual programs could have their OWN "registry" file instead of crap
ending up all over the place.  Backing up an entire application would be a
snap as relevant entries pointing at specific DLLs would come with the
application base or at least configured upon install..  Ohhh the mind
is wandering.

On Thu, Nov 12, 2015 at 12:54 PM, Scott Robison 
wrote:

>
> What sort of technologies does Microsoft possess that make you believe they
> could have opted to use SQLite 10 years prior to its initial release (in a
> very different form than today's SQLite 3)? :)
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread Christian Werner
On 11/12/2015 03:44 PM, James K. Lowden wrote:

> Fork?  Isn't that what CreateProcess is for?

I think not. That's a lonesome chopstick.

--
Christian Werner



[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread Scott Robison
On Nov 12, 2015 7:44 AM, "James K. Lowden"  wrote:
>
> On Tue, 10 Nov 2015 13:45:52 -0700
> Warren Young  wrote:
>
> > This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet,
> > DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry,
> > Access, SQL Server Express?
>
> The real irony is that every one of those technologies had (I'll bet)
> more resources expended on it than SQLite has had.
>
> > Obviously getting SQLite into Windows is a great thing.  It?s just
> > that it would have been even nicer a decade ago.
>
> It's more like 25 years.  The registry, with all its obvious defects,
> made its appearance in Windows 3.1, which the oracle Wikipedia puts at
> 1992.  At the time Microsoft already had the Jet engine, demonstrating
> the feasibility of implementing relational technology on the machines
> of the day.

What sort of technologies does Microsoft possess that make you believe they
could have opted to use SQLite 10 years prior to its initial release (in a
very different form than today's SQLite 3)? :)


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread James K. Lowden
On Tue, 10 Nov 2015 22:20:59 +0100
"Christian Werner"  wrote:

> When SQLite is the spoon, will they give us Linux binary
> compatibility for the fork?  

Fork?  Isn't that what CreateProcess is for?  

--jkl



[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread James K. Lowden
On Tue, 10 Nov 2015 13:45:52 -0700
Warren Young  wrote:

> This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet,
> DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry,
> Access, SQL Server Express?

The real irony is that every one of those technologies had (I'll bet)
more resources expended on it than SQLite has had.  

> Obviously getting SQLite into Windows is a great thing.  It?s just
> that it would have been even nicer a decade ago.  

It's more like 25 years.  The registry, with all its obvious defects,
made its appearance in Windows 3.1, which the oracle Wikipedia puts at
1992.  At the time Microsoft already had the Jet engine, demonstrating
the feasibility of implementing relational technology on the machines
of the day.  

How many needless, mysterious Windows problems can be linked to the
registry's tree structure and failure to enforce consistency?  How many
programmers over those decades could have benefited from built-in DBMS
technology?  How much less schlock might we have today if every Windows
programmer had been unwittingly exposed to set theory as a basic
feature of the OS?  

I'm happy to see Microsoft has seen the light in some sense, even
though there's no chance the SQLite folks will be justly compensated.
I'll be impressed when SQLite is a kernel driver and
GetPrivateProfileString is a SELECT statement.  

--jkl


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-12 Thread Michael Falconer
Outstanding!

it is kudos which is so richly deserved, and IMHO, an example of REAL
integrity earned. Over the years I have watched as SQLite developed,
learned much from this list, and was impressed by Dr Hipps hands-on
leadership in directing development in what he and the team deemed an
appropriate direction. Many contentious issues have been raised over the
years but they have been consistently handled with a core ethic in mind.
Make it better, more efficient, scalable and usable on multiple platforms.

It is not often that you truly see such a development process remain true
to it's founding principles, we humans have a powerful capability to
corrupt and in IT we tend to excel at that. In SQLite we have a shining
example of what can be achieved when a development process is well handled,
and it is sadly all to rare. So well done to all involved in developing a
truly great system and to all on this list who have made so many good
recommendations and offered their seasoned technical opinions so openly and
in collaborative spirit. It is a genuine open source triumph of which you
should all be proud. Thanks.


On 12 November 2015 at 04:51, Jay Kreibich  wrote:

>
> On Nov 10, 2015, at 6:38 PM, Richard Hipp  wrote:
>
> > On 11/10/15, Jay Kreibich  wrote:
> >>
> >> I want to be a Certified SQLite Professional.
> >>
> >
> > The inventors and developers of the SQLite database engine to all to
> > whom these presents may come, Greetings:  Whereas Mr. Jay Kreibich has
> > exhibited detailed knowledge of the use and inner workings of SQLite
> > by publishing an outstanding textbook on that subject, we do hereby
> > confirm unto him the title of
> >
> >Certified SQLite Professional
> >
> > with all the rights, honors, and duties thereunto appertaining.  In
> > witness whereof, the electronic signature of the BDLF of SQLite is
> > hereto subscribed.  Given in Charlotte on this the tenth day of
> > November and in the year of our Lord two thousand and fifteen.
>
>
> w00t!  Time to update my resume!
>
>  -j
>
> --
> Jay A. Kreibich < J A Y @ K R E I B I.C H >
>
> "Intelligence is like underwear: it is important that you have it, but
> showing it to the wrong people has the tendency to make them feel
> uncomfortable." -- Angela Johnson
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Regards,
 Michael.j.Falconer.


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread Jay Kreibich

On Nov 10, 2015, at 6:38 PM, Richard Hipp  wrote:

> On 11/10/15, Jay Kreibich  wrote:
>> 
>> I want to be a Certified SQLite Professional.
>> 
> 
> The inventors and developers of the SQLite database engine to all to
> whom these presents may come, Greetings:  Whereas Mr. Jay Kreibich has
> exhibited detailed knowledge of the use and inner workings of SQLite
> by publishing an outstanding textbook on that subject, we do hereby
> confirm unto him the title of
> 
>Certified SQLite Professional
> 
> with all the rights, honors, and duties thereunto appertaining.  In
> witness whereof, the electronic signature of the BDLF of SQLite is
> hereto subscribed.  Given in Charlotte on this the tenth day of
> November and in the year of our Lord two thousand and fifteen.


w00t!  Time to update my resume!

 -j

--  
Jay A. Kreibich < J A Y @ K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it, but showing 
it to the wrong people has the tendency to make them feel uncomfortable." -- 
Angela Johnson







[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread Jay Kreibich

On Nov 11, 2015, at 3:25 AM, Simon Slavin  wrote:

> There's a story behind this.
> 
> During the review leading to HTML5 the web consortium (the one which decides 
> which features should be introduced to HTML/CSS/JavaScript) listed a 
> 'webdatabase' specification so that browsers could maintain data in a 
> database-like structure.  The specification boiled down to "Implement a 
> simple SQL engine with an API like [this].".
> 
> Unfortunately all the leading browser publishers implemented this happily and 
> quickly.  "Unfortunately" because they all did it by including SQLite in 
> their project.  This is a problem because the only way to ensure 
> compatibility in that case is for the web consortium to include the full 
> specification of SQLite inside the specification for a compatible web 
> browser.  Otherwise people would start doing things like calling PRAGMA 
> commands from web pages, and then an unofficial standard would evolve which 
> required PRAGMA commands to be supported from the web API.
> 
> So they did.  And it failed.  And that's where we are today.

Sorta-kinda.  The standard was called WebSQL, and it was an extension to 
client-side data stores.  W3C setup a working group and sent out a request for 
implementations, but as you said, everyone in the working group implemented the 
standard by basically wrapping SQLite.  The standard was then killed due to 
lack of unique implementations.  As you said, there was concern that without 
independent implementations, aspects specific to SQLite would ?leak? into the 
standards and commonly used APIs, so the standard was killed.

The official working group notes are here:

http://www.w3.org/TR/webdatabase/

  -j

--  
Jay A. Kreibich < J A Y @ K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it, but showing 
it to the wrong people has the tendency to make them feel uncomfortable." -- 
Angela Johnson







[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread a...@zator.com

>
>  Mensaje original 
> De: Simon Slavin 
> Para:  SQLite mailing list 
> Fecha:  Wed, 11 Nov 2015 09:25:47 +
> Asunto:  Re: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10
>
>There's a story behind this.
>
>During the review leading to HTML5 the web consortium (the one which decides 
>which features should be introduced to HTML/CSS/JavaScript) listed a 
>'webdatabase' specification so that browsers could maintain data in a 
>database-like structure.  The specification boiled down to "Implement a simple 
>SQL engine with an API like [this].".
>
>Unfortunately all the leading browser publishers implemented this happily and 
>quickly.  "Unfortunately" because they all did it by including SQLite in their 
>project.  This is a problem because the only way to ensure compatibility in 
>that case is for the web consortium to include the full specification of 
>SQLite inside the specification for a compatible web browser.  Otherwise 
>people would start doing things like calling PRAGMA commands from web pages, 
>and then an unofficial standard would evolve which required PRAGMA commands to 
>be supported from the web API.
>
>So they did.  And it failed.  And that's where we are today.
>

Simon:

You are right, and I realized that before. By the way the "storage" issue from 
JavaScript has been my nightmare in the recent past.

I believe that it's a nonsense that the standard suppose a limitation in the 
field. Although it seem that the Standard work like the lawyers who usually go 
behind the real life. But that reminds me the adoption of the C++ STL whos 
first incarnation was -I think remember- in a unique piece from HP and nobody 
put objections.

Any way in the real life we need it desperately IMHO.

--
Adolfo




[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread a...@zator.com
>  Mensaje original 
> De: Richard Hipp 
> Para:  General Discussion of SQLite Database mailinglists.sqlite.org>
> Fecha:  Tue, 10 Nov 2015 14:41:28 -0500
> Asunto:  [sqlite] "Shipping a New Mindset" - SQLite in Windows 10
> 
>
>http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>

Congratulations to all the team. A great praise coming from M$.

A great notice to all us who write Windows. And a final prayer to MS: add an 
extension to use it from JavaScript.

--
Adolfo J. Millan



[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread Simon Slavin

On 11 Nov 2015, at 8:33am, ajm at zator.com wrote:

> A great notice to all us who write Windows. And a final prayer to MS: add an 
> extension to use it from JavaScript.

There's a story behind this.

During the review leading to HTML5 the web consortium (the one which decides 
which features should be introduced to HTML/CSS/JavaScript) listed a 
'webdatabase' specification so that browsers could maintain data in a 
database-like structure.  The specification boiled down to "Implement a simple 
SQL engine with an API like [this].".

Unfortunately all the leading browser publishers implemented this happily and 
quickly.  "Unfortunately" because they all did it by including SQLite in their 
project.  This is a problem because the only way to ensure compatibility in 
that case is for the web consortium to include the full specification of SQLite 
inside the specification for a compatible web browser.  Otherwise people would 
start doing things like calling PRAGMA commands from web pages, and then an 
unofficial standard would evolve which required PRAGMA commands to be supported 
from the web API.

So they did.  And it failed.  And that's where we are today.

Simon.


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-11 Thread Simon Slavin

On 10 Nov 2015, at 11:53pm, Tim Uy  wrote:

> On Tue, Nov 10, 2015 at 3:31 PM, Jay Kreibich  wrote:
> 
>> I want to be a Certified SQLite Professional.
> 
> Exactly. How does this happen?

If you'd each like to send me a check for five thousand dollars and take a 
short online test I will be happy to send you your certificates.

Simon.


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Bernardo Sulzbach
On Tue, Nov 10, 2015 at 10:38 PM, Richard Hipp  wrote:
> The inventors and developers of the SQLite database engine to all to
> whom these presents may come, Greetings:  Whereas Mr. Jay Kreibich has
> exhibited detailed knowledge of the use and inner workings of SQLite
> by publishing an outstanding textbook on that subject, we do hereby
> confirm unto him the title of
>
> Certified SQLite Professional
>

Not only that, but the #1 Certified SQLite Professional.

-- 
Bernardo Sulzbach


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Christian Werner
On 11/10/2015 08:41 PM, Richard Hipp wrote:

> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/

Congratulations!

When SQLite is the spoon, will they give us Linux binary compatibility for the 
fork?

I wonder what the knife will be ;-)

--
Christian Werner




[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Bart Smissaert
Will MS add a connection to SQLite from VBA?

RBS
On 10 Nov 2015 8:46 pm, "Warren Young"  wrote:

> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A <
> Richard.A.Rousselot at centurylink.com> wrote:
> >
> > What no love for their own Access DB?  
>
> This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO,
> RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, Access, SQL
> Server Express?
>
>   https://msdn.microsoft.com/en-us/library/ee730343.aspx
>
> Giving developers yet another DBMS or API for a DBMS is kinda what
> Microsoft does. :)
>
> Microsoft is finally getting to a place Apple?s been since 2005.
>
> (SQLite first shipped with OS X Tiger, and has shipped on every iDevice.)
>
> I don?t mean to be dismissive.  Obviously getting SQLite into Windows is a
> great thing.  It?s just that it would have been even nicer a decade ago.  I
> love that Nadella?s Microsoft is giving up on NIH.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Rousselot, Richard A
What no love for their own Access DB?  

Congrats!

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen 
Chrzanowski
Sent: Tuesday, November 10, 2015 2:19 PM
To: SQLite mailing list
Subject: Re: [sqlite] "Shipping a New Mindset" - SQLite in Windows 10

Wicked.  Congrats!

On Tue, Nov 10, 2015 at 2:41 PM, Richard Hipp  wrote:

> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
This communication is the property of CenturyLink and may contain confidential 
or privileged information. Unauthorized use of this communication is strictly 
prohibited and may be unlawful. If you have received this communication in 
error, please immediately notify the sender by reply e-mail and destroy all 
copies of the communication and any attachments.


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Nelson, Erik - 2
Richard Hipp Sent: Tuesday, November 10, 2015 2:41 PM
> 
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/

Congratulations!

--
This message, and any attachments, is for the intended recipient(s) only, may 
contain information that is privileged, confidential and/or proprietary and 
subject to important terms and conditions available at 
http://www.bankofamerica.com/emaildisclaimer.   If you are not the intended 
recipient, please delete this message.


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Bernardo Sulzbach
On Tue, Nov 10, 2015 at 7:20 PM, Christian Werner
 wrote:
> I wonder what the knife will be ;-)

Maybe there is no knife this time. Just kidding.

But yeah, kudos for R. Hipp and everyone that contributed to the project.


-- 
Bernardo Sulzbach


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Richard Hipp
On 11/10/15, Jay Kreibich  wrote:
>
> I want to be a Certified SQLite Professional.
>

The inventors and developers of the SQLite database engine to all to
whom these presents may come, Greetings:  Whereas Mr. Jay Kreibich has
exhibited detailed knowledge of the use and inner workings of SQLite
by publishing an outstanding textbook on that subject, we do hereby
confirm unto him the title of

Certified SQLite Professional

with all the rights, honors, and duties thereunto appertaining.  In
witness whereof, the electronic signature of the BDLF of SQLite is
hereto subscribed.  Given in Charlotte on this the tenth day of
November and in the year of our Lord two thousand and fifteen.
-- 
D. Richard Hipp
drh at sqlite.org


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Richard Hipp
On 11/10/15, Keith Christian  wrote:
>
> SQLite is an integral part in numerous other commercial software systems.
>

Many of which even I don't know about :-)

-- 
D. Richard Hipp
drh at sqlite.org


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Jay Kreibich

> On Nov 10, 2015, at 2:45 PM, Warren Young  wrote:
> 
>> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A > centurylink.com> wrote:
>> 
>> What no love for their own Access DB?  
> 
> This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO, 
> RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, Access, SQL 
> Server Express?

I want to be a Certified SQLite Professional.

  -j



[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Tim Uy
Exactly. How does this happen?

On Tue, Nov 10, 2015 at 3:31 PM, Jay Kreibich  wrote:

>
> > On Nov 10, 2015, at 2:45 PM, Warren Young  wrote:
> >
> >> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A <
> Richard.A.Rousselot at centurylink.com> wrote:
> >>
> >> What no love for their own Access DB?  
> >
> > This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet,
> DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, Access,
> SQL Server Express?
>
> I want to be a Certified SQLite Professional.
>
>   -j
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Keith Christian
On Tue, Nov 10, 2015 at 3:35 PM, Scott Robison  
wrote:
> On Nov 10, 2015 2:19 PM, "John McKown"  
> wrote:
>>
>> On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian <
> keith1christian at gmail.com>
>> wrote:
>>
>> > A great thing for Windows users.
>> >
>> > My only caveat is: Beware corporate pressure.  Stay Free.
>> >
>> >
>> I agree. I'm not any kind of MS fan. I simply don't trust them _at all_.
>> They like to "embrace" ... "extend" ... "eliminate".
>
> Considering that SQLite is public domain, they could take the code and do
> anything they want with it. Well, most of it, not counting things like SEE
> & CEROD. I don't think there is any conceivable way this is bad or
> worrisome news.


Scott,

Right.  On second thought, it was probably was a silly comment.

SQLite is an integral part in numerous other commercial software systems.

Keith


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Scott Robison
On Nov 10, 2015 2:19 PM, "John McKown"  wrote:
>
> On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian <
keith1christian at gmail.com>
> wrote:
>
> > A great thing for Windows users.
> >
> > My only caveat is: Beware corporate pressure.  Stay Free.
> >
> >
> ?I agree. I'm not any kind of MS fan. I simply don't trust them _at all_.
> They like to "embrace" ... "extend" ... "eliminate". ?

Considering that SQLite is public domain, they could take the code and do
anything they want with it. Well, most of it, not counting things like SEE
& CEROD. I don't think there is any conceivable way this is bad or
worrisome news.

>
> ?They tried it with Java, but got pushed back. And basically "retaliated"
> by making Java a real PITA under Windows.
>
> Disclaimer: I'm a GNU/Linux bigot & FSF associate member.?
>
> --
>
> Schrodinger's backup: The condition of any backup is unknown until a
> restore is attempted.
>
> Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will
be.
>
> He's about as useful as a wax frying pan.
>
> 10 to the 12th power microphones = 1 Megaphone
>
> Maranatha! <><
> John McKown
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread John McKown
On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian 
wrote:

> A great thing for Windows users.
>
> My only caveat is: Beware corporate pressure.  Stay Free.
>
>
?I agree. I'm not any kind of MS fan. I simply don't trust them _at all_.
They like to "embrace" ... "extend" ... "eliminate". ?

?They tried it with Java, but got pushed back. And basically "retaliated"
by making Java a real PITA under Windows.

Disclaimer: I'm a GNU/Linux bigot & FSF associate member.?

-- 

Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Stephen Chrzanowski
Wicked.  Congrats!

On Tue, Nov 10, 2015 at 2:41 PM, Richard Hipp  wrote:

> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Richard Hipp
http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/

-- 
D. Richard Hipp
drh at sqlite.org


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Ned Fleming
On Tue, 10 Nov 2015 14:41:28 -0500, Richard Hipp
 wrote:

>http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/

Wow! High praise -- which you deserve.

-- 

Ned


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Keith Christian
A great thing for Windows users.

My only caveat is: Beware corporate pressure.  Stay Free.

On Tue, Nov 10, 2015 at 12:41 PM, Richard Hipp  wrote:
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

2015-11-10 Thread Warren Young
On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A  wrote:
> 
> What no love for their own Access DB?  

This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO, RDO, 
ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, Access, SQL Server 
Express?

  https://msdn.microsoft.com/en-us/library/ee730343.aspx

Giving developers yet another DBMS or API for a DBMS is kinda what Microsoft 
does. :)

Microsoft is finally getting to a place Apple?s been since 2005.

(SQLite first shipped with OS X Tiger, and has shipped on every iDevice.)

I don?t mean to be dismissive.  Obviously getting SQLite into Windows is a 
great thing.  It?s just that it would have been even nicer a decade ago.  I 
love that Nadella?s Microsoft is giving up on NIH.