TweetFollow Us on Twitter

4D Databases
Volume Number:10
Issue Number:7
Column Tag:More tools for your toolbox

Developing 4th Dimension Databases
Can Be Lucrative

Will your next application framework be a database?

By Ellen Ankuda, ACI US

About this article

Developers have a number of tools at their disposal for building what their clients need. Databases are to the point where you can build certain kinds of applications without the need to write your own database code. Not only that, the demand for developers who know the database tools is higher than ever, and there are not enough developers to fill that demand. In this article, Ellen Ankuda (of ACI US) talks about some of the money-making opportunities in the database field, as seen from the perspective of a provider of a popular database, 4th Dimension - Ed stb

So you’re looking for the best way to spend your time, and in today’s market you have to have an edge. An advantage. Some reason why you’re more qualified than the next programmer. And once you have that certain something that sets you apart from the rest, you wouldn’t mind a market that’s teeming with opportunities.

For a C or C++ programmer, where do you get that edge? 4th Dimension can give you one. The relational database from France supports hundreds of developers and VARs in North America, thousands in the world. Those 4D enthusiasts range from custom consultants to VARs to in-house programmers. Consultants make their living creating custom database solutions for companies, the government, educational institutions, and almost any organization you can imagine. Their jobs typically involve travel; contracting work can bring them to far reaches of the computer world (one 4D consultant even made a database for a school district in the North Pole). Custom 4D developers typically make between $50 to $200 an hour, depending on the area and project.

Since VARs sell their shrink-wrapped applications developed in 4th Dimension, the job of a VAR tends to be somewhat more local. In addition to being a database, 4th Dimension is an application generator that allows people like VARs to create tangible software programs from good business ideas. And because most of the work is already done in 4th Dimension, development time for special applications is relatively short (meaning that time to market is a lot faster!). The programs can have any look and feel, depending on the needs of the target market and the personal tastes of the VAR. Currently, ACI VARs market off-the-shelf applications such as accounting packages, personal information managers, and network administration programs.

And lastly, in-house programmers might have a little less independence than the other two (of course, that all depends on the company), but working for companies has its advantages, too. 4th Dimension can be found in thousands of companies worldwide, including many Fortune 500 companies. Often working with people throughout the company to design tailored solutions, in-house 4D programmers benefit from immediate user feedback.

Learning the 4D programming language is generally a relatively elementary task for C and C++ programmers. ACI provides training around the country, as do various independent training organizations (yet another possible opportunity for you). For extra help, various publishers circulate books and magazines to help you learn the new environment and give you programming hints or tips to accomplish tasks with a minimum of effort.

If you’re not interested in learning the 4th Dimension language, there are still developer opportunities with 4D. C, C++, and Pascal programmers can write externals for 4th Dimension that can be integrated into any 4D database. These externals can be anything from time-tracking devices to mail messaging systems. Or you can even write externals that work with 4D via AppleEvents, such as geographic querying tools. The potential external programs for 4D are limitless - you decide what specific users might need and integrate your idea into a working database. “With its ability to work with external programs, 4th Dimension is highly extensible. You can use your C/C++ expertise to significantly extend 4D’s functionality,” states Rich Gay, President of Foresight Technology, a software consulting company in Fort Worth, Texas. “But the biggest benefit of 4th Dimension for C and C++ programmers is that it’s so much faster to get applications up and running in 4D, and that translates into higher profitability.”

In a similar vein, you can develop 4D Open connections to different products that enable interaction between foreign clients and 4D Server. 4D Open is the programming interface for connectivity to 4D Server, ACI’s client/server database, and has a set of Pascal and C libraries. With the basic libraries, you can interface almost any product with 4D Server. Use your imagination: what type of product would benefit from a multi-user data engine?

Available support

For programmers whose livelihood depends on a software program, the technological aspect of the program is probably the most important. The procedural language of 4th Dimension is designed to parallel the built-in features of the database. Almost everything that can be done automatically can be further controlled procedurally. All of the built-in editors and generators, such as Search, Sort, Report, Label, and Graph, can be used in a custom application with a single-line procedure. “You can create an incredible front end with a great GUI in a fraction of the time required by traditional programming languages,” reports Jim Alonso, President of Montage Software Systems, Inc. in Wilton, Connecticut. “There are virtually no limits to what can be accomplished using 4D’s built-in tools, and by creating extensions written in C to enhance that environment.”

You can use the 4th Dimension language to automate repetitive tasks, control the user interface, manage data, and create applications. The commands in 4th Dimension are structured to allow a precise response to a demand, often with very few lines of programming. For example, the command MODIFY SELECTION can present a list of records and allow the user to double-click a record for data input.

All users programming in C, Pascal, or any other language that can be compiled to 68000 code can add routines to applications in the following forms:

• External procedures that can accept and pass parameters.

• External areas on layouts that are completely controlled by external routines.

• External functions that return a 4th Dimension value.

Added routines transparently blend with the regular 4D commands and behave in the same manner.

4th Dimension is a programmer’s database. If the 4th Dimension language can’t accomplish a task, then you can program an external that will perform the required function. To increase your database’s marketability, you can also localize applications for dozens of languages, and that serves to increase the scope of your potential customer base.

Also important for developers are the benefits they can receive from the company itself. All registered 4D developers, no matter what type of programming they’re doing, get special care from ACI. Probably the most important benefit for developers are the business leads and referrals that Developer Services personnel provide. Any time a caller asks for a local developer, or a specific product or service, ACI sends a list of the appropriate developers. Referrals are also given to interested trade show attendees.

Annually, ACI prints and widely circulates a Solutions Guide book and CD that list all registered ACI developers and the products or services they provide. Being featured in the 800-page book is an impressive and credible sales tool for many developers.

Additionally, 4D developers receive priority technical support from senior engineers. Complex questions can be answered quickly. ACI also provides co-marketing possibilities in its newsletter or other mailings, in magazines, at trade shows, and many other areas.

The best news is that people need 4D programmers. Especially recently, ACI has been hearing from all sorts of companies, large corporations down to small consulting firms, who are looking for 4D programmers to develop an application. The time is right, and the opportunities are plentiful.


Community Search:
MacTech Search:

Software Updates via MacUpdate

Printopia 3.0.8 - Share Mac printers wit...
Run Printopia on your Mac to share its printers to any capable iPhone, iPad, or iPod Touch. Printopia will also add virtual printers, allowing you to save print-outs to your Mac and send to apps.... Read more
BetterTouchTool 2.417 - Customize multi-...
BetterTouchTool adds many new, fully customizable gestures to the Magic Mouse, Multi-Touch MacBook trackpad, and Magic Trackpad. These gestures are customizable: Magic Mouse: Pinch in / out (zoom... Read more
Mellel 4.1.0 - The word processor for sc...
Mellel is the leading word processor for OS X and has been widely considered the industry standard for long form documents since its inception. Mellel focuses on writers and scholars for technical... Read more
ScreenFlow 7.3 - Create screen recording...
ScreenFlow is powerful, easy-to-use screencasting software for the Mac. With ScreenFlow you can record the contents of your entire monitor while also capturing your video camera, microphone and your... Read more
Dashlane 5.9.0 - Password manager and se...
Dashlane is an award-winning service that revolutionizes the online experience by replacing the drudgery of everyday transactional processes with convenient, automated simplicity - in other words,... Read more
ForkLift 3.2 - Powerful file manager: FT...
ForkLift is a powerful file manager and ferociously fast FTP client clothed in a clean and versatile UI that offers the combination of absolute simplicity and raw power expected from a well-executed... Read more
Cocktail 11.5 - General maintenance and...
Cocktail is a general purpose utility for macOS that lets you clean, repair and optimize your Mac. It is a powerful digital toolset that helps hundreds of thousands of Mac users around the world get... Read more
Hazel 4.2.4 - Create rules for organizin...
Hazel is your personal housekeeper, organizing and cleaning folders based on rules you define. Hazel can also manage your trash and uninstall your applications. Organize your files using a familiar... Read more
Skype - Voice-over-internet pho...
Skype allows you to talk to friends, family, and co-workers across the Internet without the inconvenience of long distance telephone charges. Using peer-to-peer data transmission technology, Skype... Read more
Backup and Sync 3.40.8921.5350 - File ba...
Backup and Sync (was Google Drive) is a place where you can create, share, collaborate, and keep all of your stuff. Whether you're working with a friend on a joint research project, planning a... Read more

Latest Forum Discussions

See All

Destiny meets its mobile match - Everyth...
Shadowgun Legends is the latest game in the Shadowgun series, and it's taking the franchise in some interesting new directions. Which is good news. The even better news is that it's coming out tomorrow, so if you didn't make it into the beta you... | Read more »
How PUBG, Fortnite, and the battle royal...
The history of the battle royale genre isn't a long one. While the nascent parts of the experience have existed ever since players first started killing one another online, it's really only in the past six years that the genre has coalesced into... | Read more »
Around the Empire: What have you missed...
Oh hi nice reader, and thanks for popping in to check out our weekly round-up of all the stuff that you might have missed across the Steel Media network. Yeah, that's right, it's a big ol' network. Obviously 148Apps is the best, but there are some... | Read more »
All the best games on sale for iPhone an...
It might not have been the greatest week for new releases on the App Store, but don't let that get you down, because there are some truly incredible games on sale for iPhone and iPad right now. Seriously, you could buy anything on this list and I... | Read more »
Everything You Need to Know About The Fo...
In just over a week, Epic Games has made a flurry of announcements. First, they revealed that Fortnite—their ultra-popular PUBG competitor—is coming to mobile. This was followed by brief sign-up period for interested beta testers before sending out... | Read more »
The best games that came out for iPhone...
It's not been the best week for games on the App Store. There are a few decent ones here and there, but nothing that's really going to make you throw down what you're doing and run to the nearest WiFi hotspot in order to download it. That's not to... | Read more »
Death Coming (Games)
Death Coming Device: iOS Universal Category: Games Price: $1.99, Version: (iTunes) Description: --- Background Story ---You Died. Pure and simple, but death was not the end. You have become an agent of Death: a... | Read more »
Hints, tips, and tricks for Empires and...
Empires and Puzzles is a slick match-stuff RPG that mixes in a bunch of city-building aspects to keep things fresh. And it's currently the Game of the Day over on the App Store. So, if you're picking it up for the first time today, we thought it'd... | Read more »
What You Need to Know About Sam Barlow’s...
Sam Barlow’s follow up to Her Story is #WarGames, an interactive video series that reimagines the 1983 film WarGames in a more present day context. It’s not exactly a game, but it’s definitely still interesting. Here are the top things you should... | Read more »
Pixel Plex Guide - How to Build Better T...
Pixel Plex is the latest city builder that has come to the App Store, and it takes a pretty different tact than the ones that came before it. Instead of being in charge of your own city by yourself, you have to work together with other players to... | Read more »

Price Scanner via

Back in stock! Apple’s full line of Certified...
Save $300-$300 on the purchase of a 2017 13″ MacBook Pro today with Certified Refurbished models at Apple. Apple’s refurbished prices are the lowest available for each model from any reseller. A... Read more
Back in stock: 13-inch 2.5GHz MacBook Pro (Ce...
Apple has Certified Refurbished 13″ 2.5GHz MacBook Pros (MD101LL/A) available for $829, or $270 off original MSRP. Apple’s one-year warranty is standard, and shipping is free: – 13″ 2.5GHz MacBook... Read more
Apple restocks Certified Refurbished 2017 13″...
Apple has Certified Refurbished 2017 13″ MacBook Airs available starting at $849. An Apple one-year warranty is included with each MacBook, and shipping is free: – 13″ 1.8GHz/8GB/128GB MacBook Air (... Read more
8-Core iMac Pro on sale for $4699, save $300
Amazon has the 8-core iMac Pro on sale for $4699 including free shipping. Their price is $300 off MSRP, and it’s the currently lowest price available for an iMac Pro. For the latest up-to-date prices... Read more
10″ 512GB WiFi iPad Pros on sale for $849, sa...
B&H Photo has Space Gray and Rose Gold 10.5″ 512GB WiFi iPad Pros on sale for $849. Their price is $150 off MSRP, and it’s the lowest price available for these models, new, from any Apple... Read more
MacBook Pro sale! B&H drops prices on new...
B&H Photo has dropped prices on new 2017 13″ MacBook Pros, with models now on sale for up to $200 off MSRP. Shipping is free, and B&H charges sales tax for NY & NJ residents only. Their... Read more
13″ MacBook Airs on sale for $100-$150 off MS...
B&H Photo has 13″ MacBook Airs on sale for $100-$150 off MSRP. Shipping is free, and B&H charges sales tax for NY & NJ residents only: – 13″ 1.8GHz/128GB MacBook Air (MQD32LL/A): $899, $... Read more
Huge iMac sale! Apple reseller now offering 2...
B&H Photo has new 2017 21″ & 27″ iMacs on sale today for up to $300 off MSRP. Shipping is free, and B&H charges sales tax for NY & NJ residents only: – 27″ 3.8GHz iMac (MNED2LL/A): $... Read more
Sale! 1.4GHz Mac mini for $399, $100 off MSRP
B&H Photo has the 1.4GHz Mac mini on sale for $399 for a limited time. Their price is $100 off MSRP, and it’s the lowest price available for a mini from any Apple reseller: – 1.4GHz Mac mini (... Read more
Sale of the year continues as Apple resellers...
Adorama has new 2017 15″ MacBook Pros on sale for $250-$300 off MSRP. Shipping is free, and Adorama charges sales tax in NJ and NY only: – 15″ 2.8GHz Touch Bar MacBook Pro Space Gray (MPTR2LL/A): $... Read more

Jobs Board

*Apple* Retail - Multiple Positions - Apple,...
Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, you're also the Read more
Data Scientist, *Apple* Ecosystem (AMP Anal...
# Data Scientist, Apple Ecosystem (AMP Analytics) Job Number: 113428728 Santa Clara Valley, California, United States Posted: 24-Jan-2018 Weekly Hours: 40.00 **Job Read more
*Apple* Professional Learning Specialist - A...
# Apple Professional Learning Specialist Job Number: 113456892 Englewood, NJ, New Jersey, United States Posted: 02-Feb-2018 Weekly Hours: 40.00 **Job Summary** The Read more
*Apple* Retail Online, Senior Financial Anal...
# Apple Retail Online, Senior Financial Analyst Job Number: 57228835 Santa Clara Valley, California, United States Posted: 12-Feb-2018 Weekly Hours: 40.00 **Job Read more
Site Reliability Engineer, *Apple* Pay - Ap...
# Site Reliability Engineer, Apple Pay Job Number: 113356036 Santa Clara Valley, California, United States Posted: 12-Jan-2018 Weekly Hours: 40.00 **Job Summary** Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.