application languages corresponding with underlying database

are there any specific stats/trends around the language used to develop applications which will be storing data in SQL Server and running on windows server?

I wondered if some application development languages are more common based on the OS/Database on which they will be operating? Or if its completely generic and there are just as many apps built in any development languages regardless of which database and OS they will be working with.

Was trying to develop on windows servers where the apps DB is SQL Server, if there was more common development languages used, and like wise on non windows OS with oracle DB, which language is more common on that stack for development of the application tier?

Or in general - which are the most popular development languages in 2015?
LVL 3
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Carl TawnSystems and Integration DeveloperCommented:
It can vary a lot. You tend to find SQL server will have some related Microsoft technology stack sat on top of it .Net, MS C++, etc. Correspondingly you will see LAMP platforms where you have PHP and/or Java sat on top of MySQL. In my experience Oracle tends to get a bit more of a mixed bag.

But these are all interchangeable, and there are no fixed rules. I've written .Net apps for Oracle and MySQL in the past, but you will tend to find Microsoft houses will use SQL Server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gr8gonzoConsultantCommented:
The most popular development languages in 2015 - there was an article on this recently:
http://www.inc.com/larry-kim/10-most-popular-programming-languages-today.html

Quick list:
1. Java
2. Python
3. C++
4. Ruby
5. Javascript
6. C#
7. PHP
8. Objective-C
9. SQL
10. C

Of course, that's just one particular view, but the majority of those languages tend to be on most other lists. In my opinion, the top languages should really be a mix of:

Java, C#, PHP, Python, Ruby

If you're planning on developing on a SQL Server / Windows stack, your best bet for compatibility is probably a .NET application, like C# or ASP.NET.
0
pcelbaCommented:
You may look at Tiobe index which lists monthly updated popularity of programming languages. The graph displaying the language popularity is very interesting.

Your particular question about SQL Server is a little bit unclear. Several hundreds database engines exist today many of them use SQL language...

SQL Server (see the upper case S) is used for MS SQL Server obviously. Its SQL dialect is named T-SQL (or Transact-SQL) - position 36 on August 2015 index.

Oracle SQL uses PL-SQL, FoxPro also has its own SQL dialect, MySQL as well, etc. etc.

The SQL does not allow to write an application having all necessary parts, i.e. User interface, Business logic, and Data processing layer.  SQL is used to access the data. To use it for business logic is also possible but not obvious and it causes many problems. SQL can be used

Ideal application does not restrict the OS which can be used. Of course, the UI is OS dependent obviously but e.g. Qt library allows to design one UI for several OS. OTOH, Data layer can be OS dependent because it resides on some server and other app components must use defined interface (ODBC, OLE DB, etc.) to access the data by sending SQL commands to the interface and reading the response.

Business logic has its own rules and details depend on application architecture and complexity. It can be incorporated in the UI (for simple apps) or it can be a standalone DLL (OS dependent) with interface defined etc. It can also be implemented on the SQL server as a set of stored procedures etc.

Of course, languages integrating all necessary parts to develop an "application in a box" also exist. I have to mention Visual FoxPro which is unsupported already but many applications are still running.
0
dinomixCommented:
SQL server will be paired with ASP.NET and C# predominantly. Oracle DB is usually used with Java platform. PostgreSQL with Ruby on Rails and PHP/MySQL is common. That being said, you can mix pretty much any DB with any language and framework, depending on the project. Also, mixing is a lot more varied in open source software than a proprietary stack like Windows/SQL Server/C#, and Oracle/Java.

If you are running on windows and SQL server i would highly recommend you stick with C# as the interoperability and support/documentation for this ecosystem is plentiful, vs trying to run a PHP or Java as those are all written to work well together by Microsoft.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Languages-Other

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.