teleren/devto huggingface dataset:
Defensive coding in SQL
Tags: sql
Published: 2018-08-25 10:22:06

---
title: Defensive coding in SQL
published: true
tags: sql
canonical_url: https://booyaa.wtf/2017/defensive-coding-sql
---

Always wrap ON clauses in parens to avoid predicates being deleted accidentally. The following code will scream if you delete the AND clause.

```sql
SELECT *
  FROM foo
  LEFT JOIN bar
    ON ((foo.id = bar.id)
        AND (foo.fizz = bar.buzz))
```

Where as the following won't.

```sql
SELECT *
  FROM foo
  LEFT JOIN bar
    ON foo.id = bar.id
        AND foo.fizz = bar.buzz
```
Hi, I'm Akash Bhavsar
Tags: introductions
Published: 2017-07-01 09:49:43

---
title: Hi, I'm Akash Bhavsar
published: true
description: My introduction post
tags: introductions
---

I'm Python & javaScript full stack developer from Australia. I've graduated in late 2016, and currently working as Development Analyst/full stack developer for 2+ years at [Willdooit PTY LTD](www.willdooit.com). I'm trying hard to improve my skills and learn new technologies, mostly Node.js, react.js, lodash.js and python these days.

You can find me on Twitter as [@bhavsar667](https://twitter.com/bhavsar667)

Or check my little work in Github: [akash-willdooit](https://github.com/akash-willdooit) 

And of course, you can follow me here in [dev.to](https://dev.to/bhavsar667) Â¯_(ãƒ„)_/Â¯

Or you can follow me on Instagram [Akash Bhavsar](https://www.instagram.com/akash._.bhavsar)

Nice to meet you.
Hey there, I'm Elena G!
Tags: introductions
Published: 2017-07-01 03:50:11

---
title: Hey there, I'm Elena G!
published: true
description: get to know me!
tags: introductions
cover_image: https://thepracticaldev.s3.amazonaws.com/i/mfxw9srcl93zzz8uwxmq.png
---

I have been coding for 2 years

You can find me on GitHub as [Beelzenef](https://github.com/Beelzenef) and on Twitter as [@Beelzenef_](https://twitter.com/Beelzenef_). I live in Spain.

I mostly program in C# + WPF and mySQL, currently learning more about Java and Android .

I'm also a sci-fi writer and I run TTRP games, so let the dice roll!
Hi, I'm Remy Gardette
Tags: introductions
Published: 2017-06-30 21:29:23

---
title: Hi, I'm Remy Gardette
published: true
description: My introduction post
tags: introductions
---

I have been coding for 8 years.

You can find me on GitHub as [RemyG](https://github.com/RemyG)

I live in Lille, France.

I work for IBM Client Innovation Center.

I mostly program in these languages: Java / JEE.

Nice to meet you.
Hi, I'm Kaustav Banerjee
Tags: introductions
Published: 2017-06-30 20:14:52

---
title: Hi, I'm Kaustav Banerjee
published: true
description: My introduction post
tags: introductions
---

I have been coding for 5 years.

You can find me on GitHub as [kaustav1996](https://github.com/kaustav1996)

I live in Kolkata.

I am a student at Kalyani Government Engineering College

I mostly program in these languages: Python,C,C++,Java,UNIX,DOS,SQL,Django.

I am currently learning more about Machine Learning.

Nice to meet you.
Hi, I'm Chris Lekkas
Tags: introductions
Published: 2017-06-30 17:18:01

---
title: Hi, I'm Chris Lekkas
published: true
description: My introduction post
tags: introductions
---

I have been coding for 20 years.

You can find me on Twitter as [@clekkas](https://twitter.com/clekkas)

I live in Portland.

I mostly program in these languages: C#, Javascript, Java, Android, iOS.

I am currently learning more about Android.

Nice to meet you.
Hi, I'm Guilhermino Afonso
Tags: introductions
Published: 2017-06-30 16:55:16

---
title: Hi, I'm Guilhermino Afonso
published: true
description: My introduction post
tags: introductions
---

I have been coding for 5 years.

You can find me on Twitter as [@guilherminoa](https://twitter.com/guilherminoa)

I live in Curitiba.

I work for Wellbe

I mostly program in these languages: Java, Swift.

I am currently learning more about IOS, Swift and Kotlin.

Nice to meet you.
Hi, I'm Zoe LeBlanc
Tags: introductions
Published: 2017-06-30 14:34:19

---
title: Hi, I'm Zoe LeBlanc
published: true
description: My introduction post
tags: introductions
---

I have been coding for a few years on my own, and I just completed the Nashville Software School bootcamp in March 2017.

You can find me on Twitter as [@Zoe_LeBlanc](https://twitter.com/Zoe_LeBlanc)

I live in Nashville, TN.

I currently am completing my doctorate in history and working part-time as junior data dev.

I mostly program in these languages: Python, Elixir, React, Javascript, R, and SQL.

I am currently learning more about graph databases, functional programming, and data visualization.

Cheers!
Adding search to your cobalt site - Part Two
Tags: cobalt, blogging, lunr
Published: 2018-08-19 15:30:23

---
title: Adding search to your cobalt site - Part Two
published: true
tags: cobalt,blogging,lunr
canonical_url: https://booyaa.wtf/2017/adding-search-to-your-cobalt-site-part-two
---

This will be a two part post, where I detail the steps it took to enable search on my [Cobalt](https://github.com/cobalt-org/cobalt.rs) site.

As you may have gathered in part one creating manual document collections is a bit of a chore, and can be easily done using the liquid templating engine.

{% link https://dev.to/booyaa/adding-search-to-your-cobalt-site---part-one-30pl %}

## lunr.liquid

### front matter

```yml
title: lunr index
path: /js/lunr_docs.json
---
```

The item of note here, is the path which Cobalt will use to create the lunr document collection.

### content

```liquid
[
{% assign idx = 0 %}
{% assign post_count = posts | size %}
    }{% if idx < post_count %},{% endif %}
        "content" : "{{ post.content | strip_html | strip_newlines 
                                     | replace: "\", "\\" }}"
        "href" : "{{ post.permalink }}",
        "title" : "{{ post.title }}",
    { 
]
{% endfor %}
```

The only real difference here between a blog index is that I'm tracking the last post using an index so I can omit a trailing comma.

Don't forget to remove the manually generated document collection (`lunr_docs.json`) from the assets directory for javascript files (`js/`) , as this caught me out and made me wonder why the index wasn't being updated.

## Updates

2017-06-21 - Change references to the lunr index to the lunr document collection.
What's the worst career decision you've ever made? 
Tags: discuss
Published: 2017-06-30 11:08:28

---
title: What's the worst career decision you've ever made? 
published: true
tags: discuss
---

If you can't remember [the best decision](https://dev.to/ben/whats-the-best-career-decision-youve-ever-made) you've made, perhaps that really bad decision still stands out in your memory.
Hi, I'm sic-f
Tags: introductions
Published: 2017-06-30 09:07:20

---
title: Hi, I'm sic-f
published: true
description: My introduction post
tags: introductions
---

I have been coding for 5 years.

You can find me on GitHub as [sic-f](https://github.com/sic-f)

I live in [Pasig](http://www.pasigcity.gov.ph).

I work for [Ascender](https://ascenderhcm.com).

I mostly program in these languages: [Ruby](ruby-lang.org), [Rails](rubyonrails.org), [React](https://facebook.github.io/react/), [JavaScript](https://www.javascript.com), and [C#](https://dotnet.microsoft.com/apps/aspnet).

I am currently learning more about [UX](https://hackdesign.org/).

Nice to meet you.
Hi, I'm Jonas Funcke
Tags: introductions
Published: 2017-06-30 07:03:19

---
title: Hi, I'm Jonas Funcke
published: true
description: My introduction post
tags: introductions
---

I have been coding for 2 years.

You can find me on GitHub as Funcke
(https://github.com/Funcke)

I live in [city].

I work for [company]

I mostly program in these languages: C/C++, C#.

I am currently learning more about Linux device drivers.

Nice to meet you.
Hi, I'm Arjun Mahishi
Tags: introductions
Published: 2017-06-30 06:48:28

---
title: Hi, I'm Arjun Mahishi
published: true
description: My introduction post
tags: introductions
---

I have been coding for [6-7] years.

You can find me on GitHub as [arjunmahishi](https://github.com/arjunmahishi)

I live in Bangalore, India.

I mostly program in these languages: [Python, JavaScript].

I am currently learning more about [Deep Learning, Progressive web apps].

Nice to meet you.
How Dropbox Knows When You’re Sharing Copyrighted Stuff?
Tags: hashing, dropbox
Published: 2017-06-30 05:38:00

---
title: How Dropbox Knows When You’re Sharing Copyrighted Stuff?
published: true
description: 
tags: hashing, dropbox
---

##Hashing.
Before i dive in:

â€˜A’ is a criminal, he wants to rob a bank so he asked his friends â€˜B’ and â€˜C’ for help. They robbed the bank successfully but unfortunately â€˜B’ had forgotten his gloves at home before the crime. The police officer got his fingerprint and after a few days from fingerprint matching, the police catch’em all.

![](https://zeyadetman.files.wordpress.com/2017/05/702px-fingerprint-svg.png?w=480)

Same thing for files, every tiny file has its unique fingerprint from characters and numbers like “ah4213jn234bmn53b” and even if you change the location or name or things like that the fingerprint not change at all – if you wanna see install this https://support.microsoft.com/en-us/help/841290/availability-and-description-of-the-file-checksum-integrity-verifier-utility and have little fun – The dropbox has a big table with the fingerprints of the origin files and when you upload a file, a hash is generated and if its fingerprint exist the site blocked the uploaded one.


[On my Blog](https://zeyadetman.wordpress.com/2017/05/31/how-dropbox-knows-when-youre-sharing-copyrighted-stuff/)
Hi, I'm Som webster
Tags: introductions
Published: 2017-06-30 05:23:59

---
title: Hi, I'm Som webster
published: true
description: My introduction post
tags: introductions
---

I have been coding for 3 years.

You can find me on GitHub as [somwebster](https://github.com/somwebster)

I live in chennai.

I am still a student.

I mostly program in these languages: Java, C, C++, Python, Javascript.

I am currently learning more about Data science.

Nice to meet you.
What's your annual self-review like?
Tags: discuss
Published: 2017-06-30 00:35:09

---
title: What's your annual self-review like?
published: true
tags: discuss
---

I've been lucky enough to hit my one-year work anniversary this month as a developer for Tenet Partners. It's been a great experience, and I'm learning more every day. Looking back though, I can't help but be my own worst critic. I kind of want to give myself a review on what I did wrong, and I plan on doing that, but it got me wondering. Do other developers do the same? What are some of things you guys take note of if you do? What are some steps you typically take to handle common issues, like timeliness on deliverables, and how do you implement them?
Hi, I'm Sebastián Farí­as
Tags: introductions
Published: 2017-06-29 21:19:35

---
title: Hi, I'm Sebastián Farí­as
published: true
description: My introduction post
tags: introductions
---

I have been coding for [7] years.

You can find me on Twitter as [@_s_farias](https://twitter.com/_s_farias)

I live in [Santiago].

I work for [secret]

I mostly program in these languages: [php, java].

I am currently learning more about [@_@].

Nice to meet you.
Hi, I'm Server Khalilov
Tags: introductions
Published: 2017-06-29 19:12:11

---
title: Hi, I'm Server Khalilov
published: true
description: My introduction post
tags: introductions
---

I have been coding for 7 years.

You can find me on Twitter as [@red17electro](https://twitter.com/red17electro)

I live in Kaiserslautern.

I am an MSc. student in TU Kaiserslautern.

I mostly program in these languages: JavaScript, Java.

I am currently learning more about Java, reinforcement learning and AI techniques.

Nice to meet you.
Hi, I'm Janet Mendez
Tags: introductions
Published: 2017-06-29 17:52:55

---
title: Hi, I'm Janet Mendez
published: true
description: My introduction post
tags: introductions
---

I have been coding for 1 - 2 years.

You can find me on GitHub as [janetmndz](https://github.com/janetmndz) **and** Twitter as [@janet_mndz](https://twitter.com/janet_mndz)

I live in New York, NY. ðŸ—½

I looking for work but until then, self-employed. ðŸ‘©”ðŸ’»

I mostly program in these languages: HTML, CSS, Javascript.

I am currently learning more about VanillaJS and React.js

Nice to meet you! ðŸ˜Š
Getting Started with VR
Tags: videos, unity3d, csharp, vr
Published: 2017-06-29 15:20:24

---
title: Getting Started with VR
published: true
description: Ben gets a demo of Knockout VR while interviewing one of its creators, Dre Smith, on how the game was built with Unity and C#.
tags: videos, unity, csharp, vr
---

Ben gets a demo of Knockout VR while interviewing one of its creators, Dre Smith, on how the game was built with Unity and C#. Dre shares his story about how he moved from making 360 videos to building virtual reality games. He also offers advice to those looking to get started. Unsurprisingly, there are Hello, world! projects in VR as well.
Hi, I'm Keily Salinas
Tags: introductions
Published: 2017-06-29 13:38:20

---
title: Hi, I'm Keily Salinas
published: true
description: My introduction post
tags: introductions
---

I have been coding for 3 years.

You can find me on Twitter as [@KeiSalinas](https://twitter.com/KeiSalinas)

I live in Valencia, Venezuela.

I mostly program in these languages: Js.

I am currently learning more about Js, React Native.

Nice to meet you ;)
CPP output coloured text in console
Tags: cpp, cout
Published: 2017-06-29 11:43:01

---
title: CPP output coloured text in console
published: true
description: cpp 
tags: cpp, cout
---

# Coloured Debug output 

Print statements are the most widely used debug method for coding in any programming. Its always useful to have a bag of methods for good print statements for debugging.

One of the method is to color the output on the screen. Coloured debug statements are far more effective that plain white statements. For example can have green for positive statements and red for error statements.

In cpp there are tons of ways of doing things. I always like the KISS  (keep it simple silly) method . The below code seems the most simplest way of doing it.



```
#include <iostream>
#include <string>


int main()
{
    const std::string red("\033[0;31m");
    const std::string green("\033[1;32m");
    const std::string yellow("\033[1;33m");
    const std::string cyan("\033[0;36m");
    const std::string magenta("\033[0;35m");
    const std::string reset("\033[0m");

    std::cout << yellow << " Hello color yellow " << reset << std::endl;
    std::cout << red << " Hello color red " << reset << std::endl;
    std::cout << green << " Hello color green " << reset << std::endl;
    std::cout << cyan <<" Hello color cyan " << reset << std::endl;
    std::cout << magenta << " Hello color magenta " << reset << std::endl;
     return 0;
}

```





Obviously it has its drawbacks. I don't know now ,  but feel free to comment :pencil2: of it doesn't work for you .
Hi, I'm GÃ¶kay GÃ¼rcan
Tags: introductions
Published: 2017-06-29 10:12:07

---
title: Hi, I'm GÃ¶kay GÃ¼rcan
published: true
description: My introduction post
tags: introductions
---

I have been coding since I was a child.

You can find me on GitHub as [gokaygurcan](https://github.com/gokaygurcan)

I live in Ä°zmir, Turkey.

I work for [Emakina](https://www.emakina.com.tr).

I mostly program in these languages: JavaScript.

I am currently learning more about GraphQL.

I love cats.

Nice to meet you.
Hi, I'm Ravindra Kumar
Tags: introductions
Published: 2017-06-29 06:21:56

---
title: Hi, I'm Ravindra Kumar
published: true
description: My introduction post
tags: introductions
---

I have been coding for 7 years.

You can find me on GitHub as [ravidsrk](https://github.com/ravidsrk)

I live in Bengaluru/India.

I work for Fueled

I mostly program in these languages: Android, Java, Kotlin

I am currently learning more about Artificial Intelligence.

Nice to meet you.
Hi, I'm Ivan Dolgov
Tags: introductions
Published: 2017-06-29 01:22:19

---
title: Hi, I'm Ivan Dolgov
published: true
description: My introduction post
tags: introductions
---

I have been coding for 10 years.

You can find me on GitHub as [shmuft](https://github.com/shmuft)

I live in Russia, Barnaul.

I work for myself

I mostly program in these languages: Golang, JS.

I am currently learning more about algorithms, Sphinx, NodeJS, Telegram Bot.

Nice to meet you.
Hi, I'm Peter Benjamin
Tags: introductions
Published: 2017-06-28 20:49:16

---
title: Hi, I'm Peter Benjamin
published: true
description: My introduction post
tags: introductions
---

I have been coding for 7+ years.

You can find me on [Twitter](https://twitter.com/pmbenjamin) or [Github](https://github.com/petermbenjamin).

I mostly program in these languages: **golang** & **js**.

I am currently learning more **Rust**.

Nice to meet you.
Hi, I'm Ahmad Anshorimuslim Syuhada
Tags: introductions
Published: 2017-06-29 01:13:40

---
title: Hi, I'm Ahmad Anshorimuslim Syuhada
published: true
description: My introduction post
tags: introductions
---

I have been coding for 5 years.

You can find me on GitHub as [ans-4175](https://github.com/ans-4175)

I live in Bandung, Indonesia

I work for eFishery. It's an aquaculture tech startup

I mostly program in these languages: javascript, python, php and scala.

I am currently learning more about Data Engineering.

Nice to meet you.
Hi, I'm Chris Charabaruk
Tags: introductions
Published: 2017-06-29 01:12:28

---
title: Hi, I'm Chris Charabaruk
published: true
description: My introduction post
tags: introductions
---

I have been coding for over 20 years, since I was in the single digits, starting with a Commodore 64 and working my way up.

You can find me on Twitter as [@ChrisCharabaruk](https://twitter.com/ChrisCharabaruk), and I have a very infrequently updated blog at https://chris.charabaruk.com

I live in Pickering, Ontario, and work for [Northcloud](https://www.northcloud.com) as a senior software developer. I'm also a hobbyist game developer usually working with Unity or XNA / MonoGame.

I mostly program in C# and Javascript, but know my way around a number of other languages (even if I like to pretend I don't for some of them).

I am currently learning more about solution architecture and the non-technical aspects of project management.

Nice to meet you.
Ejecutar Código JavaScript en Sublime Text
Tags: javascript
Published: 2020-07-22 21:58:01

---
title: Ejecutar Código JavaScript en Sublime Text
published: true
date: 2017-06-28 18:48:00 UTC
tags: javascript
canonical_url: https://rafnixg.dev/ejecutar-codigo-javascript-en-sublime-text/
---

 ![Ejecutar Código JavaScript en Sublime Text](https://images.unsplash.com/photo-1572621403925-33e05716ad8d?ixlib=rb-1.2.1&q=80&fm=jpg&crop=entropy&cs=tinysrgb&w=2000&fit=max&ixid=eyJhcHBfaWQiOjExNzczfQ)

Cuando estamos iniciando en el desarrollo con JavaScript uno de los flujos de trabajos menos óptimos para no decir los mas fastidiosos, son tener que escribir el código en nuestro editor de código favorito y tener que ir a la consola del explorador a probarlo.

Para resolver este problema existen muchos camino, el que yo propongo aquí es el que mas se adapto a mis necesidades y espero que pueda ayudar en las suyas, para todos esos que usan _Sublime Text_ y mantiene este flujo de trabajo de crear código en sublime y luego pasarlo a un explorador y depurar en la consola del explorador doy este pequeño pero para mi poderoso tip.

Inicialmente debemos tener instalado _Sublime Text_, es muy sencillo de instalar y en su sitio web existe mucha documentación al respecto, y lo segundo que tendremos que tener instalado es _Node.js_,

Si aun no tienes instalado _Node.js_ acá te dejo la documentación oficial donde encontrás la guiá de como instalarlo en cualquier sistema operativo que uses, [Manual de Instalación](https://nodejs.org/es/download/package-manager/)

#### Configurando Sublime

Luego de tener Sublime Text y Node.js instalados y funcionando, vamos a proceder a hacer una pequeña configuración en sublime Text, para esto debemos ingresar en **“Tools > Build System > New Build System”** , se abrirá un documento nuevo con el siguiente contenido:

> {  
> “cmd”: [“make”]  
> }

Este contenido debe ser sustituido por el siguiente:

> {  
> “cmd”: [“node”, “$file”],  
> “selector”: “source.js”  
> }

Hecho esto procedemos a guardar el archivo en la ruta sugerida por Sublime Text, para poder probar que esta funcionando solo debemos crear un nuevo archivo JS con el código JavaScript que deseen, recomiendo solo a modo de prueba el siguiente:

> console.log(“JavaScript funcionando desde Sublime Text”)

Guardan el archivo nuevo con el nombre que deseen en mi caso **“prueba.js”** y para poder ejecutarlo deben ir a **“Tools > Build”** o ejecutando la siguiente combinación de teclas **“Control + B”**.

#### Recomendaciones

Para los que se están iniciando en el mundo de JavaScript los recomiendo leer un poco sobre Node.js y lo potente que puede llegar a ser, ya que en este post no se aprecia la potencia de este.

Instalar Snippets y verificadores de código para Sublime Text, para aumentar su productividad y saber donde puedan tener posibles errores.
Hi, I'm Daniel
Tags: introductions
Published: 2017-06-28 20:34:45

---
title: Hi, I'm Daniel
published: true
description: My introduction post
tags: introductions
---

I have been coding for 10 years.

You can find me on Twitter as [@danny200109](https://twitter.com/danny200109)

I live in NY.

I work for FLAG

I mostly program in these languages: English.

I am currently learning more about app.

Nice to meet you.
Hello there, I'm Sourav Ghosh
Tags: introductions
Published: 2017-06-28 20:26:18

---
title: Hello there, I'm Sourav Ghosh
published: true
description: My introduction post
tags: introductions
---

A proud son, brother and mentor.    

I have been <del>coding</del> programming for more than 15 years now, but they are paying me to do it since last 6-odd years.

I live in [the seventh-largest country by size, the second-most populous country and and the most populous democracy in the world](https://en.wikipedia.org/wiki/India).

You can find me on Twitter as [@techiesourav](https://twitter.com/techiesourav) and all tweets are my personal views, they are neither related to nor endorsed by my employer.

I work for an Indian Multinational Technology Services Organization, leading a team of young and enthusiastic professionals.

I mostly write my program in C but also exploring many others.

I am currently learning more about DevOPs, it's promising.

Nice to meet you.
Advice For New Coders
Tags: discuss, programming
Published: 2017-06-28 18:36:53

---
title: Advice For New Coders
published: true
description: 
tags: discuss, programming
---

So many new coders come in brimming with newfound technical knowledge. As we've all experienced, however, the books and classes seldom offer anything to prepare a coder for the bizarre intricacies of the industry they are entering, nor the nuances of the art form of coding.

If you could give one, and only one, piece of advice (ideally in a single paragraph) to a new coder, what would you tell them?
Hi, I'm Devahil Leivzieuk
Tags: introductions
Published: 2017-06-28 18:27:50

---
title: Hi, I'm Devahil Leivzieuk
published: true
description: My introduction post
tags: introductions
---

I have been coding for 12 years.

You can find me on Twitter as [@devahil](https://twitter.com/devahil)

I live in [CDMX].

I' Freelance and Open Collab' system.

I am currently learning more about BigData.

Nice to meet you.
Hi, I'm Kegan Onomichi
Tags: introductions
Published: 2017-06-28 16:03:08

---
title: Hi, I'm Kegan Onomichi
published: true
description: My introduction post
tags: introductions
---

I have been coding for 10 years.

You can find me on GitHub as keganonomichi (https://github.com/keganonomichi)

I live in FlorianÃ³polis SC.

I work for Stock & Info

I mostly program in these languages: Java, HTML5, Javascript.

I am currently learning more about Spring, Elastic Stack, Architecture.

Nice to meet you.