So many projects, so little time...

6 months... My last post was 6 month ago.

The thing is, writing a simple article takes time. English is not my mother tongue and everything is longer when you have to check every sentence trice !

Anyway, it has never been about stopping my posts here. I try to accomodate my family life, my work and my many projects, and it leaves me about zero minutes to posts about all of this.

Today I found some time... I got a new dog and I don't like to leave her alone when I home. I already spend a lot of time home working in my office while she's waiting downstair. So, why not taking some time to write a bit, sitting next to her!

That's her !
Her name's Lily ! She's a Continental Bulldog. A perfect breed! I'll probably make a post in pets lovers about her!

But hey, that's not the point !

What Have I Been Up To ?

As my title says, I have been working on many different projects in the past 6 months. Let's have a little look at those.

A Patient file for my wife

When I met my now wife, 7 years ago, she was using a piece of software one of her teacher gave her to manage her patients file (she's an osteopath). It was a kind of Access database, on MacOS. But soon after, a MacOS update broke the software and I decided to write a little soft for her. It started as a Mono project and she's been using it for almost 5 years now.
But recently, I found myself struggling to develop and maintain the software.
So I decided to rewrite everything using Electron.JS (the multiplatform ability was mandatory). This is the project that consumed so much of my time lately !

The baby's not nice, but it works ! (I hid the names on the screenshot cause they are real persons)

What did I learn :

  • the use of npm
  • the use of yarn
  • promises in Javascript

An auto voter for Hive

Yeah, I know, that's not exactly the spirit of this blockchain. But I'm a tech enthusiast and I like to push my limits and try new stuff.

The system is quite simple but it took a long time to put in place.
Here's the conceptual architecture :

My voter architecture

I use the HiveSQL service to retrieve posts and author informations with Talend and feed a MariaDB with the necessary data.
There's a simple machine Learning algorithm (random forest) whose job is to indentify the best performing posts.
Then a python script gets the latest post, enrich them, call the model for prediction and then decide to vote or not.

Once again, it works. It ain't beautiful, but it works !
All this is running on a Raspberry Pi 3, leading us to the next project.

What did I learn :

  • More Python scripting
  • Use of virtualenv
  • The mess with the different versions of everything related to Python
  • Declaring a service in Linux (that was actually easy !)

A Raspberry Pi server

Using an old TV box that was abandonned at my parents house I set up a little server for my personal projects.
Specs :

  • Raspberry Pi 3,
  • 32Gb Micro-SD card
  • 250Gb SSD on USB
  • a powerful transformer

I set up a static internal ip and port forwarding to access it through SSH with private keys only. There's a no-ip like service on the fiber box, allowing me to access it from anywhere.

The GPIO are connected to the front panel buttons, but I did not implement the necessary tools to take advantage of it, yet.

My dream is to finally find a Raspberry Pi 4 (4Gb) at the official price and boost my little server.

What did I learn :

  • Nothing really new ^^

A VSCode extension for Terraform & BigQuery

I work everyday with Terraform and BigQuery at my work.
There were many repetitive and boring activities, so I began to develop a little extension to increase my productivity.

I'm rewriting parts of the code now, because my terraform locals analysis was not very efficient: it was limited to string, and crashed with integers and conditional formatting.

At the moment, it can dry run a BigQuery query, retrieve the format from a query, handle terraform workspace and replace terraform variables in a query.

It still needs a lot of work !

What did I learn :

  • Typescript (I love it, so much better than plain JS)
  • VSCode extension internals
  • Many JS/TS tricks

Conclusion

So, that's it!
This explain why I could not post more.
I'll try to be a bit more active and share my future projects with you.
There's one in particular that could interest the dev community on Hive (I hope ^^ )

I'll be happy to exchange with you about those projects if you have any question !!

Sort:  

Interesting projects. I can see almost all the projects are done with different technologies, which shows how versatile your coding knowledge is. I find it disturbing using different tech stacks at the same time so I always make sure I stick to one.

Thank you !
The thing is I'm the "Jack of all trades, master of none" kind of guy. I learned programming when I was 15 before having an internet connection. My first lines of code where QBasic I remember!
Then learned some html, and made my first website. C++ and VB5 at school. Then PHP4 JavaScript and MySQL. That's actually what slowly lead me to the Data field.
My coding skills are actually quite bad, my code is probably a real mess.
I don't "code" for a living and the only things I dare to consider being almost an expert at ("advanced user" as one of my colleagues would say) are SQL and understanding business through raw data.
That's ok cause that's my job!
The rest (Python, JS/TS, Talend, Stambia...) are technology I used to practice in the past or Hobbies.
That's probably why my skill set is getting used differently recently.
I now pre-process the business needs, provide a global data sources and architecture analysis, give an approximate workload, identify the best resources in the team and hand it over to my colleagues.
Rest of the time is being a "firefighter" on any subject that needs helps.
So don't be too impressed, those projects are made with shitty code and a lot of Google searches !
But I have fun 😊!

Jack of all trades indeed. With all these technologies you have mentioned, I know you have gained enough experience to do your own stuff. That is one thing I love about coding. Even if you don't intend to make a career out of it, you can still have fun with it. I learnt QBASIC on my my semester in the university, it was boring to me though

I now pre-process the business needs, provide a global data source and architecture analysis, give an approximate workload, identify the best resources in the team, and hand it over to my colleagues.

I love your job. It sounds interesting. It's something I will enjoy a lot if I have the opportunity. One difficulty in striving as a newbie developer is the lack of opportunities. There are not enough developer jobs here

Cheers friend. I wish you a nice time with your family

QBasic is so old that it was already old when I learned it 20 years ago !!! I understand you did not enjoy it !

Getting the first jobs is always a challenge. Don't hesitate to promote your work and your dev related hive posts directly on LinkedIn. It may be noticed by a recruiter and give you access to a good freelance job !

Continue learning and try stuff ! It's always rewarding !!

Enjoy the weekend as well !

Lily is lovely ❤️

Hehe! Thank you ^^ I'll try to post something about her and her breed today or tomorrow!
And thank you for the mention ! I discovered discovery-it today thanks to you

You are very welcome 🤗

Congratulations!


You have obtained a vote from CHESS BROTHERS PROJECT

✅ Good job. Your post has been appreciated and has received support from CHESS BROTHERS ♔ 💪


♟ We invite you to use our hashtag #chessbrothers and learn more about us.

♟♟ You can also reach us on our Discord server and promote your posts there.

♟♟♟ Consider joining our curation trail so we work as a team and you get rewards automatically.

♞♟ Check out our @chessbrotherspro account to learn about the curation process carried out daily by our team.


🏅 If you want to earn profits with your HP delegation and support our project, we invite you to join the Master Investor plan. Here you can learn how to do it.


Kindly

The CHESS BROTHERS team

Congratulations @cocaaladioxine! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

You received more than 900 upvotes.
Your next target is to reach 1000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out our last posts:

The Hive Gamification Proposal
Support the HiveBuzz project. Vote for our proposal!


The rewards earned on this comment will go directly to the people( @cocaaladioxine ) sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.

!discovery 25


This post was shared and voted inside the discord by the curators team of discovery-it
Join our Community and follow our Curation Trail
Discovery-it is also a Witness, vote for us here
Delegate to us for passive income. Check our 80% fee-back Program

Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!

Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).

You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.