use sql and pl sql - noradle/noradle-oracle-server GitHub Wiki

refs

Key takeaways The population of developers working with relational databases and SQL doesn’t shrink but is expanding naturally with the growth of the global developer community.
Developers keep writing SQL code, browsing data, running queries and taking care of their performance. A lot of business logic still resides within the database: stored procedures and triggers continue to be heavily used.
Database software doesn’t stand still either: it’s impressive how fast PostgreSQL is evolving and now competing with major players. NoSQL databases surely occupy their niche, but don’t seem to be replacing relational databases. This makes us think SQL will remain a solid and reliable tool for dealing with data.
In terms of transition to clouds, Amazon is the absolute leader among vendors, even when it comes to where data are hosted. Still, there’s a long way to go, as well as a lot of room and time for other players to step in, since the majority still hosts on private servers. The number of developers involved in big data is even higher than we expected to see. It seems more people stop talking about big data and start doing it – and that’s good.
The findings shared in this report of course cannot be taken as the ultimate truth, nor can they be extrapolated to other cases. Nonetheless, the study did answer a number of important questions for us to help us better understand our users’ needs and hopefully improve the quality of our developer tools.

个人观点

  • 关系模型、SQL对输出的处理方式、PL/SQL存储过程都是处理业务的核心
  • SQL 是第四代编程语言,是数据处理的DSL,更灵活和强大
  • PL/SQL 是 SQL 的最佳粘合剂、是业务逻辑处理的流程控制器
  • 通用语言是从OS层面开发发展出来的,在开发信息系统(数据库应用)方面应该让位于数据处理的专用DSL
  • 应该赋予 PL/SQL 除了粘合SQL进行输出处理之外的更多的功能,确立核心地位,而不是仅仅作为普通第三代语言下软件的资源