i was offered a task in relation to 4D database, however, I do not have any database skill such as SQL, I can program but not in database aspect, just wondering should I learn some SQL before 4D database? Or are they totally different? Thanks for suggestion.
Asked
Active
Viewed 460 times
1 Answers
5
4D is much more than just a database; it includes a GUI designer, has it's own programming language and includes a compiler for building double-clickable applications. There are many plugins extending the product and a plugin SDK that allows you to write c++ code to extend it yourself. The possibilities of 4D are pretty limitless. The main point here is that you could create an application that does not even use the database engine therefore database background would not be so important.
You don't need to know SQL to program in 4D. There is a sql layer but you can also use the non-SQL commands to achieve most of the same tasks. Granted that SQL may be better suited for some tasks, and the only option for others (see replication and synchronization). In general you should learn SQL as it will help in many different languages but don't let not knowing SQL stop you from using or learning 4D.
The 4D programming language has extensive documentation on doc.4d.com:
The 4D Language Reference contains the core commands
The 4D SQL reference covers the SQL aspect of the language.
The 4D Design Reference covers aspects of the design environment.
There is also a short crash course section on wikipedia that may be helpful to give you a glimpse of the language
Tim Penner
- 3,551
- 21
- 36