StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Yes, but no. I have not met a single line of Embedded SQL in my 10 years in the field. I would say (and hope) this technology only exists in (some) legacy systems.</p> <p>Nowadays, database related development in the industry would involve:</p> <ul> <li>Direct database access using JDBC, ADO .NET, OLE DB, ODBC or native libraries (<a href="http://www.oracle.com/technetwork/database/features/oci/index-090820.html" rel="nofollow">OCCI</a> in your case).</li> <li>Some sort of <a href="http://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow">ORM</a> (Hibernate, Entity Framework or a home made <em>solution</em>).</li> <li>Some sort of data access layer based on frameworks and/or patterns (think Ruby on Rails, <a href="http://martinfowler.com/eaaCatalog/activeRecord.html" rel="nofollow">Active Record</a> or a home made <em>solution</em>).</li> </ul> <p>IMHO, home made <em>solutions</em> should be eradicated but they are more common than you would think. Part of this would certainly have to do with students having only experimented with outdated and inadapted tools at school...</p> <p>ORM (and data access layers) related <a href="http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch" rel="nofollow">problems</a> can be very complex and I would say very interesting to have a look at. Especially if you are a student. I would recommend delving into <a href="http://martinfowler.com/books.html#eaa" rel="nofollow">Martin Fowler's P of EAA</a>.</p> <p>In C++, I would have a look at <a href="http://soci.sourceforge.net/" rel="nofollow">SOCI</a>.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload