Jump to content
You must now use your email address to sign in [click for more info] ×

Search the Community

Showing results for tags 'sqlite'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Affinity Support
    • News and Information
    • Frequently Asked Questions
    • Affinity Support & Questions
    • Feedback & Suggestions
  • Learn and Share
    • Tutorials (Staff and Customer Created Tutorials)
    • Share your work
    • Resources
  • Bug Reporting
    • V2 Bugs found on macOS
    • V2 Bugs found on Windows
    • V2 Bugs found on iPad
    • Reports of Bugs in Affinity Version 1 applications
  • Beta Software Forums
    • 2.5 Beta New Features and Improvements
    • Other New Bugs and Issues in the Betas
    • Beta Software Program Members Area
    • [ARCHIVE] Reports from earlier Affinity betas

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Website URL



Member Title

Found 1 result

  1. More than once I encountered problems with the stability of publisher. It started in the time Publisher still was a beta product. Then some form of recovery was added and sometimes it works. But now, working on a book with 300 pages and needing to add 1 page and next removing 1 page again Publisher just quits. With a limited number of pages it works fine. Then when carefully adding pages it still works fine. And starting to use master pages, changing etc the problems appears again. When using the last saved version, I find that the problem is saved with the file so, falling back to the previous version is no option. It makes me feel very unsafe. It also made me think how to make a publishing program that is really stable, whatever size. Thats's part 1 I also use a program called RightNote. It is stable can contain an awfull lot of notes in very many formats Excel like, Word Like, copies of internet pages. I don't say the program never fails. But the data is always correct. They use SQLite for storing there information. SQLite runs on Windows, Mac, iOS and more... As far as I know the systemdatabase of Apple is also based on SQLite, which means it has to be very stable. That's part 2 Putting the parts together: I want to have an extremely stable publisher program. And I love Publisher, as a rose with thorns... My suggestion is not a small one, and I don't know how Publisher works internally. But wouldn't it be a good idea to change the way of working and let it work with on a SQLite datbase? With at the core 3 tables: Pages Spreads Resources When starting from scratch creating a SQLite database file When opening it again first making a copy of the database and then opening this session database If each time a page is changed and the page is abandoned, saving the page to the database When changing the spread (reference between 2 (or more) pages) saving that record. When adding/changing internal or external resources changing that table (with either the link or the content) saving it to the resources table. If the program crashes: almost everything will be saved. If it would crash om an update to the database: SQLite has enough recovery tools I think. You could have a construction to make extremely large documents (terabytes they say). And even add lots of internal resources. You could also make a separate repository file for the resources (and share them with Designer, Phote or a PDF reader)...
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.