Re: [sqlite] How to retrieve "latest" fileio.c, test_windirect.c/h files?
On 2019-05-12 21:39, Warren Young wrote: On May 11, 2019, at 10:46 PM, Justin Clift wrote: One of the steps uses curl to download fileio.c, test_windirent.c/.h from fossil [snip] Is there a way to always get "the latest" version of the file? :) $ curl -L -o src/extensions/fileio.c 'https://sqlite.org/src/raw?filename=ext/misc/fileio.c=trunk' Thanks Warren, that works. :) Or, you could just use Fossil directly. ... It's a good thought, but not just yet. Already have a head full of other stuff being learned, don't really want to add a whole new distributed version control system as well. Maybe later. :) Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to retrieve "latest" fileio.c, test_windirect.c/h files?
Hi all, Is there a way to grab the "latest" version of a SQLite source file? In this instance, we have an automatic nightly process (shell script) that builds the DB Browser for SQLite nightly builds. One of the steps uses curl to download fileio.c, test_windirent.c/.h from fossil, so the fileio extension can be included in the nightly builds. It's using a specific commit for each of the downloads at the moment, as that's the only thing I was able to figure out at the time of creating the script: curl -L -o src/extensions/fileio.c https://sqlite.org/src/raw/ext/misc/fileio.c?name=288e7230e0fe464d71b0694e2d8bdd3a353118ac2e31da3964b95f460f09915f curl -L -o src/extensions/test_windirent.c https://sqlite.org/src/raw/src/test_windirent.c?name=a895e2c068a06644eef91a7f0a32182445a893b9a0f33d0cdb4283dca2486ac1 curl -L -o src/extensions/test_windirent.h https://sqlite.org/src/raw/src/test_windirent.h?name=90dfbe95442c9762357fe128dc7ae3dc199d006de93eb33ba3972e0a90484215 Leaving off the `name=...` argument just returns a HTML page, instead of giving the expect latest version too. Is there a way to always get "the latest" version of the file? :) Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] DB Browser 3.7.0 for SQLite released
Quick note. DB Browser 3.7.0 for SQLite has been released: :) https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.7.0 Win + OSX binaries are there, as is the source tarball. Ubuntu PPA should be done in a day or two, and hopefully the FreeBSD port will updated in the near future as well. :) + Justin
[sqlite] SourceForge seems to have grabbed the "sqlite" project there
Hi all, It looks like the SourceForge admin staff have taken control of the "sqlite" project on SourceForge: http://sourceforge.net/mirror/sqlite/ The owners there are now "sf-editor1" and "sf-editor2". Any idea if this is a recent thing, related to their other string of project seizures? eg: http://arstechnica.com/information-technology/2015/06/black-mirror-sourceforge-has-now-siezed-nmap-audit-tool-project/ Regards and best wishes, Justin Clift
[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome
On 4 May 2015, at 18:52, Scott Doctor wrote: > The day I can open source my rent, groceries, car repairs, is when everything > else can be free. Rent and groceries... yeah, good luck there. ;) But car repairs might actually come along at some point (decade or two?) if the 3D printing scene goes big. :) (and "... 3D printed groceries ..." hrmm ;>) + Justin
[sqlite] What software is deployed more than SQLite?
On 3 May 2015, at 19:26, Eric Sink wrote: > Last time I asked myself this question, I ended up in the same place you > did: zlib, libpng and libjpeg may be the only candidates in the same > ballpark as SQLite. Likely libxml2 as well. Seems to get embedded by just about everything. Some of the crypto libraries are in lots of things too, but not as much as libxml2. + Justin
[sqlite] Integrating sqlite with Core Data and iCloud
On 25 Apr 2015, at 20:41, Jeff M wrote: >> On Apr 24, 2015, at 2:44 AM, Simon Slavin wrote: >> >> On 24 Apr 2015, at 6:59am, Jeff M wrote: >> >>> I don't need to map SQLite to iCloud -- I only need to map SQLite to Core >>> Data. Core Data then takes care of the iCloud issues. >> >> I imagine you'd do that by writing a VFS which used Core Data for storage. >> Core Data could store your data in any of the formats it has drivers for, >> including plaintext files and SQLite. And Core Data could store your data >> in any medium it has drivers for, including local storage and iCloud. >> >> The result might be slow and inefficient, since you're building a DBMS >> (SQLite) on top of a DBMS (Core Data) on top of a DBMS (SQLite). >> >> If you use Core Data the resulting file wouldn't look like a normal SQLite >> database. Core Data stores objects. It doesn't store the rows and columns >> you refer to with SQL commands. Maybe your objects would be table rows. >> >> Simon. > > Originally, I wanted to map my tables, rows, and columns to similarly-named > Core Data entities and attributes so I could continue to use the SQL > language. I was hoping to hook into the SQL parser to get the benefits of > where.c, but I realize now that's impractical. > > Your suggestion of working at the file system level is interesting, but my > objects would be disk blocks. I could use a simple Core Data model: one > entity (representing the entire database file) and create one object per > block (each having a binary attribute containing one block of data). It > would be easy to map each file system read() and write() to the corresponding > objects. Using Core Data as a memory array would earn me the Kludge of The > Year Award. But, I see data corruption in my future. > > Can you point me to some sample source code (outside of SQLite itself) that > implements sqlite3_vfs_register()? Hmmm, searching for that function name across GitHub returns about 27k results. 16.6k+ for just C: https://github.com/search?l=c=sqlite3_vfs_register=Code=? 6k+ for C++: https://github.com/search?l=cpp=sqlite3_vfs_register=Code=? You'll probably not be short of example stuff to drawn from... :D Regards and best wishes, Justin Clift
[sqlite] OT: Testers needed for full database encryption support
As a quick FYI, we've just added initial full database encryption support to DB Broweser for SQLite (using SQLCipher). We're looking for people using MacOS X, Linux, or FreeBSD to try it out and report success/failure/etc back to us (on GitHub). Initial MacOS X build: http://mirror.salasaga.org/sqlitebrowser/onceoffs/sqlitebrowser_201411051855.dmg For Linux and FreeBSD, you'll need to compile it yourself (pretty easy): https://github.com/sqlitebrowser/sqlitebrowser/blob/master/BUILDING.md For anyone with time to do so, this will really help us out. :) Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
