Home
David Corking's Library tagged → View Popular
Domain Logic and SQL - Martin Fowler 2003
SQL is a powerful declarative language for describing data. Martin Fowler argues that it has its place in modern systems, and is not just an interface layer to the well-tested and optimised b-tree (for example) persistent storage layer provided by the database vendor.
-
powerful SQL queries often embed domain logic, which
goes against the basic principles of a layered enterprise application
architecture. -
Add Sticky NoteConcentrate instead on essence of the
approach: read in all the data you have to consider, then loop through
and select what you need.- Has he done SQL's job for it deliberately to make this solution ugly?
If you skipped SQL and used Gemstone or conversely Berkely DB, would it look quite so ugly? - on 2009-06-19
- Has he done SQL's job for it deliberately to make this solution ugly?
- 3 more annotations...
Dont Repeat Yourself - C2 wiki
object-relational mapping
-
Add Sticky Note
Meta's comment about databases reminds me of the fact that the schema of the database and the code that access the database are two representations of data structures. Ideally, both the code and the database schema would be driven off the same source of data structure information.
This is the attraction of Ruby's ActiveRecord and the reason I hate Hiberate and Struts. Both Hiberate and Struts have duplicate information that needs to be in sync. Without something like XDoclet they will get out of sync and will violate DRY. SaS- Interesting comment about object-relational mapping. - on 2009-06-19
Thinking Small: Bootstrapping a startup with Smalltalk - James Robertson 2006
How Avi Bryant and Andrew Catton got the skills, the resources, the buzz and the code to launch DabbleDB.
-
Add Sticky NoteAvi: You would go through a lot of pain to get something far less flexible in Rails (never mind static languages). Using an RDBMS on the back end would be a boat anchor ([ed - for example - Salesforce.com does a fraction of this kind of thing, and likely at a much larger effort on their part]).
- Avi's view on the flexibility of Seaside - on 2009-06-19
Object Vs Model - David Barbour 2006
This is quite an interesting short essay, though I am quite puzzled what the author is getting at in the last couple of paragraphs: he says that he "wish(es) to maintain virtualization"
-
Data Hiding simply doesn't make sense with regards to a reflective system where the data must regularly be updated by observers of reality (i.e. by one or more actors) and where the data inherently comes from the outside.
This is, perhaps, one source of ObjectRelationalImpedenceMismatch?. Relational is designed for modeling data that came from an outside world whilst object-oriented is designed to... well... create and manipulate objects -
Add Sticky NoteYou can make them work together until you try to add virtualization - abstract objects for which the associated data isn't known.
- However this sentence is completely opaque to me. - on 2009-06-11
wikidbase - Google Video - 2007
The sound goes way out of sync here, and Blundell says "relation" when he means "relationship between tables", but having said that, it is quite intriguing, and a faster way of building up a database than any I have seen.
Openstructure: A Call for Open Source Reform
A brilliant paper with several challenging soundbites. However the restructuring it proposes is radical and I am not yet convinced.
-
...if IT managers admitted one dirty little secret: it is very hard to understand technology! That is why the industry is so rife with buzzwords...the marketing departments have got you. No matter how objective you think you are, you will inevitably find yourself choosing a brand name....after the decades of waste in IT it is time for a new level of accountability...I believe they could demand a greater accountability and openness from the industry. And there is no better way to be "open", than to avoid the kind of marketing double-talk that you find on the websites of most of the companies I have discussed.
DBMS2 — DataBase Management System Services»Blog Archive » The Great MapReduce Debate
a lot of hot air about an important technical topic
-
His point is that a more general parallel database system can choose among many patterns, of which Map/Reduce is only one example, and therefore can be a good solution for a wider range of problems.
ArsDigita Server Architecture
Interesting package of engineering and management advice
-
What if a disk drive fills up? Are we notified in advance? Are we notified when it happens? How long does it take to restore service?
That's what's this document is about.
MySQL Performance Blog » Why MySQL could be slow with large tables ?
Worth a read later, I think
-
Avoid joins to large tables Joining of large data sets using nested loops is very expensive.
Slashdot | MySQL Stored Procedure Programming
thorough book review
-
Creating some simple stored procedures, and calling them from some PHP and Perl scripts, demonstrated to me that MySQL Stored Procedure Programming contains more than enough coverage of the topics to be an invaluable guide in developing the most common functionality that a programmer would need to implement. ...Steven Feuerstein is the author of several well-regarded books on Oracle, and it was nice to see him poke some fun at the database heavyweight, in his choice of sample code to demonstrate the my_replace() function: my_replace( 'We love the Oracle server', 'Oracle', 'MySQL').
MySQL Stored Procedures: Part 1
A quick article to get started with this new feature
-
MySQL 5.0 finally introduces functionality for Stored Procedures. So what exactly are stored procedures? That is the kind of question that gets database professionals who use other DBMS's raising their eyebrows. Stored procedures have been integral to Oracle, PostgreSQL, DB-2, MS-SQL server and others for years, and it has long been a sore point that MySQL has not had them. ...
A stored procedure is simply a procedure that is stored on the database server.
Secrets of lightweight development success, Part 6: Persistence strategies
Some interesting lessons about persistence even if you are not using Java
-
You don't have to automatically reach for EJB or Hibernate the next time you're doing an enterprise solution that requires persistence. You have a number of approaches. If there's any question, try the solutions that you like with something nontrivial.
Smallthought » Blog Archive » You Can’t Import Usability
What is amazing about this post is that Avi (of Seaside fame) went out and built, with Andrew Catton, the application that he dreamed of in this post.
-
Personally, I would rather that the database system made it easy enough to build my application from scratch that I didn’t feel a need to use the spreadsheet as a crutch.
Smallthought » Blog Archive » Which Incremental Paths?
Andrew Catton looks at incremental development - and in particular - incrementally developing a data management application. He doesn't forget that the data becomes part of the application - it is not just code and a schema. By the way, incremental dev
-
Will people want to look at this data in multiple ways? Strictly speaking, it is largely an affirmative answer to this last question that begs structure, but increased numbers of people looking at data over an increased period of time tend to make the desire for multiple views more likely....Maybe you need structure, but that doesn’t mean you need to go off and do a requirements analysis and build a complete schema. If the system allows you to simply add a few useful slots for your data, stick some data in them, and repeat as necessary, you can get both the benefits of structure and incrementality.
SQLzoo: Tutorial Six - SELF JOIN
Great SQL quiz with a live database to practise on. Some quite advanced queries such as these subsidiary self-joins
-
SELECT a.company, a.num, stopa.name, stopb.name
FROM route a JOIN route b ON
(a.company=b.company AND a.num=b.num)
JOIN stops stopa ON (a.stop=stopa.id)
JOIN stops stopb ON (b.stop=stopb.id)
WHERE stopa.name='Fairmilehead' and stopb.name='Tollcross'
PHP Database Related A Contact Database using MySQL and PHP Tutorial
alternative workarounds for AUTOINCREMENT
-
"INSERT INTO contact VALUES (SELECT( max(uid) +1 FROM contact..." . The problem is that this requires the subselect or subquery facility, which is not supported by MySQL. Another approach would be to lock the contact table, select the maximum uid plus one, insert your new contact, and then unlock the contact table
FirstSQL/J faq
autoincrement workaround - it is handy if the last key generated is persistent.
-
CREATE TABLE surrogate_key (table_name VARCHAR(128) PRIMARY KEY, id INT)
There is row for each table requiring an auto-increment key. A new number is assigned by incrementing the id under transaction control.
Ada programming language - Wikipedia, the free encyclopedia
-
#
# PL/SQL - Stored procedure language in Oracle Corporation's RDBMS product, has many similarities to Ada and was historically based on Ada syntax
Selected Tags
Related Tags
Sponsored Links
Top Contributors
Groups interested in SQL
Diigo is about better ways to research, share and collaborate on information. Learn more »
Join Diigo