In the penultimate Deno article, I wrote on how to build REST APIs with Deno and Oak. In that tutorial, we used an array as a dummy storage placeholder to not overwhelm ourselves with database connection and other stuff. For this article, we are going to take that example one …
10 Older Entries »
When building network libraries for Node.js, as we do at work, one quite quickly comes by Node's Buffer type. A Buffer gives access to a memory region in a quite raw form, allowing to handle raw data and allowing to interpret binary streams. The Buffer interface predates ES6 TypedArrays and has some optimizations.
Two optimisations are notable:
For one the slice() method does not copy data, but returns a view on the underlying data. This makes it quite efficient to work on a window of the data, but when writing one has to be careful. Simple example:
const buffer = Buffer.from("hello"); …[Read more]
SQL SELECT INTO Statement Tutorial With Example is today’s topic. The SQL SELECT INTO STATEMENT is used to create a table from an existing table by copying the contents of the current table to the new table. The critical point to note here is that the column and data type of column must be the same. See the following syntax.
Select column(s) INTO new_table from old_table_name where(condition).
- Column(s): Name of the columns which we want to copy.
- INTO: This is a keyword which is used to perform the copy operation.
- New_table: Name of the new table which will be created.
- Old_table_name: Name of the old table from where we are copying.
- Where(condition): This is used for imposing conditions into the select statement.
#SQL SELECT INTO Statement
The SELECT INTO statement copies the data from …[Read more]
IS NOT NULL, truthiness among
other assertions on MySQL and PostgreSQL
can one thing be equal to the other, i.e.
undefined evaluates to
true unless you use
the triple equals
===. Other dynamic typed languages
have its peculiarities, such as Ruby where
0 == true evaluates to
true, the reason
for Ruby is that considers
0 as a value and any
value evaluates to
How about SQL? The answer is… it depends.
Which database are you using?
Some may be more forgiving, like MySQL doing casts for you all over the place, or more strict like PostgreSQL where you can only compare the truthiness of something of the same type.
How we wrote our own Service Worker
As we continue the process of reinvigorating Tumblr’s frontend web development, we’re always on the lookout for modern web technologies, especially ones that make our mobile site feel faster and more native. You could have guessed that we are making the mobile dashboard into a progressive app when we open-sourced our webpack plugin to make web app manifests back in August. And you would’ve been right. But to make a high quality progressive web app, you need more than just a web app manifest—you also need a …[Read more]
I stopped freelancing on upwork in 2011. I used to be a part-time freelancer on upwork (previously known as oDesk) from 2008 to 2011 besides my full-time job. Since 2011, I have been developing my own Indie mobile apps which is a great success for me and in my career.
I am still earning very good passive income from my own portfolio apps, today I will discuss why I have started freelancing again.
1. Indie Developing
There is a saying:
If you walk alone you can go faster
If you walk in group you can go further
The way you handle result sets in a Node.js app using Connector/Node.js is a bit different from the way you do it using an interactive session or a non-interactive JS script in the Shell.
Executing an operation in the MySQL server …[Read more]
Many people want to be web developer. But not many people know how and where to start. In this 10 steps guideline, I discuss how to be a web developer from Zero experience with my recommended books.
I created this guidelines based on my web development experience and recent trends. Personally I read most of the books I recommended here.
1. HTML & CSS
First step of becoming a web developer is to learning the fundamental of HTML and CSS. These are the building blocks of website or web application development. Normally a web developer doesn’t have to be a master of CSS as Web designer do this job. But sometimes for simple modification its way better to fix by oneself than asking the designer.
Recommended Books for HTML and CSS
10 Older Entries »