Skip to main content

In the process of returning to the University of Reunion Island as a student,
I'm eager to learn more about computer science and logic programming in particular.

I've worked for small-to-medium enterprises
in the Greater Metropolitan Paris Area for about 10 years,
and today I offer consulting services as
a part-time freelance software developer to earn a living.

mastodon.cloud/@sh4l

gitlab.com/thierrymarianne

sioukam_re

stackoverflow.com/users/282073

thierrymarianne

pronoun.is/they/.../themselves

pronoun.is/he

thierrymarianne

keys.openpgp.org/search?q=663A+84F6+7BA2+3675

sioukam.substack.com

 

#Lumen - Your database timezone set to "+00:00" by default with Lumen

2 min read

When running a command-line with artisan, I had time-dependent queries which never returned the affected rows I was expecting. I had this command precisely running at 00:01 every morning. 

By scheduling the task three hours later or by launching it manually in the morning, I was provided with the correct results. That's how I figured something was off with regards to the application timezone.

At first, I set the environment variable APP_TIMEZONE value to Europe/Paris in .env according to my context of execution. Unfortunately, it was not the solution to my problem.

Since we're dealing with open source code, why not exploring the vendors?

grep -rn timezone ./vendor

resulting in this specific match (among many others)

./vendor/illuminate/database/Connectors/MySqlConnector.php:43:        if (isset($config['timezone'])) { 

The following keywords submitted to DuckDuckGo led me to the right solution :

https://github.com/laravel/lumen-framework/issues/50
https://github.com/laravel/lumen/pull/32/files

The following setting was missing from my application .env file 

DB_TIMEZONE=+02:00

 

#2FA - How to make a backup of secrets stored in Google Authentication app (Android)?

1 min read

  1. Enable USB debugging in the phone developer options
  2. Pull the SQLite database using adb  
    adb pull /data/data/com.google.android.apps.authenticator2/databases
  3. Extract the database records using an SQLite client 
    sqlite3 database 
    .dump accounts
  4. Save the output in a reasonably safe place (for instance store it in a lastpass secure note)


See also http://dpron.com/3-ways-to-move-google-authenticator/

 

#MySQL - How to prevent a MySQL database from writing binary l ogs?

1 min read

To decommission an old server running a replicated MySQL database,
I had to prevent the (master) database from writing binary logs.

I figured I would need to

 

How to tab between buttons on a OS X dialog box?
Don't use tab key but command key combos instead.

CMD + first letter of button label

http://superuser.com/a/547501/29518
http://superuser.com/a/176003/29518

 
 

@nitot talks about societal & personal risks related to silos, socnets, smartphones at @MozillaParis

 

A dynamic feature flag system needs context.
* User Information
* Request Information

via @beberlei at

 

@beberlei is now introducing how generic and reusable feature flags (with Symfony) can be at with examples of payment system.

He referred to

["Flipping out" by Flickr (2009)](http://code.flickr.net/2009/12/02/flipping-out) and also
["Feature toggle" by Marting Fowler (2010)](http://martinfowler.com/bliki/FeatureToggle.html)
["Feature Toggles in Symfony" by labs @ Qandidate.com](http://labs.qandidate.com/blog/2014/09/04/feature-toggles-in-symfony2/)

 

~"I can see this is a developer conference as I'm the only one wearing a jacket"~ via @yoavkutner

 

[Most important page on Symfony.com The first time experience](http://symfony.com/fr/download)
The users / developers should not be bothered by tones of distinct versions even before using the Symfony full-stack framework via @fabpot