2018 - September I Love Lucee

JoyMiller · September 3, 2018, 8:56pm

Seen something interesting in the Lucee or CFML community this month? Post it here!

As always I love Lucee is a quick review of Lucee and CFML happenings in general!

https://lucee.daemonite.io/t/2018-august-i-love-lucee/4255

JoyMiller · September 3, 2018, 8:57pm

“Query of Query” Sucks

Three reasons you shouldn’t use “Query of Queries”:

it is slow

it is slow, and;

it is slow

h/t @micstriit

github.com

lucee/Example-Code/blob/master/QueryOfQuery/example01.cfm

<cfscript>
max=1000;

persons=query(
	"lastname":["Lebowski","Lebowski","Lebowski","Sobchak"],
	"firstname":["Jeffrey","Bunny","Maude","Walter"]
	);


// Query of Query
start=getTickCount("micro");
loop times=max {
	query dbtype="query" name="qoq" {echo("
		select * from persons
		where lastname='Lebowski'
		and firstname='Bunny'
		order by lastname 
	");}
}
dump("Query of Query Execution Time:"&(getTickCount("micro")-start));

This file has been truncated. show original

modius · September 4, 2018, 7:47pm

H/t @Julian_Halliwell

modius · September 5, 2018, 7:00am

http://blog.rasia.io/blog/how-to-easily-setup-lucee-in-tomcat.html

h/t @isapir

PS. would be great to see this referenced or even copied into:

modius · September 8, 2018, 4:34am

4 posts were merged into an existing topic: Query of Query Sucks; upgrade hsqldb

modius · September 8, 2018, 4:42am

http://blog.rasia.io/blog/lucee-only-rational-choice-for-cfml-docker.html

h/t @Malcolm

modius · September 16, 2018, 12:34am

h/t https://twitter.com/brian_klaas

modius · September 18, 2018, 6:32am

h/t @elpete

modius · September 21, 2018, 1:25am

Using OSGI To Load A Conflicting Jar Into Lucee Server

The problem is if you have a jar file with some 3rd party library that you want to use in Lucee. Often times this works great, but other times the dependencies of that library may conflict with other jars already loaded into the classpath for Lucee, its bundled libs, or the servlet container.

h/t @bdw429s

PS. Didn’t know Lucee was OSGI? Well you might also like…
https://lucee.daemonite.io/t/osgi-lucee-s-white-whale-or-white-knight/2314