Top 5 websites to create your own mobile apps with coding skills

Today, everybody knows the craze of smartphone apps whether they are Android apps or iPhone apps. Every smartphone users crazily install the desired apps on their device. That’s why we are looking on the internet that new apps are launching day to day. So, if you also want to create your own mobile apps and suppress your this dream due to the lack of coding skills, then let me tell you that you can make awesome smartphone apps without programming skills.

Yes guys, actually I’m going to introduce you with Top 5 websites to create your own mobile apps with coding skills. So, why to wait? Just move forward to know about these excellent websites.

1. AppBar

Appsbar is a very useful online tool to create mobile apps without know any programming knowledge. Appsbar was introduced in 2011 as the first cost-free way for anyone, at any skill level and with a limited budget, to make rich, personalized apps that reflect their own personality, business or event with direct access to app stores.

Appsbar

Appsbar

Appsbar helps you design apps for almost every operating systems such as you can create apps for Android, iOS etc. It also allows you to create Facebook apps. It takes three steps to create apps. In first step, you need to select your app type (business,
music, events, and more). Second step deals with d
esigning and previewing your app as you go and in the third step Appsbar develop your app and provide you with the necessary tools to share your app with the world.

2. Buzztouch

Buzztouch is another mobile applications designing online tool where you can design the both type of apps i.e, Android and iOS. It provides you every facility to design your own apps without no limitation. You can use pre-written plugins or create something custom without any limitations.

Buzztouch

Buzztouch

On visiting the website, it provides you the complete guide for how it works. You can watch the videos for how to create, download and launch the apps. In case of pricing, it offers you to create 3 apps hosted on its server free of cost. For more (50 hosted apps) facilities you can go for premium that takes $79.99/Year.

3. Andromo

With Andromo, you can create your own Android apps very simply. It provides the facility to create your first app free of cost. To create your first free app, you’ll need to sign up with Andromo.

Andromo

Andromo

If you want to create more Android apps, you’ll need to pick a premium plan. It offers three plans, one is on monthly basis and other twos are on yearly basis. It takes $30 for a month and #99 for a year but with limited features. Instead, the third Professional plan takes $249 per year. In the professional plan, it will never seen Andromo logo on About screen but with the previous two plans it includes.

4. AppMakr

AppMakr is an online web place where you can create your own thousands of mobile apps free of cost. It offers you to create Android, iOS and Windows Phone apps. It provides very easy module to create free mobile app. You just need to visit the website and type in your App title and move ahead step by step.

AppMakr

AppMakr

However, the its free tool has some limitations such as shows contextually relevant ads, your designed app will be published to the AppMakr market and more. So, you can hire its premium plan for creating professional apps. It uses three premium plans $1/month, $9/month and $99 All Time Free. Visit the website for more information.

5. iBuildApp

iBuildApp is also a free online web tool to create Android and iPhone apps in just 5 minutes. No single coding is required to create these apps. There are several features of the apps created by site such as GPS Notifications, Make money by placing ads, Create app for selling goods and receiving payment, social sharing and more.

iBuildApp

iBuildApp

Its pricing ranges are higher than the above 4. It provides 4 types of pricing plans including Free, Basic, Business & Enterprise. If you want to create app for your Tablet, then here is no plan to create free tablet app. For tablet apps, it offers two premium plans – Business and Enterprise.

What Do You Think?

What do you think about these websites? After the reading the above information about the all of them, you can judge a best one for you very simply. So, did you liked this post? Found it useful? Make me know about your responses via our comment system.

Wind Up

I filtered this list from a huge amount to mobile apps creating websites. This list of online web tools to create mobile apps is very rear and you all will definitely find it very useful if you are going to create your own app. In case if you’re not so good in programming or even don’t have any knowledge of coding, nevertheless you can create your fantastic, professional and business apps using these websites.

Advertisements

Do you use Google services including Gmail, YouTube, Blogger, Picasa etc.? Do you want todownload your whole Google data offline at once in form of archive? Now, it is possible guys. Google has included its popular services like Gmail, Blogger, YouTube to its Takeout service and that’s why now you’ll be able to download your Gmail and other Google data simply on your PC for offline use.

Download Google Data

Google started this takeout service because all Google users can store their whole Google data at one place and simply access it anytime even they are offline. So, through this service you can download all YouTube videos uploaded by you, photos uploaded on Picasa by you, your posts on blogger and all your mails on Gmail etc.

How To Download a Copy of Google Data

Now, have a look on the simple steps given below regarding to download gmail and other Google data on your laptop or computer.

  • First of all visit the web link http://www.google.com/takeout and log in with your Google account. After that, you need to click on Create an archive button.

Click on create an archive button

  • Now, select Google products from which you would like to download data, and configure the download settings for each product. After all, click on Create Archive.

Select Google Products to create archive

  • As you’ll click on Create Archive, it will start preparing your selected Google product’s data archive. It will be emailed you when your archive will complete.

Preparing Archive

At last, when your archive will ready to download, then you’ll receive an email in your inbox. It may take a long time (hours or possibly days) to create archive. So, on receiving email, again visit the google.com/takeout and click on My Archives. Here you’ll find your recent made archive that you can download in minutes.

How to Create Triggers in MySQL

This article was written in 2011 and remains one of our most popular posts. If you’re keen to learn more about MySQL, you may find this recent article on administering MySQL of great interest.

This is the second article in a series about database automation with triggers and events. A trigger is SQL code which is run just before or just after an INSERT, UPDATE or DELETE event occurs on a particular database table. Triggers have been supported in MySQL since version 5.0.2.

Our Database Plan

We’ll create a small example database for a blogging application. Two tables are required:

  • `blog`: stores a unique post ID, the title, content, and a deleted flag.
  • `audit`: stores a basic set of historical changes with a record ID, the blog post ID, the change type (NEW, EDIT or DELETE) and the date/time of that change.

The following SQL creates the `blog` and indexes the deleted column:


CREATE TABLE `blog` (
	`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
	`title` text,
	`content` text,
	`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `ix_deleted` (`deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='Blog posts';

The following SQL creates the `audit` table. All columns are indexed and a foreign key is defined for audit.blog_id which references blog.id. Therefore, when we physically DELETE a blog entry, it’s full audit history is also removed.


CREATE TABLE `audit` (
	`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
	`blog_id` mediumint(8) unsigned NOT NULL,
	`changetype` enum('NEW','EDIT','DELETE') NOT NULL,
	`changetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	KEY `ix_blog_id` (`blog_id`),
	KEY `ix_changetype` (`changetype`),
	KEY `ix_changetime` (`changetime`),
	CONSTRAINT `FK_audit_blog_id` FOREIGN KEY (`blog_id`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Creating a Trigger

We now require two triggers:

  • When a record is INSERTed into the blog table, we want to add a new entry into the audit table containing the blog ID and a type of ‘NEW’ (or ‘DELETE’ if it was deleted immediately).
  • When a record is UPDATEd in the blog table, we want to add a new entry into the audit table containing the blog ID and a type of ‘EDIT’ or ‘DELETE’ if the deleted flag is set.

Note that the changetime field will automatically be set to the current time.

Each trigger requires:

  1. unique name. I prefer to use a name which describes the table and action, e.g. blog_before_insert or blog_after_update.
  2. The table which triggers the event. A single trigger can only monitor a single table.
  3. When the trigger occurs. This can either be BEFORE or AFTER an INSERT, UPDATE or DELETE. A BEFORE trigger must be used if you need to modify incoming data. An AFTER trigger must be used if you want to reference the new/changed record as a foreign key for a record in another table.
  4. The trigger body; a set of SQL commands to run. Note that you can refer to columns in the subject table using OLD.col_name (the previous value) or NEW.col_name (the new value). The value for NEW.col_name can be changed in BEFORE INSERT and UPDATE triggers.

The basic trigger syntax is:


CREATE
    TRIGGER `event_name` BEFORE/AFTER INSERT/UPDATE/DELETE
    ON `database`.`table`
    FOR EACH ROW BEGIN
		-- trigger body
		-- this code is applied to every 
		-- inserted/updated/deleted row
    END;

We require two triggers — AFTER INSERT and AFTER UPDATE on the blog table. It’s not necessary to define a DELETE trigger since a post is marked as deleted by setting it’s deleted field to true.

The first MySQL command we’ll issue is a little unusual:


DELIMITER $$

Our trigger body requires a number of SQL commands separated by a semi-colon (;). To create the full trigger code we must change delimiter to something else — such as $$.

Our AFTER INSERT trigger can now be defined. It determines whether the deleted flag is set, sets the @changetype variable accordingly, and inserts a new record into the audit table:


CREATE
	TRIGGER `blog_after_insert` AFTER INSERT 
	ON `blog` 
	FOR EACH ROW BEGIN

		IF NEW.deleted THEN
			SET @changetype = 'DELETE';
		ELSE
			SET @changetype = 'NEW';
		END IF;

		INSERT INTO audit (blog_id, changetype) VALUES (NEW.id, @changetype);

    END$$

Finally, we set the delimiter back to a semi-colon:


DELIMITER ;

The AFTER UPDATE trigger is almost identical:


DELIMITER $$

CREATE
	TRIGGER `blog_after_update` AFTER UPDATE 
	ON `blog` 
	FOR EACH ROW BEGIN

		IF NEW.deleted THEN
			SET @changetype = 'DELETE';
		ELSE
			SET @changetype = 'EDIT';
		END IF;

		INSERT INTO audit (blog_id, changetype) VALUES (NEW.id, @changetype);

    END$$

DELIMITER ;

It’s beyond the scope of this article, but you could consider calling a single stored procedure which handles both triggers.

Trigger Happy?

Let’s see what happens when we insert a new post into our blog table:


INSERT INTO blog (title, content) VALUES ('Article One', 'Initial text.');

A new entry appears in the `blog` table as you’d expect:

id title content deleted
1 Article One Initial text 0

In addition, a new entry appears in our `audit` table:

id blog_id changetype changetime
1 1 NEW 2011-05-20 09:00:00

Let’s update our blog text:


UPDATE blog SET content = 'Edited text' WHERE id = 1;

As well as changing the post, a new entry appears in the `audit` table:

id blog_id changetype changetime
1 1 NEW 2011-05-20 09:00:00
2 1 EDIT 2011-05-20 09:01:00

Finally, let’s mark the post as deleted:


UPDATE blog SET deleted = 1 WHERE id = 1;

The `audit` table is updated accordingly and we have a record of when changes occurred:

id blog_id changetype changetime
1 1 NEW 2011-05-20 09:00:00
2 1 EDIT 2011-05-20 09:01:00
3 1 DELETE 2011-05-20 09:03:00

This is a simple example but I hope it’s provided some insight into the power of MySQL triggers. In my next post we’ll implement a scheduled event to archive deleted posts.

If you enjoyed reading this post, you’ll love Learnable; the place to learn fresh skills and techniques from the masters. Members get instant access to all of SitePoint’s ebooks and interactive online courses, like PHP & MySQL Web Development for Beginners.

MySQL: Creating a simple stored procedure

Let’s start creating stored procedure with a very simple one and then we will analyse it line by line.

DELIMITER $$

DROP PROCEDURE IF EXISTS MyFirstSP$$
CREATE PROCEDURE MyFirstSP()
BEGIN
SELECT * FROM MyTable;
END$$
Analysis:

By default MySQL treats semicolon(;) as the statement terminator or end of statement. But as we are going to use it inside the procedure body, so we need another different delimiter to state the end of the stored procedure. DELIMITER $$ sets $$ as the statement terminator.
The DROP PROCEDURE IF EXISTS statement checks for a duplicate stored procedure with the same name and if there exists any then issue a DROP command. You can skip this line if you are sure that there is no other stored procedure exists with the same name in your selected database.
Statement CREATE PROCEDURE marks the start of the stored procedure definition. Here, MyFirstSP is the name of our stored procedure. The stored procedure name followed by a pair of parentheses. The use of these parentheses is to define parameters inside it. In this stored procedure we don’t need any parameters, but we have to put these parentheses as this is mandatory in MySQL unlike SQL Server.
The BEGIN Statement marks the start or begining of a block (here the block is the stored procedure itself).In stored procedures, every statements with multiple statements should be enclosed with a block defined by BEGIN and END, where END statement marks the end of the block;
The statement inside the BEGIN .. END is a simple SELECT query, which fetches all the records from MyTable table.

Top 5 Websites To Design Banners Online For Your Website

f you have a website and running ads on your website, banner is the common word for you. But, in case of designing banner, it is very difficult for most of us. If you try to design a banner using editing software like PhotoshopPaint etc. and not getting a best, no need to worry. I’m here with top 5 best websites for you to design banners for advertizing your website and for many purposes.

You can download all your created banners from the given sites. But keep in mind that all the sites are not free. It means that some of them are free and some are premium. With these websites, you’ll feel very easy to design banners online with fun and joy. These all websites are really interesting and make your job easy. So, just move of these websites and try your own banner online  for your website –

Websites to design banners

Websites to design banners

1. BannerSnack [Free&Premium]

BannerSnack is the best and most popular website to design banners online for free for your website. You can create many types of banner ads like Flash, Gif and HTML5 etc. You can download your designed banners from here. After the banner is created, you can attach a link with it and publish your banner to share it with public. This site provides you very easy way to design banners. To start creating banners, you can just log in with yourFacebook account, Twitter account, Google account , Yahoo account or by registering on BannerSnack and log in with its existing account.

After log in, you’ll see different banner sizes and different banner templates for appropriate size. So, now just select size for your banner start creating. You can also edit any of the available banner template on BannerSnack and design a best and animated ad banner for your website.

2. HTML5BannerAdd.Com [Premium]

It is an other ultimate website for designing banners for your website. Here you can design HTML banners which will be responsive and visible to phone and tablet devices as well. This site allows you to design banners for free but can not download your designed banners without paying the subscription money. Yes guys, you must have a subscription to design and download banners on this website. Here is three types of subscription membership – Monthly subscription, 1 Year full membership, Lifetime membership in $17, $47 and $77 respectively.

For more details and membership features, visit the site. So, after subscribing for a service, a subscription code will be emailed to you. This code is always asked by the website while you try to download your designed banner.

3. Fotor – Banner Maker [Absolutely Free]

As we all know that Fotor is an online free photo editing tool. It also allows you to design banners for your website without any membership or sign up and you can also download your designed banners very easily with a single click free of cost. It also doesn’t attach any link onto your banner like other sites. It simply behaves just like an offline photo editor and you can use it very easily as well.

Just visit the link and select the height and width for your banner and Click on Start Now. Start creating banner very simply by attaching images, texts and many more to make your banner look amazing and animated.

4. BannerFans [Absolutely Free]

BannerFans is also an amazing free website to design banners online to advertize your website. It allows you to design banners and download them without log in to website. Here you can design and download banners absolutely free. Just move on to the website and Start creating banner. It is a feature rich website which enables you to manage layout of banner, texts & fonts, shadows & effects, border and format. you can also upload your own image as background and can also use any image as the part of your banner.

You can also save your banner on your site’s profile by creating your account here. If you don’t want to register, you can also sign in with your FacebookGoogle or more accounts.

5. HTML5Maker [Free]

HTML5Maker is an ultimate website to design outstanding banners with animations. you candownload your designed banners for free. With this site, you’ll be able to design a such animated banner which will look like as designed by a brilliant designer. So, you don’t need any professional programing and designing skills. Just move to this site and create outstanding banners for your website.

HTML5Maker also allows you to become a member to get more facilities of HTML5Maker. You can get more details by visiting the website.

Cloud app vs. web app: Understanding the differences

 The line between a cloud app and a web app remains as blurry as ever. This of course stems from the natural similarities that exist between them. I’m of the opinion, however, that there are noteworthy differences, especially when looking to leverage cloud apps for richer user customization experience and seamless integration with resilient and scalable back-end infrastructure, which often characterizes public cloud services.

HERE IS DETAILS EXPLANATIONS OF CLOUD APP AND WEB APP:

CLOUD APP

For me, a cloud app is the evolved web app. It’s equally used to access online services over the Internet like web apps but not always exclusively dependent on web browsers to work. It’s possible for a customizable, multi-tenancy cloud app to be solely available over the web browser from service providers, but quite often the web-interface is used as alternative access methods to the custom built cloud app for online services.
Cloud apps are usually characterized by advanced features such as:
  • Data is stored in a cloud / cloud-like infrastructure
  • Data can be cached locally for full-offline mode
  • Support for different user requirements, e.g., data backup cloud app with different features such as data compression, security, backup schedule
  • Can be used from web browser and/or custom built apps installed on Internet connected devices such as desktops, mobile phones
  • Can be used to access a wider range of services such as on-demand computing cycle, storage, application development platforms

Examples of cloud apps

Some common examples include Mozy, Evernote, Sugar Sync, Salesforce, Dropbox, NetSuite, and Zoho.com. Other qualifying examples such as web email (Google, Yahoo, Microsoft Hotmail, etc.) may not be so obvious, but they depend on cloud technology and are available off-line if consumers so choose to have them configured as such.
There are numerous websites where you can find useful information on cloud apps. I foundwww.getapp.com to be particularly informative. It includes cloud app reviews and ratings to evaluate the apps.

WEB APPS

Web apps on the other hand are almost exclusively designed to be used from a web browser. A combination of server-side script (ASP, PHP etc) and client-side script (HTML, JavaScript, Adobe Flash) are commonly used to develop the web application. The web browser (thin client) relies on the web server components installed on backend infrastructure systems for the heavy lifting in providing its core functional web services.
The obvious benefit that this computing model provides over the traditional desktop app is that it is accessible from anywhere via the web browser. Cloud apps can also be accessed this way.

Examples of web apps

For many, including myself, web services such as WebEx, electronic banking, online shopping applications, and eBay fall into this category in as much as they are exclusively web-based with limited options for consumer customization.
In another example, I would include Facebook and similar types of web applications. I’m sure some will disagree with this, but I don’t think Facebook exactly offers customized services. It’s simply used as it is provided.

Conclusion

Application service providers have been quick to exploit advantages brought about by pioneering web app building framework technologies for greater customer reach. However these technologies are not necessarily optimized for building new apps for the cloud era.
Cloud apps are web apps in the sense that they can be used through web browsers but not all web apps are cloud apps. Software vendors often bundle web apps to sell as “cloud” apps simply because it’s the latest buzz-word technology, but web apps do not offer the same richness in functionality and customization you’ll get from cloud apps. So, buyer beware!
Some software application vendors also falsely think that just because their application runs on the web, this automatically qualifies it to be a cloud app. This is not always the case. For your web app to evolve into a cloud app, it should exhibit certain properties such as
  • True multi-tenancy to support various requirements & needs for consumers
  • Support for virtualization technology, which plays a starring role for cloud era apps. Web applications should either be built to support this or re-engineered to do so
The good news is that vendors looking to move into this cloud app space now have rich development platforms and frameworks to choose from. Whether migrating from an existing web app or even starting from scratch. These new age cloud app development platforms are affordable and agile, reducing time to market and software development complexities.

Download the Linux-based SteamOS and make your own SteamBox now

Valve has finally launched its Linux-based SteamOS for you to download and install on you own hardware. Despite being in “early stages of development” as the company puts it, enthusiasts are free to try it out and share their opinions on what they’d improve.

SteamOS is based on Debian GNU/Linux distribution version 7.1. The minimum hardware requirements aren’t as high as one would think with Valve’s OS needing an Intel or AMD 64-bit CPU, 4GB of RAM, 500GB HDD and an NVidia GPU – support for AMD GPUs is coming soon.

Basically, SteamOS relies heavily on the Steam Big Picture mode. Valve’s ultimate goal is to make SteamOS fluid, reliable and functional enough in order to take all the duties of a home media center. This is also great news for the Linux community, which finally seems to get attention from a large game distributor and that’s vital if it is to be regarded as an alternative to Windows when it comes to gaming.

Anyway, if you have the free time and hardware at hand, maybe you would be willing try it out for yourself. Check out the source link below to get started.