[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

Hello, > I would be interested what you find wrong about Git and is better in your > version control system. If you google - one of the first hits that come up is: Fossil Versus Git [1]. Cheers. [1] http://www.fossil-scm.org/xfer/doc/trunk/www/fossil-v-git.wiki

[sqlite] Is there something like PHPAdmin for SQLite

Hello, > Is there something like PHPAdmin for SQLite? I've put together Awesome SQLite [1] - a collection of (free) SQLite goodies incl. a list of admin tools for SQLite - desktop version (e.g. SQLiteStudio recommended) or web (e.g. sqliteweb). Cheers. [1]

[sqlite] Awesome SQLite Update - New Book - Getting Started with SQL(lite and SQLiteStudio)

Hello, For you enjoyment I have added three more entries to the Awesome SQLite [1] collection: - sqlite-web (github: coleifer/sqlite-web) by Charles Leifer -- a web-based SQLite database browser written in Python - sqliteweb (github: hypebeast/sqliteweb) by Sebastian Ruml -- a web-based

[sqlite] Awesome SQLite Update - New Book - Getting Started with SQL(lite and SQLiteStudio)

Hello, I've updated the Awesome SQLite [1] collection over at Planet Open Data. What's news? Added a new beginner's book: Getting Started with SQL - A Hands-On Approach for Beginners - by Thomas Nield; 2016; O'Reilly; 134 pages -- learn SQL with SQLite and SQLiteStudio Anything

[sqlite] factbook.sql World Factbook Country Profiles in SQL (Incl. factbook.db - Single-File SQLite Distro)

Hello, Thanks. Great advice. The SQLite schema code gets generated from the ActiveRecord (Ruby) source [1] e.g.: create_table :facts do |t| t.string :code, null: false # country code e.g. au t.string :name, null: false # country name e.g. Austria t.integer :area

[sqlite] factbook.sql World Factbook Country Profiles in SQL (Incl. factbook.db - Single-File SQLite Distro)

Hello, Thanks for your kind words and the links. About: > Have you seen the XML/mysql versoin: Yes, this is great and seems to be the "last" reader/project (of many others) that still is maintained and might get updated. The CIA changed the structure of the online (live) pages in

[sqlite] factbook.sql World Factbook Country Profiles in SQL (Incl. factbook.db - Single-File SQLite Distro)

Hello, I've started a new project, that is, /factbook.sql [1] that offers an SQL schema for the World Factbook and also includes a pre-built single-file SQLite database, that is, factbook.db [2] for download. What's the World Factbook? The World Factbook [3] published by the Central

[sqlite] football.db - New 2015/16 Seasons - English Premier League, Bundesliga, etc.

Hello, I've put together a new sport.db (football.db) quick starter sample using the Mauritius Premier League [1] to get you started creating your own leagues/cups/etc. from scratch. You can test drive the quick starter sample with a single command e.g. $ sportdb build That's it. Now

[sqlite] football.db - New 2015/16 Seasons - English Premier League, Bundesliga, etc.

Hello, The plain text football fixtures for leagues, teams, match schedules, stadiums, and more that you can read with the sportdb gem into an SQLite database e.g. football.db - thus, the project name ;-) - now includes the 2015/16 seasons for the English Premier League [1], the Deutsche

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, > what is the difference between major and minor? To quote from the pull request [1]: The idea is major are kind of "A" league and minor "B" league. For something more concrete - the tool is "A" league if it is open source (and works ;-)). Another is how popular (hard to say). Not sure

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, > It seems to me that it would be useful to include them, flagged as > "commercial only". Due to popular demand I started a "commercial only" awesome sqlite list [1]. For now entries are free (as in beer) ;-) Cheers. [1]

[sqlite] Looking for Ready-To-Use (Instant) SQLite Schema (and Sample Data) Scripts

Hello, As posted before I've started an awesome collection about all things SQLite [1]. One section collections ready-to-use (instant) SQLite schemas (and sample data) scripts. So far listed are: - football.db - teams, competitions, seasons, matches, goals, rounds, groups, etc. -

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, Thanks for the additions to the awesome-sqlite [1] list. I added the ODBC and JDBC drivers to a new middleware section, and the R driver to a new language binding section, and the R data frame package to a misc section. Note: For now commercial only tools (e.g. SQLite Analyzer) will

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, Thanks I've updated the awesome-sqlite list [1] and now includes a new section on SpatiaLite and more admin tools. Cheers. [1] https://github.com/planetopendata/awesome-sqlite

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Hello, I've started yet another awesome collection about - surprise, surprise - SQLite - inspired by the awesome- trend on GitHub that collects links on a single page - in Markdown e.g. README.md - in a git repo. What?s news? The awesome-sqlite repo collects SQLite goodies, tools, scripts,

[sqlite] [ANN] schemadoc 1.0 - auto-generate your SQLite database schema docu for tables, columns, etc.; incl. themes

Hello, I've put together a command line tool, that is, schemadoc [1] that lets you auto-generate your SQLite database schema docu for tables, columns, etc. The schemadoc tool connects to your SQLite database and writes out the schema info in database.json and also builds an a-z symbol index

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

Hello, Thanks. Good point. Will rename fields to columns in schema.json. Was trying initially to (re)use the Tabular Data Package format (in json) [1] from the Open Knowledge Foundation (OKFN) but it's not really a good fit. Sorry for the broken link. The schemadoc repo (that generates the

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

Hello, > I had something that I would use to draw a few pictures of the table schema... You're invited to share your code - my first version [1] is text-only so far. Always good to have some diagrams - a picture is worth a thousand words etc. ;-) Keep it up. Cheers. [1a] New schemadoc Ruby

Re: [sqlite] Looking for SQLite schema doc generator (in

Hello, Thanks for the pointer to the template. I'm using a plain HTML template w/ Liquid tags [1]. You can see a rendered (live) version online. [2] Thanks for the inspiration. Cheers. [1] https://github.com/book-templates/schema/blob/gh-pages/index.html [2]

Re: [sqlite] Looking for SQLite schema doc generator (in

Hello, > SQLite Toolbox Thanks for highlighting. The HTML pages for the schema looks great. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

Hello, I have started two hours ago ;-) to put together a little script. The idea is to "dump" the schema as json and then use a static site generator w/ html templates to generate the docu. So far the script that generates the json dump (is twenty lines of Ruby). You can see an example,

Re: [sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

Hello, Thanks. Good point. Wrapping into a html pre tag and it's a great cheat sheet as a single html page. Ideally looking for something with an index page, table cross-references as links, etc. Cheers. ___ sqlite-users mailing list

[sqlite] Looking for SQLite schema doc generator (in HTML) for tables, fields, etc

Hello, I'm looking for a little tool that reads in an SQLite schema (e.g. beer.db, football.db, etc.) and outputs (generates) documentation for tables, fields etc. as a single HTML page or as HTML pages.Any insight appreciated? Cheers. ___

[sqlite] [ANN] football.db - Public Domain SQLite Database Schema and Data (e.g. Premier League, World Cup, etc.)

Hello, FYI: First a big thanks to the wonder of SQLite. May I introduce football.db - a free open public domain football data project that offers its datasets as SQLite files, thus, the project name football.db (it's the actual single-all-in-one SQLite file/database that inspired it).