Monthly Archives

29 Articles

Posted by .Ronald on

Aptana Studio

We are very proud to have released Aptana Studio 1.0 (formerly Aptana IDE). After over two years of non-stop development and close to a million downloads, we have finally reached ‘1.0’. Along with the release of 1.0, we have also created two editions of the product: Community and Professional. The Community Edition is the keystone of the Studio product, where all core features and capabilities are developed. The Professional Edition brings additional features and services beyond the free Community edition. Aptana Studio isn’t the only product we’re working on, and you’ll see more from us soon. In the mean time, if you are using Aptana Studio professionally, support our efforts by ‘going Pro’. Whichever edition you chose to use, Community or Professional, we look forward to your feedback, feature requests, and comments. It is our community that helps us build a better product — a product that ultimately is for you.

-Paul Colton, CEO
Aptana Studio

Posted by .Ronald on

Particletree » Ranked Searches with SQL

A handy trick to add some sort of ranking to SQL search results:

Creating some sort of search functionality is something we all have to do at one point or another. For the good cases, we have fulltext search or an external program available to us. But sometimes, getting down and dirty with plain SQL is the only option.

SELECT
SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4))
AS Occurrences

Particletree: Ranked Searches with SQL

Posted by .Ronald on

Net Profiles

With Net Profiles, mobile computing becomes a whole lot easier. It eliminates the need to manually reconfigure your network settings when you move your desktop/laptop computer to another location. Once a profile is created, Net Profiles can configure your IP settings, proxy settings, mapped drives, default printer, wallpaper, and screen resolution with a click of a button; as well as run any number of user-defined applications upon activation of a profile.

Net Profiles