SQLite 3.6.18 Released!!

SQLite가 한달 만에 업데이트가 되었다.

사이트 에서는 이전 버전 3.6.12 이전 버전의 사용자는 업그레이드를 추천하고있다.

이번 버전에서 수정된 사항은 아래와 같다.
SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)

• Versioning of the SQLite source code has transitioned from CVS to Fossil.
• Query planner enhancements.
• The SQLITE_ENABLE_STAT2 compile-time option causes the ANALYZE command to collect a small histogram of each index, to help SQLite better select among competing range query indices.
• Recursive triggers can be enabled using the PRAGMA recursive_triggers statement.
• Delete triggers fire when rows are removed due to a REPLACE conflict resolution. This feature is only enabled when recursive triggers are enabled.
• Added the SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags for sqlite3_open_v2() used to override the global shared cache mode settings for individual database connections.
• Added improved version identification features: C-Preprocessor macro SQLITE_SOURCE_ID, C/C++ interface sqlite3_sourceid(), and SQL function sqlite_source_id().
• Obscure bug fix on triggers ([efc02f9779]).
  
  Original Post : http://neodreamer-dev.tistory.com/321

무료 아이콘 편집기 Greenfish Icon Editor 1.6 Pro

전에 포스팅했던적이 있는 무료 아이콘 편집기가 버전업을 하였다.

2008/05/28 - [Com. Story/Apps] - Vista Icon 까지 지원하는 무료 아이콘 편집기 Greenfish Icon Editor

다양한 기능을 갖춘 툴이지만 사용은 무료이다.

홈페이지의 소개글 보기

This program is a professional, yet easy to use tool for designing and retouching icons, cursors, animations and static images.

Why is it recommended for everyone?

    * Easy to use, lightweight, no installation (portable)
    * Supports file drag and drop
    * Multilanguage user interface (English, Chinese, Dutch, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Brazilian), Russian, Serbian, Spanish)
    * Help also available in French, separate download
    * Click here to help us by translating the program
    * Uses dynamic color depth: you do not have to specify it explicitly, Greenfish Icon Editor will determine it for you.

Greenfish Icon Editor Pro allows you to...

    * work with ICO, CUR, ANI, PNG, XPM, BMP, JPEG and GIF files (open & save)
    * design icons and cursors up to 256x256 @ 32-bit, which can also be PNG-compressed for use in Windows Vista(tm)
    * make animations (cursors and GIF files)
    * extract icons and cursors from executable files and icon libraries
    * batch convert image files to icons, or to another image format
    * assemble 32-bit icon library (ICL) and resource (RES) files
    * edit images up to 1024x1024 (and the limit can be increased)
    * use advanced selection tools (lasso, wand, pencil, saving/loading selections)
    * use various gradient styles and filters (e.g. Remove matte, Drop shadow, Inner/Outer glow and Bevel)

And, it's FREE!

Greenfish Icon Editor 웹페이지
Greenfish Icon Editor 1.6 Pro Download


Original Post : http://neodreamer-dev.tistory.com/145

MySQL 을 위한 무료 데이터 모델링 툴

MySQL Workbench

기존 프로그램의 데이터 구조를 새로 작성을 해야할 일이 생겨 쓸만한 데이터 모델링 툴을 찾다가 알게된 녀석이다.

이전에는 Toad Data Modeler 를 사용했지만 무료 버전에는 제약이 있어서 불편한 점이 있었다. 다른 상용툴에 뒤지지 않는 MySQL Workbench 는 프로그램 이름에서도 알 수 있듯이 MySQL 만을 위한 모델링 툴이다. Toad Data Modeler 나 ModelRight 같은 상용툴의 경우 디자인시 원하는 데이터베이스 엔진을 선택하여 작성할 수 있지만 MySQL Workbench 는 MySQL 에 맞춰있다.

MySQL Workbench 디자인 화면

생성된 스크립트

MySQL Workbench Website

Original Post : http://neodreamer-dev.tistory.com/136

쓸만한 무료 아이콘 편집기 IcoFX

인터넷 서핑 중 성능좋은 무료 아이콘 툴을 발견했다.

256x256 크기의 32bit 컬러 아이콘까지 만들 수 있으며 윈도우즈 뿐만 아니라 Mac OS X 아이콘까지 편집할 수 있다.

다음은 IcoFX 웹페이지에서 발췌해온 IcoFX 의 기능이다.

Features of IcoFX
    * Support for Vista icons with PNG compression
    * Create icons for Windows 98 / ME / 2000 / XP / Vista / Macintosh
    * Support for alpha channel (transparency)
    * Batch processing for handling multipple files
    * New: Built in resource editor for creating icon libraries or changing icons inside exe files
    * New: Zoom icons up to 10000% for increased precision
    * New: Import image dialog, for creating icons from images
    * New: Convert Macintosh icons to Windows icons and vice versa
    * New: Open, save, edit and convert Macintosh OS X icons
    * New: Extract Macintosh icons from resource files
    * New: Snapshot window for creating overviews of the icons
    * More than 40 built in effects, including Drop Shadow
    * Use custom filters to create your own customized effects
    * Multiple language support
    * Resolutions up to 256x256
    * Data types: 2, 16, 256, True Color, True Color + Alpha (optional dithering for 2, 16, 256 colors)
    * Extract icons (including Vista icons) from 32 bit exe and dll
    * Import / export images (transparency also) from bmp, jpg, gif, png, jp2
    * Many useful drawing tools like brush, line, rectangle and more
    * Transparent, Brighten/Darken, Blur/Sharpen tools for retouching
    * Create icon from an image with a single click
    * Adjust the contrast, brightness, hue, saturation, transparency and color balance of icons
    * Change the dimension of images
    * Images can be faded using the fadeout dialog
    * Increase / decrease the opacity of an image
    * Easy shadow handling
    * RGB and HSB color modes
    * History of recently opened files
    * Window menu for easy window switching
    * Possibility to store favorite colors
    * Capture image from the desktop
    * Grid for precision work
    * Side bar for easy image switching
    * File Explorer window for easy file browsing and importing
    * Full drag and drop support
    * Sizable preview window
    * Multiple undo
    * Blur the edge of the brush
    * Rotate the image at any angle


웹페이지
설치파일 다운로드
Portable 다운로드
Original Post : http://neodreamer-dev.tistory.com/135