Questions about the upcoming database version

[Brian_Arrigo]

I’m increasingly using the PDF reader (with highlights) and the Whiteboard. How will the DB version impact these features?

[alex0]

• Will DB version improve multi-window mode too? I guess yes.

• Will the bi-directional sync with MD files be available (optionally) with the Web version too? It would make Logseq 100% local-first even when you can’t install anything natively.

• Will the bi-directional sync with MD files be available on mobile platforms too?

• Will the bi-directional sync write to MD files also the schema for the new properties templates (like types, cardinality etc)? It would help a lot with refactoring.

• Do you have any plan to support other formats for bidirectional sync, like CSV for tables and query results or YAML for the schema mentioned above?

• Will plugins be able to add custom properties to blocks that won’t appear in MD files? It would be useful for those plugins that perform sync with other services like Todoist without polluting MD files with “meta” properties.

• Could there be an option to resolve queries results when writing to MD files? I mean query results being readable in MD files and if you edit them manually with a text editor the original block is updated.

[Raistlin]

I’ve built a really nifty and fairly robust system to two-way sync logseq tasks with Apple iOS Reminders via Shortcuts and iCloud (my logseq drive is hosted in icloud for this purpose). Will we be able to ask Logseq to use the database for 90% of content, but mark a few topics / files as MD only so automations like my system can continue to work?

PS happy to share my Shortcuts setup if there is interest … it took a while to get working robustly!

[BBob]

Will the DB version mean it’s more likely we might also get the option for true WYSIWYG editing experience?

WYSIWYG editing mode

Just started trying out Logseq. Looks very powerful. The only big obstacle for me is the lack of WYSIWYG editing. I understand Markdown has many benefits, but some of us prefer to view and edit formatted text. Surprisingly, I haven’t found a feature request for this here (the only related one I found is this one, but it’s not about editing). I’m new here, so please let me know if I’m missing something! Maybe there is some huge discussion about this under a different term other than “WYSIWG”? T…

[fegfeg]

fyi i built a shortcut with reminders sync using the Logseq API, could (?) work with the DB version. Here: GitHub - flegfleg/logseq-reminders-sync: Shortcuts to sync tasks (with deadlines) between Logseq and Apple Reminders
It syncs task name, due date, status to reminders, and then task status (TODO, DONE) back to Logseq (omitting any changes to name and due date), but it could be reworked for a complete sync.

[logseqfanboy]

Looks like the web version will be powerful. Super excited to get my hands on it.

Will we be able to self-host it? I mean will we be able to host that sqlite database on the server alongwith the app? (to ensure smooth sync for free users?)

And will we still have git sync?

[haudrauf]

That’s an absolute important question- for me, having .md files is one major requirement, I don‘t want/ need a DB version, is it still being maintained?

[BBob]

Currently a query result is just a static output of the relevant content.

With the db version, will it be possible to edit the actual values, directly within a query result in table view?

For example, say I have hundreds of blocks representing books, each with a property for author. Then I do a live query showing all these books in a table, including a column for author. Then I would be able to change the authors names directly in that table (as in a spreadsheet software).

[johnhill]

How will version control (git) work with the DB version? I rely on git for incremental backup and tracking changes. This is trivially easy to do when working with clear text / markdown.

[alex0]

@logseqfanboy

Will we be able to self-host it? I mean will we be able to host that sqlite database on the server alongwith the app?

You already can if you know how to do it, the branch on GitHub is feat/db.

[zizhuo]

I want to know if the page in the database version can be easily converted into PDF for sharing、printing. The export effect of the current plug -in is average and there is a linked jump failure.

[4r73m190r0s]

When Logseq implements database as a way of storing the data, does that mean that file will no longer be in plaintext? I’m asking this mostly for GIt syncing.

[Synchronicity]

Will the database version support CloudKit?

This announcement is very good news. Thank you! Logseq is the best app I’ve ever tried for managing tasks and keeping short-term task and project related notes. I was very sorry to have to stop using it due to syncing issues and data loss, and hope the new database storage will enable me to use it again. When the database version is released, will the Mac and iOS apps support CloudKit? In my experience, those that do sync more reliably than those that don’t.

[FlorianF]

Will there be a truly Portable version along the other installers? We need not install Logseq on all the devices we touch for privacy reasons. Also I don’t want any data to be left on a device where I start Logseq to note down journal entries along PKM and Task Management entries …

[4r73m190r0s]

I never worked with databases except doing simple queries, and was wondering how is data stored in a file system? I guess it’s not one file representing one page. Where can I learn more about this, i.e. database and how is data stored on a filesystem.

[alex0]

SQLite uses a single file while PostgreSQL for example multiple files. I think Logseq will just use a single file.

[Clement]

Hi,

Do you think the database version will facilitate the migration from Roam Research?
I am asking because the migration process is taking me much more effort than I originally thought. This is due to two main issues:

• File name limitations on multiple platforms: I use MacOS, Android and IpadOS, meaning that I have to rename many of my pages to store them on all devices.
• I’m also extensively using nested page titles that are badly managed in Logseq.

I have the intuition that the database version could directly solve the first issue and maybe help with the second one. But if not, I’m interesting to know to avoid waiting in vain
Since many people seems to also consider migrating, this could be useful information in general.

Thank you

[BBob]

When are we getting the replies for these?