LinkDB: A complete dataset of public LinkedIn Profiles (and companies 😉)

DivineFavour — Mon, 10 Oct 2022 17:07:00 +0000

Hello everyone!!!!!! It's been so long 🥲 (almost a year) since I wrote and I am back!! I'll be writing more i'll try my best to write once a week or two ❤️. Want more info on the caption? Continue reading! 😊

As a Javascript developer or a developer in general, we're always looking for new projects to bump up our resume. Something new, exciting and has never been implemented before (that might turn to a startup 😂😂). Something to make you stand out from the crowd while recruiters are looking through your resume, well if you just learnt about API's and are looking for awesome data to plug into your app, you're very lucky to be reading this post 😉.

LinkDB is an awesome platform that'll provide you with millions of public LinkedIn profiles and companies for a small fee. If you're looking for test data, they will provide you with 10,000 random Canadian, Israel, Singapore, US, Brazilian or Indian profiles. They would also give you (for free) 10,000 random US, Singapore or Swedish company profiles. So gather round my developer friends, I'm not done 😉. For a paid version, you'd get:

Company Profile Endpoint
Company Lookup Endpoint
Company Lookup Endpoint
Employee Count Endpoint
Employee Listing Endpoint
Work Email Lookup Endpoint
Reverse Work Email Lookup Endpoint
Personal Contact Number Lookup Endpoint
Personal Email Lookup Endpoint
Disposable Email Endpoint
Jobs Listing Endpoint
Job Profile Endpoint
Personal Profile Endpoint
Personal Lookup Endpoint

and more... Check here for the full pricing details. For my developer friends, the free version is okay for any app of your choice, 10,000 looks enough 🌝. If you need more(planning to turn your app to a startup 😂😂), you can upgrade and get access to millions of LinkedIn profiles around the world ✨.

Who is LinkDB for??

Companies who has received Venture Capital of at least USD1M
Companies with more than 50 US/EU employees
Companies located in a country with a strong rule of law

Some queries you can perform with LinkDB:

Get all software engineers in San Francisco

SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.title == "Software Engineer" && @.location == "San Francisco").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Software Engineer San Francisco') -- general full text search
  AND parsed_data @> '{"experiences": [{"ends_at": null, "title": "Software Engineer", "location": "San Francisco"}]}' -- confirm

Find all employees working at Apple

SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company_linkedin_profile_url == "https://www.linkedin.com/company/apple/").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'https://www.linkedin.com/company/apple/')
  AND parsed_data @> '{"experiences": [{"ends_at": null, "company_linkedin_profile_url": "https://www.linkedin.com/company/apple/"}]}'

And many more! Click here for more info.

And that's it for today! I hope this article was helpful if it was not, I'm sorry to let you down but I'll try better next time. Until I write again, ❤️ Divine.

How to make a stunning README for your Github profile.

DivineFavour — Tue, 26 Oct 2021 20:58:57 +0000

Hi everyone 👋
I've not been writing for some time due to the preparations I've been making for the new school session. So, let's jump right into our story 👇

...From time to time, when you visit people's Github profiles, you may find amazing animations, pictures and fancy texts. All these are included in the new Github profile READMEs. In this article I'll show you how to make yours as stunning as theirs 😸

https://github.com/nmasi322/

Creating your README file

To create your README Github profile got to https://github.com/new and create a new repository. Name the repository with your username in that case, mine would be nmasi322/nmasi322 Now it's typed in, you will receive a message telling you about this secret/special repository.

This is all you need to do here. With that said, you can include any other files like code, pictures, GIFs etc.

Making it stand out

You now have your personal README profile, and you could just add your mail, social media links and toss it out for the world to see but guess what? YOUR PROFILE IS VERY BOOORRRIIINNNGGGG 😴💤. It's so boring that recruiters might just skip your profile, but I can help you style this profile in a few minutes. Just follow the steps below.👇

Your header

You can create a beautiful header at https://xscoder.com/ths/?ref=producthunt, which is where I created mine, or just have your writeup there.

Next, you should have a little introduction of yourself and what you do or love to do 👩‍💻

You can then add your social media link through which people can contact you. You can do it when editing your README file below. Press ctrl + k or command + k on your computer to show the link option. The title goes in the square brackets [], while the link goes in the parenthesis ().

Next is your different skills. Feel free to show the different skills which you have acquired in your field 🦚

Then, you can add your extra-curricular activities in the next section. I added my recent blogs in this section.

And finally you can add the special Github Profile Stats by pasting the link below in your README file.

[![My GitHub Stats](https://github-readme-stats.vercel.app/api/?username=YOUR_USERNAME&count_private=true&theme=react&showicons=true)]()

[![My GitHub Language Stats](https://github-readme-stats.vercel.app/api/top-langs/?username=YOUR_USERNAME&langs_count=5&theme=react)]()

[![My Contribution Stats](https://github-contribution-stats.vercel.app/api/?username=YOUR_USERNAME)](https://github.com/YOUR_USERNAME/github-contribution-stats/)

Replace YOUR_USERNAME with your Github profile username. You can pin your repositories below your README file and this is how you do it.

At the top right corner of your profile, click "Your Profile"
Move down to "Customize your pins"
Click on the pins you wish to pin to your profile and voila! Your awesome profile is now complete. Don't forget to regularly create repos or projects and upload them to your Github account.

I hope this article was helpful if it was not, I'm sorry to let you down but I'll try better next time. Until I write again, ❤️ Divine.