We are starting to grow - Thanks StackIdeas !

Hi Mark and the team.

First of all i want to start with a huge "THANK YOU" for all these years i've been a StackIdeas customer leveraging your software to build an MVP and validate our idea.

You guys are the most awesome team in the Joomla world delivering great products and providing unmatched level of support (trust me, i worked with a lot of paid extensions so far) and i really stand by this statement.

You helped me countless times giving me solutions for the problems i had even if sometimes these were out of the scope of support. This showed me that you have a desire to help people achieving their goals using your products, not only to sell subscriptions.

We started to grow and we noticed that we need stuff to be built our own way. We need our own codebase, we need to control code decision thus providing stability for long-term.

Long story short, we are building our own platform using Laravel Framework. This doesn't mean i don't love you ! It's just about time to move forward.

I need a little bit of help migrating some existing data from EasySocial into our custom platform.

1. User Avatars

How the user avatars are stored in the DB and how i can retrieve the avatar files in order to migrate them ?
I know that EasySocial have few avatar sizes available, we want to migrate the biggest size (i think it's the "large" size)

Can you help me with a query example for a particular joomla user id ?

2. User Followers

Where and how EasySocial store the follower's for each user and how can i retrieve them?
Can you help me with a query example for this aswell for a particular joomla user id ?

3. Profile Data

I noticed that the profile data (profile custom fields) are stored in the table "_social_fields_data"
There is a "datakey" column that acts as an identifier for the data type
So, for the user's city i have the datakey "city" but some of the datakeys are empty (ex: for the user's website or user's "about me" field) and i need to extract data for those aswell.

Can you help me with a query example here aswell ?

4. Comments

I used EasySocial comments inside Joomla articles and we need to migrate all these comments aswell.
I noticed that comments are store in the _social_comment table where "uid" is the joomla article ID and "created_by" is the user id (comment author).

Is this correct ? There are any other things to consider regarding comments migration ?

Thanks so much in advance and thank you, really thank you for all these years !