Connect With WRD
feed via e-mail
feed via e-mail

Posts Tagged ‘MSSQL’

AspxCommerce is an open e-commerce system that is built with ASP.NET and uses MSSQL for storing the data.

The application is built on top of SageFrame (the open source CMS) and comes with a single-click installation.

It has an easy-to-use admin panel for creating and managing categories, products, users, orders and the settings provided.


There are various marketing features like the ability to bundle products or discounts based on price/products.

AspxCommerce has different modules that an e-commerce site may need like community poll, customer testimonials, Google Maps store locator, etc.

The layout is themable and multiple themes exists to choose from or you can create your own with ease.

It is SEO-friendly, has a multi-language interface and updated/improved regularly.

Around 2 years ago, Microsoft had announced the first version of WebMatrix and it was shared at WRD.

Lately, they have made the release-candidate of WebMatrix 2 available and it has become an exciting product for many.

The tool now has support for the most recent web-dev technologies including HTML5-CSS3, Node.js or jQuery Mobile.

WebMatrix 2

It has a one-click installer for many popular apps including WordPress, Joomla, DotNetNuke and more. Also it can instantly install IIS, MSSQL, MySQL, PHP, Python and many others.

There is built-in support for Windows Azure cloud and the project scan be pushed to the remote environment to any FTP address or to the Azure.

Although WebMatrix 2 is a Microsoft product, it is well-integrated with PHP, any PHP functions hovered bring the docs from and there is code completion.

Users can share extensions written for the platform and there are already good ones like iPhone/iPad simulator or a color theme manager.

For anyone working with multiple database engines, regularly switching between different apps to manage them can be a pain.

DBeaver is a free database management application which works with many different engines including MySQL, MSSQL, Oracle, SQLite, Sybase, Firebird and much more.

As the application is built with Java, it works in all major operating systems (Windows, Mac & Linux).


It can handle all the major tasks like metadata editing (tables, columns, keys, indexes), custom SQL execution, users management, multiple connections, etc.

We can draw ER diagrams for database modeling, and, the app is soon to be open sourced.

If you are an ASP.NET developer, you already know that there are not too many choices when it comes to finding an open source CMS application.

SageFrame is a good alternative for any looking for such a solution. It is a feature-rich and open source content management system, built with ASP.NET, to create websites easily.

The application enables users to customize/update the websites while browsing by simply interacting with the editable modules.


There is a good-looking admin panel to customize everything; including changing the site design by drag 'n' dropping the locations of the modules, defining new menu items or improving the SEO-friendliness.

SageFrame is modular, it can be extended with modules where you can choose to create them or download the ready-to-use ones.

ArrowChat is a jQuery-powered, PHP/MySQL (or MSSQL) application for quickly adding chat support to any website so that visitors/members can easily communicate with each other.

The application features a Facebook-like chat system which sits in the footer of websites, presents the online users and allows them to chat instantly.


Users can choose to chat in private or inside full-featured chatrooms (which can be password-protected with moderators, kicking, etc.). And, they are instantly notified about new messages or friend requests.

ArrowChat also has video chat which is Flash-based and works smoothly. This is specially great for social networking websites.

It has a set of integrated applications from games to social sharing or instant web page translation to offer more features to users.

ArrowChat Chat

The application is also great for sending announcements as they are sent in real-time and you feel sure that each user logging in sees them.

Managing the application is easy for both the end users and the system admin as users get an options panel to customize everything and admins have an admin panel to control each and every feature.

It is possible to customize the look and feel of the application with theming support and also customize/improve the functionality as ArrowChat is fully open sourced.

ArrowChat Integrations

And, best of all, ArrowChat has integrations for many popular apps including forum softwares, social networking softwares and others like WordPress, Joomla or Drupal. Once installed, the system works with existing users, avatars and profiles.

P.S. The system works with all major browsers including mobile.

The discount

ArrowChat provides 10% discount to all WRD readers who use the coupon code "WRD" (the coupon will expire on 5/31/2012 and Credit/Debit Card must be selected at checkout to use the code -PayPal can still be used with this method-).

How to join the giveaway?

ArrowChat is giving away 3 KickStarter Licenses ($45/each) to WRD readers.

If you want to join the giveaway, you can choose one of the methods below or do both to increase your chances:

Winners will be selected randomly on 12 April 2012 (1 week later). Good luck to all.

The winners

Here are the winners:

  • @ian_chan
  • Jason (comment #557436)
  • k19s (comment #553902)

Congratulations to the winners and thanks to everyone for joining.

CometChat, a powerful chat application for websites (which was previously shared at WRD), has recently released the 4th version with new features and giving away 4 licences (3 Basic and 1 Pro) to WRD readers to celebrate the event.

In order to join the giveaway, please make sure you check the details at the bottom of this post.

What is CometChat?

It is a PHP-MySQL (or MSSQL) powered application that enables users of a website to easily communicate with each other and interact with the website.

CometChat One on One

CometChat sits in the footer of a website and supports both text (including group chat) + video/voice chat. It also allows file transfers, screensharing and, with the most recent version, the ability to chat with Gtalk and Facebook friends.

This is an exciting feature as it helps "the activity of users to grow" by keeping them on the website more.

CometChat FAcebook and Gtalk Integration

The application also offers more than chat:

  • it has 100+ built-in games -including multiplayer ones-
  • users can write or draw together on whiteboards or writeboards
  • it is possible to publish announcements
  • integrates Facebook fan page and displays Twitter activities
  • works as a social share widget

There are integrations with many other popular softwares (like JomSocial, vBulletin, SocialEngine, Invision Power Board, phpFox, Boonex Dolphin, BuddyPress, phpBB, WordPress, SkaDate, Elgg and more) exist.

CometChat Mobile

With the new version, there is now a mobile web interface which works in all major devices/platforms.

CometChat can be completely customized to better with the style of any website and it can be controlled very easily with the help of a powerful admin panel with settings for everything.

The discount

CometChat is offering a 10% discount to all Professional Edition or higher purchases until 1st of November with the coupon code: "WRD10OFF" (without quotes).

How to join the giveaway?

CometChat is giving away 1 Pro and 3 Basic licenses to WRD readers. In order to join the giveaway, just comment to this post and the random query below will be choosing the winners:

SELECT * FROM wp_comments WHERE comment_post_id=2537 AND comment_approved=1 AND comment_type='' GROUP BY comment_author_email ORDER BY RAND() LIMIT 4

Winners will be announced 1 week later (1 November 2011) as an update to this post. Good luck.

The winners

Here are the winners of CometChat licenses:

  • Derek (comment #422062) – Pro license
  • NiK Makovka (comment #417901) – Basic License
  • MasterChowl (comment #418049) – Basic License
  • Dennis (comment #418259) – Basic License

Congratulations and thanks very much for joining.

Most of the MySQL users will remember MySQL-Front, a very popular database manager application which later on stopped being developed (and turned into a paid application by another team).

The developer of this application, Ansgar Becker, re-launched this project under the name HeidiSQL, it is again free + open source and improved regularly.

HeidiSQL can connect to multiple databases and besides creating/editing databases, tables, views, stored routines and triggers, it has support for scheduling events (great for regular jobs like backups).


Databases and records can be exported or imported with multiple formats and its even possible to transfer a database directly into another server.

Currently experimental but HeidiSQL can now connect and manage MSSQL databases which is awesome for anyone working with both platforms.

There are many other handy features offered like optimize/repairing tables, duplicating them or query editing with syntax highlighting.

DaDaBIK is an open source and mature PHP application for creating a customizable database front-end without coding.

Within minutes, you can create a basic CRUD (create, read, update, delete) application or dive into its features to build a more complicated one.

DaDaBIK DAtabase Front-end

It doesn't generate a PHP script, stores the settings and can easily adapt to changes made in the database schema.

The application works with MySQL, PostgreSQL, Oracle + MS SQL Server and has features like choosing:

  • if the field must be included or not in a search/insert/update form and results table
  • labels
  • content format (e.g. numeric, alphabetic, e-mail, url…)of a field
  • the HTML input type (e.g. textbox, menu, date, rich text editor, password box…)
  • the possible values, also driven from another table (foreign key support)
  • and much more…

Some other exciting features include:

  • master/details view (attaching 2 or more tables to each other like choosing a user from "users" table and seeing his orders from "orders" table)
  • file uploading
  • exporting to CSV
  • e-mail notices

DaDaBIK is multilingual with support for 10+ languages.

WebMatrix is a free kit by Microsoft which includes everything you need for creating websites on Windows.

The application itself enables you to control almost everything from a single interface like the code and database editor, web site and server management, search optimization, FTP publishing, and more.

Microsoft WebMatrix

The kit comes with:

  • IIS Developer Express (a development Web server)
  • ASP.NET (a Web framework)
  • SQL Server Compact (an embedded database)

and with just a click, you can install open source applications like WordPress, Drupal, DotNetNuke, etc.

WebMatrix has also some nice features like the ability to run a SEO report or monitor real-time Web requests and responses to track down problems right at the source.

OTRS is an open source trouble ticket system for easily managing support requests in a multi-agent interface.

The application can auto-convert e-mails into tickets (e-mail piping) which "eliminates the need of using the web interface" for customers.

OTRS Support Ticket System

OTRS is used by large organizations like Opera, MySQL AB, BitDefender, Suse & has very nice features like:

  • transfer of tickets between agents
  • auto-calculation of hours worked on a ticket
  • powerful reporting
  • canned responses
  • multilanguage support
  • themable web interface
  • role-based user management
  • & much more..

OTRS is built with Perl & can work with different databases (e. g. MySQL, PostgeSQL, Oracle, DB2 and MSSQL).

It has one-click installers for multiple operating systems (including Windows).

Uptime Robot