List Of All Countries In All Languages And All Data Formats

The List Of Countries usage scenario is simple – this is the task that need to be solved in majority of applications.  No matter which programming language or data format you use in your application or language you speak, this country list will suit your needs.

Formats Available:

• Text
• JSON
• YAML
• XML
• HTML (Select, Flags)
• CSV
• SQL
• PHP

For developers, this is the most common case, they simply need a country table for their database. There are few SQL dumps for each DBMS:

• MySQL
• PostgreSQL
• SQLite
• SQL Server

Multilingual

All formats are also available in multiple languages, please find full language list here.

Country Flags

Thanks to world-flags-sprite project generation of a special HTML version which includes country flags could be done. You can see demo page here.

Requirements: None
Demo: http://dev.umpirsky.com/…all-data-formats/
License: Free

SQL Fiddle - A Tool For Easy Online Testing And Sharing Of Database Problems And Their Solutions

SQL Fiddle is a tool for easy online testing and sharing of database problems and their solutions.  If you do not know SQL or basic database concepts, this site is not going to be very useful to you. However, if you are a database developer, there are a few different use-cases of SQL Fiddle intended for you.

You want help with a tricky query, and you'd like to post a question to a Q/A site like StackOverflow. Build a representative database (schema and data) and post a link to it in your question. Unique URLs for each database (and each query) will be generated as you use the site; just copy and paste the URL that you want to share, and it will be available for anyone who wants to take a look. They will then be able to use your DDL and your SQL as a starting point for answering your question. When they have something they'd like to share with you, they can then send you a link back to their query.

You want to compare and contrast SQL statements in different database back-ends. SQL Fiddle easily lets you switch which database provider (MySQL, PostgreSQL, MS SQL Server, Oracle, and SQLite) your queries run against. This will allow you to quickly evaluate query porting efforts, or language options available in each environment.

You do not have a particular database platform readily available, but you would like to see what a given query would look like in that environment. Using SQL Fiddle, you don't need to bother spinning up a whole installation for your evaluation; just create your database and queries on SQL Fiddle.

Requirements: None
Demo: http://sqlfiddle.com/#!2/a258k1/1
License: Free

DHTMLX - A JavaScript UI Library, Ajax Components & HTML5 Framework

dhtmlxSuite is a JavaScript library that provides a complete set of Ajax- powered UI components. Use dhtmlxSuite to build enterprise-level web apps with clean interface, fast performance, and rich user experience.

dhtmlxSuite delivers a rich collection of JavaScript UI components including powerful grid, treeview, calendar, windows, charts, and more. With the DHTMLX library, you can build great Ajax-based web apps fast.

dhtmlxGrid provides a high performing JavaScript solution to display and edit tabular data. The powerful features include rich inline editing, paging, filtering, searching, grouping capabilities, export to Excel, etc.

To simplify client-server communication, we offer dhtmlxConnectors, a set of special adapters for server-side backend: PHP, ASP.NET, JAVA, and ColdFusion. Supported databases: MySQL, PostgreSQL, Oracle, MSSQL, SQLite/SQLite3, FileSystem.

With Visual Designer tool, you can quickly build a prototype of a web app interface: define interface structure, set properties for each UI element, and activate event handlers. A handy online Skin Builder helps you customize the skin colors to meet your design needs.

Browser Support

With the DHTMLX JavaScript library, you can build rich Ajax-based web interfaces that will work in all major web browsers:

• Internet Explorer 6+
• Firefox 0.9+
• Safari 2.0+
• Chrome
• Opera 9.0+

Included UI Components

• Tree
• Grid
• TreeGrid
• Tabbar
• Menu
• Layout
• Windows
• Accordion
• Toolbar
• Combo
• Calendar
• DataView
• Form
• Chart
• ColorPicker
• Slider
• Ajax
• Editor
• DataProcessor
• DataStore
• Message

Requirements: None
Demo: http://dhtmlx.com/docs/products/demoApps/index.shtml
License: GPLv2