Showing entries 1 to 10 of 67
10 Older Entries »
Displaying posts with tag: javascript (reset)
MySQL Document Store – a quick-guide to storing JSON documents in MySQL using JavaScript and Python (and even SQL!)

MySQL introduced a JSON data type in version 5.7, and expanded the functionality in version 8.0.

Besides being able to store native JSON in MySQL, you can also use MySQL as a document store (doc store) to store JSON documents. And, you can use NoSQL CRUD (create, read, update and …

[Read more]
Efficient Node.js Buffer usage

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

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).

#PARAMETERS

  1. Column(s): Name of the columns which we want to copy.
  2. INTO: This is a keyword which is used to perform the copy operation.
  3. New_table: Name of the new table which will be created.
  4. Old_table_name: Name of the old table from where we are copying.
  5. 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]
Jquery Duplicate Fields Form Submit with PHP

This tutorial explains How to submit jquery duplicate/clone field values to form with PHP.  In this example we are going to provide very simple example and using existing jquery plugin, so here we are using relCopy.js jquery plugin to duplicating the existing field.


                                             Download                    …

[Read more]
Your SQL IS NOT JavaScript (neither PHP)

IS NULL, IS NOT NULL, truthiness among other assertions on MySQL and PostgreSQL

People like to complain about JavaScript, how can one thing be equal to the other, i.e. null == 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 true.

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.

[Read more]
javascript: How we wrote our own Service Worker As we continue the process of reinvigorating...

javascript:

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]
Why I Started Part-Time Freelancing Again On Upwork

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

[Read more]
Working with result sets in Connector/Node.js

MySQL 8.0 and the Document Store highlight brand new client tools such as the Shell and Connector/Node.js, both providing a JavaScript implementation of the X DevAPI. Although, for most cases, the public interface tends to be similar on both (barring some small details), there is one notable exception.

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]
10 Steps to Be a Web Developer with Book Recommendation

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

 Learn to Code HTML and CSS

  …

[Read more]
Slides and Workbooks From Oracle OpenWorld & CodeOne

Tweet

First of all, thanks to everyone who attended my sessions at the recent Oracle OpenWorld and Code One in San Francisco. It was a great privilege to be allowed to make a number of presentations.

All of the workbooks and scripts from the hands-on labs (HOL) and the slides from the talks have been made available at OpenWorld’s and Code One’s session catalogues. You can download the files by using the OpenWorld catalog searching for my name or the session number (see below). Click on the download icon for each of the presentations you are interested in.

[Read more]
Showing entries 1 to 10 of 67
10 Older Entries »