Re: Which version of SQLite?
Richard Owlett wrote: On 08/05/2018 11:49 AM, Dirk Munk wrote: Richard Owlett wrote: On 08/04/2018 10:40 AM, Mason83 wrote: On 04/08/2018 11:21, Dirk Munk wrote: Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? I couldn't find the answer, but these links might provide some information: https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_Operational_Information_Database:_SQLite https://developer.mozilla.org/en-US/docs/Mozilla/Tech/XPCOM/Storage Regards. Don't know if it solves the OP's problem. But you may have "rattled my cage" in right direction to solve one of mine ;} I've been trying to have bookmarks available to outside applications. SeaMonkey uses JSON if you want all the data. HTML export loses some implied data for *MY* purposes. What's comical is my current destination program [CherryTree {http://www.giuspen.com/cherrytree/}] uses SQLite natively. So importing relevant information should be much more straight forward, even I don't know SQLite *YET* ! *THANK YOU* I installed SQLiteStudio for Windows, but I see you're using Linux. It is evidently available as an Ubuntu PPA, but I'm using Debian. I'm investigating for an approved method for installing from A PPA. I've found some methods but they have too much "hand waving" for me to attempt comfortably. I have an old WinXP machine. Is that suitable for the Windows version? According to heir web page, yes, is should work under XP as well. Thank you. When I want to open a database, SQLiteStudio wants to know if it is an SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it would be nice to know which version Seamonkey is usin. The supplies links are not helpful in that respect, they are about SQLite in general. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
On 08/06/2018 04:53 AM, Michael Garibaldi wrote: Dirk Munk wrote in news:eosdnxqyqaeyt_rgnz2dnuu7-s3nn...@mozilla.org: Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? I installed SQLiteStudio for Windows, but I see you're using Linux. When I want to open a database, SQLiteStudio wants to know if it is an SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it would be nice to know which version Seamonkey is usin. From direct experience I can tell you that Mozilla use SQLite 3. I would also recommend that you make a copy of the file and work on that rather than risk damaging the file used by SeaMonkey. PS: SQLite uses the standard SQL commands with the exception of anything client/server related. I suggest you learn some SQL and also take a look at http://www.sqlite.org/lang.html I've been to that site but haven't landed on that page. A quick browse suggests it will lead to answered confused questions. The last time I was concerned with the guts of a database we were running dDaseII on a PC-XT under MS-DOS ;/ Thank you. Good luck. I'll need it ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
On 08/05/2018 11:49 AM, Dirk Munk wrote: Richard Owlett wrote: On 08/04/2018 10:40 AM, Mason83 wrote: On 04/08/2018 11:21, Dirk Munk wrote: Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? I couldn't find the answer, but these links might provide some information: https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_Operational_Information_Database:_SQLite https://developer.mozilla.org/en-US/docs/Mozilla/Tech/XPCOM/Storage Regards. Don't know if it solves the OP's problem. But you may have "rattled my cage" in right direction to solve one of mine ;} I've been trying to have bookmarks available to outside applications. SeaMonkey uses JSON if you want all the data. HTML export loses some implied data for *MY* purposes. What's comical is my current destination program [CherryTree {http://www.giuspen.com/cherrytree/}] uses SQLite natively. So importing relevant information should be much more straight forward, even I don't know SQLite *YET* ! *THANK YOU* I installed SQLiteStudio for Windows, but I see you're using Linux. It is evidently available as an Ubuntu PPA, but I'm using Debian. I'm investigating for an approved method for installing from A PPA. I've found some methods but they have too much "hand waving" for me to attempt comfortably. I have an old WinXP machine. Is that suitable for the Windows version? Thank you. When I want to open a database, SQLiteStudio wants to know if it is an SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it would be nice to know which version Seamonkey is usin. The supplies links are not helpful in that respect, they are about SQLite in general. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
Dirk Munk wrote in news:eosdnxqyqaeyt_rgnz2dnuu7-s3nn...@mozilla.org: >>> Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? > I installed SQLiteStudio for Windows, but I see you're using Linux. > > When I want to open a database, SQLiteStudio wants to know if it is an > SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it > would be nice to know which version Seamonkey is usin. >From direct experience I can tell you that Mozilla use SQLite 3. I would also recommend that you make a copy of the file and work on that rather than risk damaging the file used by SeaMonkey. PS: SQLite uses the standard SQL commands with the exception of anything client/server related. I suggest you learn some SQL and also take a look at http://www.sqlite.org/lang.html Good luck. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
On 05/08/2018 18:49, Dirk Munk wrote: > When I want to open a database, SQLiteStudio wants to know if it is an > SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it > would be nice to know which version Seamonkey is usin. Why don't you just make a copy of the SQLite files in a temporary directory, and use your program on the copies? ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
Richard Owlett wrote: On 08/04/2018 10:40 AM, Mason83 wrote: On 04/08/2018 11:21, Dirk Munk wrote: Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? I couldn't find the answer, but these links might provide some information: https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_Operational_Information_Database:_SQLite https://developer.mozilla.org/en-US/docs/Mozilla/Tech/XPCOM/Storage Regards. Don't know if it solves the OP's problem. But you may have "rattled my cage" in right direction to solve one of mine ;} I've been trying to have bookmarks available to outside applications. SeaMonkey uses JSON if you want all the data. HTML export loses some implied data for *MY* purposes. What's comical is my current destination program [CherryTree {http://www.giuspen.com/cherrytree/}] uses SQLite natively. So importing relevant information should be much more straight forward, even I don't know SQLite *YET* ! *THANK YOU* I installed SQLiteStudio for Windows, but I see you're using Linux. When I want to open a database, SQLiteStudio wants to know if it is an SQLite 2 or SQLite 3 database. I don't want to corrupt anything, so it would be nice to know which version Seamonkey is usin. The supplies links are not helpful in that respect, they are about SQLite in general. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
On 08/04/2018 10:40 AM, Mason83 wrote: On 04/08/2018 11:21, Dirk Munk wrote: Seamonkey is using SQLlite for its own 'housekeeping'. Which version is it using? I couldn't find the answer, but these links might provide some information: https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_Operational_Information_Database:_SQLite https://developer.mozilla.org/en-US/docs/Mozilla/Tech/XPCOM/Storage Regards. Don't know if it solves the OP's problem. But you may have "rattled my cage" in right direction to solve one of mine ;} I've been trying to have bookmarks available to outside applications. SeaMonkey uses JSON if you want all the data. HTML export loses some implied data for *MY* purposes. What's comical is my current destination program [CherryTree {http://www.giuspen.com/cherrytree/}] uses SQLite natively. So importing relevant information should be much more straight forward, even I don't know SQLite *YET* ! *THANK YOU* ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Which version of SQLite?
On 04/08/2018 11:21, Dirk Munk wrote: > Seamonkey is using SQLlite for its own 'housekeeping'. > > Which version is it using? I couldn't find the answer, but these links might provide some information: https://developer.mozilla.org/en-US/docs/Mozilla/Firefox_Operational_Information_Database:_SQLite https://developer.mozilla.org/en-US/docs/Mozilla/Tech/XPCOM/Storage Regards. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey