pablo (Pablo Sanchez)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Jan 31 2018, 4:47 PM (50 w, 3 d)
Availability
Available

Recent Activity

Mar 21 2018

pablo added a comment to T7014: Make Indexing Great Again.

We should ensure indexing works well with extremely large number of email messages. I had to disable Thunderbird's index database (they use SQL Lite3 - I think) because every time I received a new email, TB would stop for 1/2 - 1 while it managed the index database.

Mar 21 2018, 8:35 PM · KDE PIM

Mar 9 2018

pablo added a comment to T8150: SQL analysis > kmail2 > initial get email.

Hey Dan,

Mar 9 2018, 10:22 PM

Mar 6 2018

pablo added a comment to T8150: SQL analysis > kmail2 > initial get email.

As I was preparing to strip the search-arguments I noticed many repeated SQL calls within the thread_id's (each independent SQL connection).

Mar 6 2018, 3:48 PM

Mar 5 2018

pablo created T8150: SQL analysis > kmail2 > initial get email.
Mar 5 2018, 7:52 PM

Feb 5 2018

pablo added a comment to T7846: akonadi > MySQL ERD Review.

Optional Parent FK's

Feb 5 2018, 8:24 PM
pablo added a comment to T7846: akonadi > MySQL ERD Review.

Ah, so do we want to do this as it gives each [ResourceTable] row the option to create its own [CollectionAttributeTypeTable] rows.

Feb 5 2018, 7:00 PM
pablo added a comment to T7846: akonadi > MySQL ERD Review.

I'm not sure what you mean by "does each [ResourceTable] get its own" - there's only one [ResourceTable] - if you are asking if each Resource in the [ResourceTable] gets it's own "domain" then no, all Resources share the same table space.

Feb 5 2018, 6:51 PM
pablo added a comment to T7874: akonadi > MySQL configuration settings.

Assuming you only lose your database, just creating a new database

Feb 5 2018, 6:46 PM
pablo added a comment to T7846: akonadi > MySQL ERD Review.

We can normalize the [CollectionAttributeTable].type column by moving the key names to their own table like we do in [PartTable] as suggested in the link, but that's about all that I could find there that would apply in our case.

Feb 5 2018, 5:46 PM
pablo added a comment to T7874: akonadi > MySQL configuration settings.

Hey Daniel, I like the idea of having a GUI to allow users to tweak the DBMS settings!

Feb 5 2018, 5:34 PM
pablo added a comment to T7846: akonadi > MySQL ERD Review.

Flags should be NOT NULL

Feb 5 2018, 3:46 PM
pablo added a comment to T7874: akonadi > MySQL configuration settings.

Hi Sandro,

Feb 5 2018, 12:48 AM

Feb 3 2018

pablo triaged T7874: akonadi > MySQL configuration settings as Normal priority.
Feb 3 2018, 10:43 PM
pablo added a comment to T7846: akonadi > MySQL ERD Review.

I have attached the latest ERD's. These are printer-friendly (no color). I had to jig the ERD tool's XML file for MySQL.

Feb 3 2018, 10:23 PM

Feb 2 2018

pablo added a comment to T7846: akonadi > MySQL ERD Review.

I've spot-checked the ERD's and they appear to be correct based on the provided SQL. In fact, I pointed the ERD tool to my Neon VM and told it to reverse engineer the run-time akonadi database.

Feb 2 2018, 1:38 AM

Feb 1 2018

pablo added a comment to T7846: akonadi > MySQL ERD Review.

A good way to easily share the MySQL local Instance.

Feb 1 2018, 2:20 AM

Jan 31 2018

pablo added a comment to T7846: akonadi > MySQL ERD Review.

Whaddya know! :) .. however the ERD in the documentation doesn't quite match the table names. I suppose it's like a Logical Model

Jan 31 2018, 8:56 PM
pablo updated the task description for T7846: akonadi > MySQL ERD Review.
Jan 31 2018, 8:10 PM
pablo triaged T7846: akonadi > MySQL ERD Review as Normal priority.
Jan 31 2018, 8:09 PM