Force Mark all Read Gmaill

 

 

If you are thinking, how can I force mark all Read Gmaill? We can do this using Google scripts (app scripts ) allows us to automate tasks that we can't be bothered to do; I had a really fucking annoying notification of an old as fuck email, so I wanted to force them all into read.

So you want to make your own docker-compose for PHP/NPM ?

So you want to make your own docker-compose for PHP and NPM ? I know you do. But you don't want any more headaches, do you? Well, then, this tutorial is for you.

 

 

 

This is the list of cool and awesome Linux things.

This is the list of cool and awesome Linux things. Using these can improve your productivity and may even save your day occasionally. I'm sure you've heard of some of these before, so I'll keep it short; this is still a good primer if you're new to the Linux command line and looking for advice.

 

How to calculate if table rows are inserted consecutively in MySQL

As a developer, working with asynchronous code often means dealing with out-of-order timestamps. To report on such data, we need to validate the created date-time. Here, we will explore SQL parts beyond the SELECT statement, focusing on variables and the HAVING clause.

SELECT @a := 0;
SELECT invited, `date`, `date` - @a AS gap, @a := `date`
FROM INVOICES AS i
HAVING gap < 0

SQL Variables

SQL variables are used to store temporary data. They are particularly useful in complex queries where intermediate results need to be stored and reused.

SELECT @a := 0;

• @a is a user-defined variable.
• := is the assignment operator.
• 0 is the initial value assigned to @a.

Using Variables in Queries

Variables can be used within queries to perform calculations or store intermediate results.

SELECT invited, `date`, `date` - @a AS gap, @a := `date`
FROM INVOICES AS i
HAVING gap < 0;

• invited and date are columns from the INVOICES table.
• date - @a AS gap calculates the difference between the current date and the value stored in @a, aliasing it as gap.
• @a := date updates the variable @a with the current date value for the next row.

The HAVING Clause

The HAVING clause is used to filter results based on aggregate functions or calculated columns, similar to the WHERE clause but applied after the GROUP BY clause.

HAVING gap < 0;

• This filters the results to include only rows where the gap is less than 0, indicating an out-of-order timestamp.

Full Query Explanation

1. Initialize Variable:

   SELECT @a := 0;

   Initializes the variable @a to 0.
2. Query with Variable:

   SELECT invited, `date`, `date` - @a AS gap, @a := `date`
   FROM INVOICES AS i
   HAVING gap < 0;

   • Selects invited and date from the INVOICES table.
   • Calculates the gap between the current date and the previous date stored in @a.
   • Updates @a with the current date.
   • Filters rows where gap is less than 0.

Linux Clipboard Text To Speech

Install festival and esound-clients.

To do so, follow this tutorial: https://help.ubuntu.com/community/TextToSpeech

Install xsel:

sudo apt-get install xsel

Create new file in your home folder, call it "clipboardtospeech.sh" or something.

nano ~/apps/clipboardtospeech.sh

edit it and paste the following line:

xsel --clipboard | festival --tts

Make the script executable

cmod +x ~/apps/clipboardtospeech.sh

Make the file executable make a hotkey that launches the shell script:

~/apps/clipboardtospeech.sh 

Rsync over proxy gcloud / jumpbox

So I needed to pushdown some log files off of a box without a public IP, rather then rsync to the jump box / proxy then  rsync to my local box i made use of the ssh proxy command.

 rsync -avz -e 'ssh -o ProxyCommand="ssh proxxye.url.com -i ~/.ssh/google_compute_engine -W my-internal-ip.internal:22"' my-internal-ip.internal:/var/www/log/workers ~/code/logs/

Cross Brouser Support For onPaste clipboardData

Some of the current browsers support a 'clipboardData' property as part of a paste event. This should allow you to query the different data formats created from the current data on the clipboard.

Safari and Chrome have the best support, but it is still incomplete. Firefox has no support if you discount using the XPCOM objects interface. The IE interface is older and only supports Text or URL data.


Firefox, Safari IE and Chrome all sanitize any HTML being pasted. Opera will only paste plain text so HTML sanitation is not an issue. Some earlier version of IE could cause some security issues as they copy hyper-links in full.

Try copying and pasting this paragraph and link into the box below.