To create a new database you just open the file name you want, and if it doesn't exist it will be created.
The actual new file creation is slightly delayed until it has to write something to the disk. There are a couple of options that can only be set at file creation time like page size, text encoding, file format, etc. So if you wanted any non-default settings for those you would set those first thing after opening it and before doing anything else, so that they are set _before_ the actual file itself is created. -----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of Andy Sent: Tuesday, January 7, 2020 9:23 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] How create database, tables,indices... I see: http://zetcode.com/db/sqlitec/ New database is simply open not existing file in path? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
