Phillip,
I find Datomic very interesting as a database. It is fundamentally
different than relational databases in that the base unit of data isn’t a
table row, but a datom, which is defined as a tuple of entity, attribute,
value and transaction. Null values aren’t stored - they simply don’t exist.
Datoms are not overwritten when values change. Instead the old value is
“retracted” and the new value added. Thus you automatically have a complete
history of all data modifications that have occurred. Datomic uses Datalog
instead of SQL, so there is really something to sink your teeth into if you
want to be confused for awhile!
Aria Media Sagl
Via Rompada 40
6987 Caslano
Switzerland
+41 (0)91 600 9601
+41 (0)76 303 4477 cell
skype: ariamediaOn Wed, Jun 17, 2015 at 5:43 PM, Jon Clausen <@Jon_Clausen> wrote:
I know, Igal…
On June 17, 2015 at 11:39:44 AM, Igal @ Lucee.org (@Igal) wrote:
It’s still SELECT * FROM Table1
yes, we realize that
we’re referring to the boilerplate code that is required in order to
connect to the database, and possibly to iterate over the returned record
setIgal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/
On 6/17/2015 8:33 AM, Jon Clausen wrote:Phillip,
It’s still SELECT * FROM Table1, but in Coldfusion the datasource
connection is configured at the server leve, and the methods are native. In
NodeJS, for example, you need to add the library to connect to the specific
database type. Example for MySQL:npm install node-mysql
Then:
//You can always scope this part globally in your application, but this is the connection config.
var mysql = require(‘mysql’);
var db = mysql.createConnection({
host : ‘localhost’,
user : ‘root’,
password : ‘’,
database : ‘my_database’
});db.connect();
db.query(‘SELECT * from Table1’, function(err, rows, fields) {
//if no error, do stuff with your query result rows
if (!err){
for(var i in rows){
console.log(rows[i]);
}
} else {
throw err;
};
});
connection.end();It’s a different approach. PHP is the same way, but the connectivity
modules are installed explicitly when installing the PHP packages (In PHP
5.6+, on many Linux distress, they’ve stopped including MySQL by default).
It’s one of the ways in which CFML is a more integrated and mature
language, as database connectivity is assumed at the application server
level.Update: I saw Mark posted pretty much the same thing when I was typing
this so apologies for some duplication.On June 17, 2015 at 11:18:17 AM, Phillip Senn (@Phillip_Senn) wrote:
That’s funny Adam.
I guess that’s why I’ve never bothered to post it as a question on
stackoverflow.
Afraid of getting downvoted like so many of my questions do.
But I know the people in the cf community are a kinder, gentler people.Seriously, how do you SELECT * FROM Table1 using any other web authoring
programming language?
I looked at node.js for a little while but couldn’t understand how to do
the same thing that cfquery does.And I don’t think I want to jump from ColdFusion to php.
From the outside looking in, it looks like php is just another scripting
language so why not stick with the one that I already know?If anything, moving from cfquery to using stored procedures has moved most
of my logic out of ColdFusion, so if I ever do decide to transition, there
will certainly be less to do than there was a year ago.On Tue, Jun 16, 2015 at 4:52 PM, Adam Cameron <@Adam_Cameron> wrote:
On 16 June 2015 at 21:48, Phillip Senn <@Phillip_Senn> wrote:
OK, let me ask a stupid question but has been bugging me for a very long
time:I’d focus less on this question and put effort into working out how to
use google.–
AdamYou received this message because you are subscribed to a topic in the
Google Groups “Lucee” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/lucee/0uQmQPOTYpA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAOPrabUFrhPEuObz_%2B%2BQBBRe_bcWUuY1qX0WD27Xs4%2Bjc%2BVUrQ%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CAOPrabUFrhPEuObz_%2B%2BQBBRe_bcWUuY1qX0WD27Xs4%2Bjc%2BVUrQ%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CANWT4JMUTi%3DvrdB99gzbTCXGnYvA9sgKz-DZyTyg45Mtim55qw%40mail.gmail.com
https://groups.google.com/d/msgid/lucee/CANWT4JMUTi%3DvrdB99gzbTCXGnYvA9sgKz-DZyTyg45Mtim55qw%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/etPan.5581933b.671bf557.54c6%40jonclausen-mbp.local
https://groups.google.com/d/msgid/lucee/etPan.5581933b.671bf557.54c6%40jonclausen-mbp.local?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/55819490.70100%40lucee.org
https://groups.google.com/d/msgid/lucee/55819490.70100%40lucee.org?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/etPan.558195ae.1f1f057c.54c6%40jonclausen-mbp.local
https://groups.google.com/d/msgid/lucee/etPan.558195ae.1f1f057c.54c6%40jonclausen-mbp.local?utm_medium=email&utm_source=footer
.For more options, visit https://groups.google.com/d/optout.