<p>I&#39;ve had problems sleeping for as long as I can remember and this has made it hard for me to keep my brain functioning properly and getting me addicted to solutions like Hot Chocolate with Caffeine and/or Coffee to keep me up for as long as needed for work. </p>
<p>While this was getting me through the day with enough productivity, there&#39;s always times where I wish I could just fall asleep but then I have a startup job that needs me to be there for a decent number of hours before I can give myself the permission to fall on the bed.</p>
<p>That said, the past few months during the lockdown made it worse. You see, when I had to go to the office there was a perfect schedule that I had to follow and I&#39;d be tired by the travelling so I&#39;d normally fall asleep somehow by 2 - 3 AM but since there&#39;s no such physical effort required and I literally just roll over my bed to reach my workstation it&#39;s hardly any tiring even after 8-10 hours of continuous work. </p>
<h3 id="internet-solutions">Internet Solutions</h3>
<p>The solutions I see all over the place are the likes of </p>
<ul>
<li>Get away from your devices 30-40 mins before bed time </li>
<li>Listen to white noise or rain sounds </li>
<li>Drop the room&#39;s temperature to something that you find comfortable (generally about 18 C )</li>
<li>Drink some kind of sleep inducing herb tea or something </li>
<li>And the final recommendation Melatonin Drug (Please consult a doctor first!)</li>
</ul>
<p>While they all do work in one way or the other because to sleep you gotta get comfortable, your body needs to feel like it needs rest but the devices , white noise aren&#39;t something that helped me. Might work for you, but didn&#39;t work for me. I ended up trying things I used to do as a kid when I couldn&#39;t sleep. </p>
<h3 id="my-attempted-solutions">My Attempted Solutions</h3>
<p>These are things I tried that worked sometimes but not every time.</p>
<ul>
<li>Arms Straight, head straight, look at the god damn fan till you fall asleep</li>
<li>Work out a bit just before I went to sleep</li>
</ul>
<p>I haven&#39;t recorded the events of the day so can&#39;t really confirm why and when they work.</p>
<h3 id="the-one">The One</h3>
<p>Now this, probably the most simplest and obvious thing for most of you but with a head like mine where you are constantly bombarded with memories, issues, possible bug fixes and project ideas, regrets and theoretical analysis and their results. It&#39;s kinda hard (no i&#39;m no smarty pants, I just think a lot). </p>
<p>I applied something I do for getting rid of or getting into a habit, <strong>conscious control</strong>. </p>
<p>Let me explain.</p>
<p>When trying to learn something or trying to get rid of a habit you have to consciously tell yourself that you are to avoid or do this thing. If i&#39;m learning a new language, I&#39;m to force myself to talk in that language. If learning a programming langugage, same applies, force myself to build something with it. </p>
<p>Though, you can&#39;t force yourself to sleep but the point of all the tips mentioned is to get yourself physically <strong>and</strong> mentally comfortable and calm. Yeah, I know, meditation is the best solution for that <strong>but</strong>, It doesn&#39;t always work for everyone. </p>
<p>For certain people getting rid of the thoughts needs you to go through them, for some people it&#39;s just focusing on their breath, for some it&#39;s forgetting the present and living in the white noise and while you can call it meditation cause I still follow the base principle of redirecting the focus to something else it&#39;s a little different than your conventional meditation.</p>
<p>The trick is to shift focus to a blank or shift your thoughts to plain nothingness, not my breath, not the story a meditation guru is narrating, nor trying to listen to  white noise. <strong>Just blank out!</strong></p>
<h3 id="how-though">How though?</h3>
<p>I don&#39;t know... I don&#39;t even think I can explain it properly but I&#39;ll give it a try. </p>
<p>Let&#39;s say I&#39;m thinking about a project, the features I&#39;d like, the issues it&#39;ll bring, the things that can go totally wrong, the amount of time it&#39;d take for me to perfect it the amount of research I have to do, and you can see the fall towards the <em>negative</em>, normally at this point you go towards a, &quot;<em>Forget it</em>&quot; and try imagining a blank black view, there&#39;s nothing there, no project, no humans, no positive, no negative nothing and apparently this relaxes your body automatically. </p>
<p>There&#39;s no tension in the shoulder, the legs stop shaking, my fingers stops typing in the air (Yes, I do this) but not on the first go obviously.</p>
<p>My brain is notorious enough to take me back to something else, like how I fell off the stairs while trying to impress a girl or how I botched a deployment and almost broke the entire code flow, it&#39;s all there in my memory and it keeps coming back and I guess it happens to the most of us considering the amount of memes this topic has. All I have to do is repeat the process, go back to blank. </p>
<p>The amount of time you have to stay in the blank depends on how the day went, too much on your mind? Will take a little longer than 10-15 mins. Tiring day? You might just fall asleep on the first transition. It really differs, even for me but it&#39;s better than not sleeping at all, or sleeping at 6 and waking up at 9 to start working again.</p>
<p>Adios.</p>



I've had problems sleeping for as long as I can remember and this has made it hard for me to keep my brain functioning properly and getting me addicted to solutions like Hot Chocolate with Caffeine and/or Coffee to keep me up for as long as needed for work. 

While this was getting me through the day with enough productivity, there's always times where I wish I could just fall asleep but then I have a startup job that needs me to be there for a decent number of hours before I can give myself the permission to fall on the bed.

That said, the past few months during the lockdown made it worse. You see, when I had to go to the office there was a perfect schedule that I had to follow and I'd be tired by the travelling so I'd normally fall asleep somehow by 2 - 3 AM but since there's no such physical effort required and I literally just roll over my bed to reach my workstation it's hardly any tiring even after 8-10 hours of continuous work. 

### Internet Solutions 

The solutions I see all over the place are the likes of 

- Get away from your devices 30-40 mins before bed time 
- Listen to white noise or rain sounds 
- Drop the room's temperature to something that you find comfortable (generally about 18 C )
- Drink some kind of sleep inducing herb tea or something 
- And the final recommendation Melatonin Drug (Please consult a doctor first!)

While they all do work in one way or the other because to sleep you gotta get comfortable, your body needs to feel like it needs rest but the devices , white noise aren't something that helped me. Might work for you, but didn't work for me. I ended up trying things I used to do as a kid when I couldn't sleep. 

### My Attempted Solutions 

These are things I tried that worked sometimes but not every time.

- Arms Straight, head straight, look at the god damn fan till you fall asleep
- Work out a bit just before I went to sleep

I haven't recorded the events of the day so can't really confirm why and when they work.

### The One

Now this, probably the most simplest and obvious thing for most of you but with a head like mine where you are constantly bombarded with memories, issues, possible bug fixes and project ideas, regrets and theoretical analysis and their results. It's kinda hard (no i'm no smarty pants, I just think a lot). 

I applied something I do for getting rid of or getting into a habit, **conscious control**. 

Let me explain.

When trying to learn something or trying to get rid of a habit you have to consciously tell yourself that you are to avoid or do this thing. If i'm learning a new language, I'm to force myself to talk in that language. If learning a programming langugage, same applies, force myself to build something with it. 

Though, you can't force yourself to sleep but the point of all the tips mentioned is to get yourself physically **and** mentally comfortable and calm. Yeah, I know, meditation is the best solution for that **but**, It doesn't always work for everyone. 

For certain people getting rid of the thoughts needs you to go through them, for some people it's just focusing on their breath, for some it's forgetting the present and living in the white noise and while you can call it meditation cause I still follow the base principle of redirecting the focus to something else it's a little different than your conventional meditation.

The trick is to shift focus to a blank or shift your thoughts to plain nothingness, not my breath, not the story a meditation guru is narrating, nor trying to listen to  white noise. **Just blank out!**

### How though?

I don't know... I don't even think I can explain it properly but I'll give it a try. 

Let's say I'm thinking about a project, the features I'd like, the issues it'll bring, the things that can go totally wrong, the amount of time it'd take for me to perfect it the amount of research I have to do, and you can see the fall towards the _negative_, normally at this point you go towards a, "_Forget it_" and try imagining a blank black view, there's nothing there, no project, no humans, no positive, no negative nothing and apparently this relaxes your body automatically. 

There's no tension in the shoulder, the legs stop shaking, my fingers stops typing in the air (Yes, I do this) but not on the first go obviously.

My brain is notorious enough to take me back to something else, like how I fell off the stairs while trying to impress a girl or how I botched a deployment and almost broke the entire code flow, it's all there in my memory and it keeps coming back and I guess it happens to the most of us considering the amount of memes this topic has. All I have to do is repeat the process, go back to blank. 

The amount of time you have to stay in the blank depends on how the day went, too much on your mind? Will take a little longer than 10-15 mins. Tiring day? You might just fall asleep on the first transition. It really differs, even for me but it's better than not sleeping at all, or sleeping at 6 and waking up at 9 to start working again.

Adios.



<p>Postgres fails to start properly if there&#39;s an obsolete postmaster running and services fail to connect to it so just remove the pid <strong>if it exists</strong> to make the service create a new process.</p>
<pre><code class="language-sh">rm -f /usr/local/var/postgres/postmaster.pid
</code></pre>



Postgres fails to start properly if there's an obsolete postmaster running and services fail to connect to it so just remove the pid **if it exists** to make the service create a new process.



```sh 
rm -f /usr/local/var/postgres/postmaster.pid
```





<p>Let&#39;s look at things I&#39;ve done in the past few weeks.</p>
<h3 id="tillwhen">TillWhen</h3>
<ul>
<li>To-dos now in beta </li>
<li>Export Project data to CSV</li>
</ul>
<p>Added the above two to Tillwhen and are right now on the beta environment as I&#39;m posting this, you can expect them to be on the live instance in about 2 days.</p>
<h3 id="cor">Cor</h3>
<p>Haven&#39;t touched Cor for a while now , Cor is a project management app that I planned on building but gave up mid way, might get back into building it soon, but not motivated enough to work on it right now. </p>
<h3 id="pui">PUI</h3>
<p>A postgres UI client that was built as a toy project will take precedence over COR and TillWhen next week. It&#39;s usable for local connections for now but basically has no validations etc so wouldn&#39;t really recommend using it for cloud connections right now, plus I haven&#39;t added ssl support to it so that&#39;s going to fail on you for various hosted instances anyway.</p>
<h3 id="others">Others</h3>
<p>I&#39;ve been working on the text editor research still and have been practicing Go Lang and C a little more and plan to get better at both before I start using them in production grade stuff. The Minimal Code Editor that I&#39;ve been planning to build all along is the motivation for me to go to these languages. C for it&#39;s cross-platform availability and Go for it&#39;s easy interop with Swift and GTK. While the Linux edition of the editor might come off easy with just one language, the mac version takes precendence since I&#39;ll be testing the editor while using it myself.</p>
<p>Also plan on building a transaction tracker and payment system for people to host , something like Drew&#39;s <a href="https://github.com/ddevault/fosspay">fosspay</a> but my take on it. Not sure when I&#39;ll be starting this but you can follow my Github to see if I do it.</p>
<p>Setup a personal git server for TillWhen&#39;s source code, not that I worry it&#39;s source code will be out because I will be making it open source once the app is stable with all the features I want and once I&#39;ve removed all the heavy UI libraries it has as dependencies for smaller components. Don&#39;t want the community to start patching torn  elements of a codebase that&#39;s not elegant to deal with so stay tuned for that.  </p>





Let's look at things I've done in the past few weeks.

### TillWhen 

- To-dos now in beta 
- Export Project data to CSV

Added the above two to Tillwhen and are right now on the beta environment as I'm posting this, you can expect them to be on the live instance in about 2 days.



### Cor

Haven't touched Cor for a while now , Cor is a project management app that I planned on building but gave up mid way, might get back into building it soon, but not motivated enough to work on it right now. 



### PUI 

A postgres UI client that was built as a toy project will take precedence over COR and TillWhen next week. It's usable for local connections for now but basically has no validations etc so wouldn't really recommend using it for cloud connections right now, plus I haven't added ssl support to it so that's going to fail on you for various hosted instances anyway.



### Others 

I've been working on the text editor research still and have been practicing Go Lang and C a little more and plan to get better at both before I start using them in production grade stuff. The Minimal Code Editor that I've been planning to build all along is the motivation for me to go to these languages. C for it's cross-platform availability and Go for it's easy interop with Swift and GTK. While the Linux edition of the editor might come off easy with just one language, the mac version takes precendence since I'll be testing the editor while using it myself.

Also plan on building a transaction tracker and payment system for people to host , something like Drew's [fosspay](https://github.com/ddevault/fosspay) but my take on it. Not sure when I'll be starting this but you can follow my Github to see if I do it.

Setup a personal git server for TillWhen's source code, not that I worry it's source code will be out because I will be making it open source once the app is stable with all the features I want and once I've removed all the heavy UI libraries it has as dependencies for smaller components. Don't want the community to start patching torn  elements of a codebase that's not elegant to deal with so stay tuned for that.  





Postgres ECONNREFUSED on 127.0.0.1