Bug + Enhancement ideas

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug + Enhancement ideas

Andrew Paullin
Hello SQLite Team,

Thank you very much for such a great product.

Here are a few Enhancement ideas:

On page:
https://sqlite.org/cli.html

in section 10, idea to add:

sqlite3 db_good.db < corrupt_db_export.sql

as an example of how to restore a database.

Also perhaps mention about how this export file can end with
"ROLLBACK", which needs to be changed to "COMMIT" to work properly.

Also, on page:

http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

in my opinion the statement:

"The current archive is only available to the list members."

is a bug, and the preceding link should instead go to:

http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org

as indicated on this page:

http://www.sqlite.org/src/wiki?name=Bug+Reports

Or, perhaps these archives are different, and I am unaware of such
differences, in which cases in my opinion an Enhancement could be made
to explain those differences. I recently signed up for the mailing
list, so perhaps once I can login to the first archives page the
differences will become clear to me.

Just ideas :^)

I searched the existing bugs, the documentation, and also other forums
like stackoverflow for the bug, though may have missed.

Thank you again and best regards,

Andrew Paullin
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bug + Enhancement ideas

Andrew Paullin
oh, and also perhaps a ".import" command would be a good compliment to ".dump".

Just an idea...



On Fri, Aug 25, 2017 at 11:02 PM, Andrew Paullin
<[hidden email]> wrote:

> Hello SQLite Team,
>
> Thank you very much for such a great product.
>
> Here are a few Enhancement ideas:
>
> On page:
> https://sqlite.org/cli.html
>
> in section 10, idea to add:
>
> sqlite3 db_good.db < corrupt_db_export.sql
>
> as an example of how to restore a database.
>
> Also perhaps mention about how this export file can end with
> "ROLLBACK", which needs to be changed to "COMMIT" to work properly.
>
> Also, on page:
>
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> in my opinion the statement:
>
> "The current archive is only available to the list members."
>
> is a bug, and the preceding link should instead go to:
>
> http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org
>
> as indicated on this page:
>
> http://www.sqlite.org/src/wiki?name=Bug+Reports
>
> Or, perhaps these archives are different, and I am unaware of such
> differences, in which cases in my opinion an Enhancement could be made
> to explain those differences. I recently signed up for the mailing
> list, so perhaps once I can login to the first archives page the
> differences will become clear to me.
>
> Just ideas :^)
>
> I searched the existing bugs, the documentation, and also other forums
> like stackoverflow for the bug, though may have missed.
>
> Thank you again and best regards,
>
> Andrew Paullin
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bug + Enhancement ideas

Keith Medcalf

you can use .read to read the .dump file.

.read <file> reads a file containing SQL statements and executes them
.import <file> <table> import data from a CSV file <file> into table <table>

Since .dump writes the output as an executable SQL script, the opposite function is performed by .read

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users [mailto:sqlite-users-
>[hidden email]] On Behalf Of Andrew Paullin
>Sent: Friday, 25 August, 2017 22:06
>To: [hidden email]
>Subject: Re: [sqlite] Bug + Enhancement ideas
>
>oh, and also perhaps a ".import" command would be a good compliment
>to ".dump".
>
>Just an idea...
>
>
>
>On Fri, Aug 25, 2017 at 11:02 PM, Andrew Paullin
><[hidden email]> wrote:
>> Hello SQLite Team,
>>
>> Thank you very much for such a great product.
>>
>> Here are a few Enhancement ideas:
>>
>> On page:
>> https://sqlite.org/cli.html
>>
>> in section 10, idea to add:
>>
>> sqlite3 db_good.db < corrupt_db_export.sql
>>
>> as an example of how to restore a database.
>>
>> Also perhaps mention about how this export file can end with
>> "ROLLBACK", which needs to be changed to "COMMIT" to work properly.
>>
>> Also, on page:
>>
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-
>users
>>
>> in my opinion the statement:
>>
>> "The current archive is only available to the list members."
>>
>> is a bug, and the preceding link should instead go to:
>>
>> http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org
>>
>> as indicated on this page:
>>
>> http://www.sqlite.org/src/wiki?name=Bug+Reports
>>
>> Or, perhaps these archives are different, and I am unaware of such
>> differences, in which cases in my opinion an Enhancement could be
>made
>> to explain those differences. I recently signed up for the mailing
>> list, so perhaps once I can login to the first archives page the
>> differences will become clear to me.
>>
>> Just ideas :^)
>>
>> I searched the existing bugs, the documentation, and also other
>forums
>> like stackoverflow for the bug, though may have missed.
>>
>> Thank you again and best regards,
>>
>> Andrew Paullin
>_______________________________________________
>sqlite-users mailing list
>[hidden email]
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users