Cycle London <[email protected]> writes: > Doesn't look similar to me... > > [cyclelondon@weather ~]$ sqlite3 > SQLite version 3.7.17 2013-05-20 00:56:22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> show databases ; > Error: near "show": syntax error > sqlite> show tables ; > Error: near "show": syntax error
Standard sql is the same. nonstandard extensions are different, but you can do the same things. Each database is a file, so there is no notion of show databases. "man sqlite3" will explain many things. But ".tables" will do what you want. In all seriousness, if you understand mysql, you can figure out how to do what you want in sqlite in well under an hour. If sqlite is adequate in terms of size, which it certainly is a year in, then it is vastly simpler. Think about reliability and weewx being able to store new data as archive records happen. So you really want a local db, that is guaranteed to be up if weewx is up. -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
