gitgood has quit [Remote host closed the connection]
random-nick has quit [Ping timeout: 252 seconds]
rumbler31 has quit [Remote host closed the connection]
rumbler31 has joined #lisp
slyrus has quit [Remote host closed the connection]
slyrus has joined #lisp
aartaka_d has quit [Read error: Connection reset by peer]
<fiddlerwoaroof>
kagevf: it would be sort of funny to build a workflow around parenscript and babel to avoid having to write Javascript directly
<fiddlerwoaroof>
parenscript to generate the JS, babel for round-tripping it back to parenscript and, maybe, for cleaning up identifiers
aartaka has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
<kagevf>
yeah, I'm not following at all how / why you would use parenscript on the server other than to generate JS as part of the output of a page so it can be used / run on the frontend
<fiddlerwoaroof>
You could always use node to run the generated javascript
CrazyPython has quit []
<fiddlerwoaroof>
But, I think "normally" you'd either compile to js files and serve them statically, or you'd compile to JS and serve it up with something like hunchentoot
<kagevf>
right ... that's what I've been doing ... the latter 2
<kagevf>
well, actually just the latter 1 ... serving from hunchentoot
slyrus has joined #lisp
skapate has quit [Remote host closed the connection]
slyrus has quit [Ping timeout: 252 seconds]
aartaka has quit [Ping timeout: 252 seconds]
mason has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
mmontone has joined #lisp
<Josh_2>
Currently I am representing lisp objects as javascript in my JS source code so that they can be referenced by other bits of JS code, no runtime overhead doing object lookups in js etc. Thanks jasom
Adamclisi has quit [Ping timeout: 252 seconds]
slyrus has joined #lisp
Josh_2 has quit [Ping timeout: 252 seconds]
Adamclisi has joined #lisp
aartaka has joined #lisp
slyrus has quit [Ping timeout: 246 seconds]
Jachy has joined #lisp
gzj has quit [Remote host closed the connection]
gzj has joined #lisp
gzj has quit [Remote host closed the connection]
gzj has joined #lisp
keja_ has quit [Read error: Connection reset by peer]
gzj has quit [Read error: Connection reset by peer]
gzj has joined #lisp
CrashTestDummy2 has joined #lisp
CrashTestDummy has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
gzj has quit [Remote host closed the connection]
gzj has joined #lisp
curtosis[away] has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
curtosis[away] has quit [Quit: My Mac Mini has gone to sleep. ZZZzzz…]
Kundry_Wag has joined #lisp
Sheilong has quit []
karlosz has joined #lisp
Kundry_Wag has quit [Ping timeout: 240 seconds]
Alfr is now known as Guest44451
Alfr has joined #lisp
slyrus has joined #lisp
<beach>
Good morning everyone!
Guest44451 has quit [Ping timeout: 250 seconds]
slyrus has quit [Ping timeout: 265 seconds]
akoana has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
slyrus has joined #lisp
slyrus has quit [Ping timeout: 268 seconds]
Kundry_Wag has joined #lisp
terpri has quit [Quit: Leaving]
Kundry_Wag has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
semz has quit [Ping timeout: 276 seconds]
msk has quit [Quit: Leaving]
akoana has quit [Quit: leaving]
semz has joined #lisp
semz has joined #lisp
semz has quit [Changing host]
zaquest has quit [Quit: Leaving]
rumbler31 has quit [Remote host closed the connection]
rumbler31 has joined #lisp
zaquest has joined #lisp
hypercube has quit [Ping timeout: 240 seconds]
Kundry_Wag has joined #lisp
Kundry_Wag has quit [Ping timeout: 260 seconds]
aeth has quit [Ping timeout: 252 seconds]
aeth has joined #lisp
waleee-cl has quit [Quit: Connection closed for inactivity]
hiredman has quit [Remote host closed the connection]
gzj has quit [Ping timeout: 252 seconds]
varjag has joined #lisp
slyrus has quit [Remote host closed the connection]
slyrus has joined #lisp
varjag has quit [Ping timeout: 252 seconds]
slyrus has quit [Ping timeout: 252 seconds]
pagnol has joined #lisp
Bike has quit [Quit: Lost terminal]
gzj has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
Sauvin has joined #lisp
rixard has quit [Read error: Connection reset by peer]
rixard has joined #lisp
Spawns_Carpeting has quit [Quit: ZNC 1.7.2+deb3 - https://znc.in]
Spawns_Carpeting has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 260 seconds]
slyrus has joined #lisp
mmontone has quit [Ping timeout: 240 seconds]
slyrus has quit [Ping timeout: 240 seconds]
daphnis has joined #lisp
Kundry_Wag has joined #lisp
aartaka has quit [Ping timeout: 246 seconds]
hiredman has joined #lisp
daphnis has quit [Ping timeout: 240 seconds]
Kundry_Wag has quit [Ping timeout: 246 seconds]
daphnis has joined #lisp
imode has quit [Ping timeout: 240 seconds]
orivej has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
gaqwas has joined #lisp
gaqwas has joined #lisp
gaqwas has quit [Changing host]
attila_lendvai_ has joined #lisp
shka_ has joined #lisp
gzj has quit [Remote host closed the connection]
gzj has joined #lisp
andrei-n has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 246 seconds]
pagnol has quit [Ping timeout: 246 seconds]
mindCrime has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
supercoven has joined #lisp
supercoven has quit [Max SendQ exceeded]
supercoven has joined #lisp
OlCe has joined #lisp
long4mud has joined #lisp
mindCrime has joined #lisp
slyrus has quit [Ping timeout: 260 seconds]
phoe6245 has quit [Quit: Ping timeout (120 seconds)]
phoe6245 has joined #lisp
attila_lendvai_ is now known as attila_lendvai
attila_lendvai has quit [Changing host]
attila_lendvai has joined #lisp
rjcks has joined #lisp
Lord_of_Life has quit [Excess Flood]
Lord_of_Life has joined #lisp
mindCrime has quit [Ping timeout: 240 seconds]
hiroaki_ has joined #lisp
mindCrime has joined #lisp
gzj has quit [Remote host closed the connection]
gzj has joined #lisp
varjag has joined #lisp
slyrus has joined #lisp
gitgood has joined #lisp
<shka_>
hello!
<shka_>
i am getting the following warning from the quicklisp
<shka_>
contains definition for system "cl-ppcre-test". Please only define "cl-ppcre" and secondary systems with a name starting with "cl-ppcre/" (e.g. "cl-ppcre/test") in that file
<shka_>
can I please have an example of the properly defined tests subsystem?
slyrus has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
hendursa1 has joined #lisp
slyrus_ has joined #lisp
OlCe has quit [Ping timeout: 260 seconds]
hendursaga has quit [Ping timeout: 240 seconds]
slyrus has quit [Ping timeout: 252 seconds]
slyrus_ has quit [Ping timeout: 252 seconds]
anticrisis has quit [Read error: Connection reset by peer]
lotuseater has joined #lisp
aartaka has joined #lisp
Kundry_Wag has joined #lisp
Kundry_Wag has quit [Ping timeout: 240 seconds]
datajerk has quit [Ping timeout: 265 seconds]
datajerk has joined #lisp
mindCrime has quit [Ping timeout: 240 seconds]
gzj has quit [Remote host closed the connection]
pve has joined #lisp
<kagevf>
I get that warning too when I asdf:load-system something that uses that library
slyrus has joined #lisp
gzj has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
mindCrime has joined #lisp
<splittist>
That's an asdf warning. At some point it became fussy about, as it says, defsystems in the same file. So you would define (defsystem #:trivial-example (...)) and (defsystem #:trivial-example/tests (...)) But perhaps you meant something else.
aartaka has quit [Ping timeout: 252 seconds]
mindCrime has quit [Ping timeout: 265 seconds]
aartaka has joined #lisp
<shka_>
splittist: i think that i meant this
<shka_>
i thought that this is quicklisp thing, not the asdf
<shka_>
but ok, thanks for the explanation!
slyrus has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
gzj has quit [Ping timeout: 240 seconds]
slyrus has quit [Ping timeout: 240 seconds]
aartaka has quit [Read error: Connection reset by peer]
surabax has joined #lisp
slyrus has joined #lisp
Necktwi has quit [Read error: Connection reset by peer]
<kagevf>
it looks like the way to parameterize queries is to have $1 $2 etc in the sql ...
<CL-ASHOK>
kagevf I did, but it's hard to follow "This is the macro-style variant of prepare. It is like prepare, but gives the function a name which now becomes a top-level function for the prepared statement. The name should not a string but may be quoted."
<CL-ASHOK>
Does something like this: (doquery (:select 'x 'y :from 'some-imaginary-table) (x y)
<CL-ASHOK>
(format t "On this row, x = ~A and y = ~A.~%" x y))
<kagevf>
CL-ASHOK: there are a few examples using the argument placeholders like $1 ... maybe enough to figure out how to apply to your code ...
<CL-ASHOK>
quote the parameters so that it avoids sql injection?
<kagevf>
CL-ASHOK: that doquery in your example you just wrote doesn't have any parameters, so no danger of sql injection there
<kagevf>
can you paste the example from your code that uses parameters?
<kagevf>
also, in that document try searching for "$1" to see all the examples where it uses argument placeholders to get more ideas
<CL-ASHOK>
(defun insert-record (title body)
<CL-ASHOK>
(query (format nil "INSERT INTO myBlogTable VALUES ('~A', '~A');" title body)))
<CL-ASHOK>
thanks, I will search for $1 in the doc now
<kagevf>
ok cool ...
<kagevf>
what if you did something like ...
<kagevf>
(query "INSERT INTO myBlogTable VALUES ($1, $2);" title body)
<CL-ASHOK>
will that prevent sql injection for title and body?
<kagevf>
yes
<CL-ASHOK>
wow - such an easy fix - thank you!
<kagevf>
that's how you parameterize a sql query
<kagevf>
anyway .... try and test it first before thanking me ... I've never used postmodern, but that's how it works with other sql libs
<kagevf>
to test it, you can try injecting commands to make sure like making body be set to "'some text'); select 'test' --" (maybe get a better example online, but that's the basic idea)
<CL-ASHOK>
Thanks
Inline has quit [Read error: Connection reset by peer]
<kagevf>
liked your article btw, keep up the good work CL-ASHOK :)
slyrus has joined #lisp
<CL-ASHOK>
Thanks @kagevf :)
Inline has joined #lisp
cosimone has quit [Remote host closed the connection]
daphnis has joined #lisp
<shka_>
phoe: well, it's ok, i can mock
<shka_>
so that's fine
slyrus has quit [Ping timeout: 240 seconds]
Inline has quit [Ping timeout: 260 seconds]
Oladon has quit [Quit: Leaving.]
<CL-ASHOK>
@kagevf - working now:) Ended up with this: (postmodern:query "SELECT * from function_table where fid = $1;" fid)
<CL-ASHOK>
without parametrisation, I was able to successfully inject SQL
<CL-ASHOK>
now it throughs an error
<CL-ASHOK>
throws*
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
Inline has joined #lisp
slyrus has joined #lisp
aeth has quit [Ping timeout: 252 seconds]
aeth has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
mindCrime has joined #lisp
orivej has quit [Ping timeout: 240 seconds]
eden has quit [Quit: Leaving]
orivej has joined #lisp
CL-ASHOK has quit [Quit: Connection closed]
slyrus has joined #lisp
gumman has quit [Read error: Connection reset by peer]
slyrus has quit [Ping timeout: 252 seconds]
gumman has joined #lisp
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
slyrus has joined #lisp
imode has joined #lisp
slyrus has quit [Ping timeout: 240 seconds]
cosimone has joined #lisp
<splittist>
signals a condition
<lotuseater>
has anyone good experiences with LTK for writing a gui application?
Inline has quit [Quit: Leaving]
slyrus has joined #lisp
andrei-n has quit [Quit: Leaving]
slyrus has quit [Ping timeout: 252 seconds]
<edgar-rft>
lotuseater: depends on how complex the GUI is, for simple GUIs upto to semi-complex it's pretty easy to use
<edgar-rft>
The main performanc bottleneck is the stream between CL and Tk, if you need to transfer lots of data back and forth between CL and TK the GUI becomes rather sluggish, but I think that's the case with *all* GUIs
CL-ASHOK has joined #lisp
<lotuseater>
edgar-rft: a friend of mine asked me to write him a simple gui with some data handling for his work that should run on windows
<lotuseater>
but I'm not much experienced with gui stuff, just McCLIM yet a bit
<lotuseater>
i tried the examples, but got a message "couldn't find wish file"
aartaka has quit [Read error: Connection reset by peer]
aartaka_d has joined #lisp
slyrus has joined #lisp
CL-ASHOK has quit [Quit: Ping timeout (120 seconds)]
slyrus has quit [Ping timeout: 240 seconds]
bitmapper has quit [Quit: Connection closed for inactivity]
Gromboli has joined #lisp
kevingal has joined #lisp
mathrick has quit [Ping timeout: 252 seconds]
cage_ has quit [Quit: Leaving]
mathrick has joined #lisp
aartaka has joined #lisp
cosimone has quit [Remote host closed the connection]
aartaka_d has quit [Ping timeout: 240 seconds]
rjcks_ has joined #lisp
Inline has joined #lisp
rjcks has quit [Ping timeout: 265 seconds]
charles` has quit [Ping timeout: 258 seconds]
slyrus has joined #lisp
slyrus has quit [Ping timeout: 260 seconds]
Lord_of_Life_ has joined #lisp
Lord_of_Life has quit [Ping timeout: 252 seconds]
Lord_of_Life_ is now known as Lord_of_Life
slyrus has joined #lisp
edgar-rft has quit [Quit: Leaving]
slyrus has quit [Ping timeout: 240 seconds]
sz0 has joined #lisp
charles` has joined #lisp
aartaka_d has joined #lisp
mindCrime has quit [Ping timeout: 240 seconds]
aartaka has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
Noisytoot has joined #lisp
dyelar has quit [Quit: Leaving.]
slyrus has quit [Ping timeout: 260 seconds]
<kagevf>
@CL-ASHOK - nice!!
slyrus has joined #lisp
charles` has quit [Quit: Leaving.]
gaqwas has quit [Ping timeout: 260 seconds]
slyrus has quit [Ping timeout: 265 seconds]
shka_ has quit [Ping timeout: 240 seconds]
Nilby has joined #lisp
Lycurgus has joined #lisp
anticrisis has joined #lisp
mindCrime has joined #lisp
slyrus has joined #lisp
<jcowan>
IMO "?" is neither necessary nor sufficient in a reasonable programming language
daphnis has quit [Ping timeout: 240 seconds]
slyrus has quit [Ping timeout: 240 seconds]
<Lycurgus>
is the notion of controlled natural language as a programming language also inacceptable?
<jcowan>
Functions that correctly convert a native string to a properly quoted and escaped SQL string prevent SQL injection attacks, and with (concatenate "SELECT" (column-names c1 c2 c3) "FROM" (table-names t1 t2)) you can execute a dynamic query safely.
<jcowan>
so column-names and table-names quote names correctly (double quotes), add commas between arguments, etc.
<Lycurgus>
you know in these times it's generally all dynamic queries. I doubt the random programmer even knows the distinction between static and dynamic sql
<jcowan>
By dynamic I mean you can dynamically choose the tables to query and the results to return.
<jcowan>
hyper-dynamic if you will.
<Lycurgus>
by dynamic i mean the access plan is compiled at run time
<Lycurgus>
yeah I call that a query facility or whatever, not even programming as such
<Lycurgus>
a user (possibly a technical one) interface to a relational store
<Lycurgus>
by the time a user is there, using one they are trusted
<Lycurgus>
not as much as at a general db controlling interface, but a trusted user anyway
<Lycurgus>
rather than somebody attempting sql injection over a web interfaces
GFP2242 has joined #lisp
ebrasca has quit [Remote host closed the connection]
slyrus has joined #lisp
slyrus has quit [Ping timeout: 252 seconds]
surabax has quit [Quit: Leaving]
slyrus has joined #lisp
mrspec has quit [Ping timeout: 268 seconds]
antoszka has quit [Ping timeout: 246 seconds]
Lycurgus has quit [Quit: Exeunt]
mrspec has joined #lisp
mrspec is now known as Guest92373
antoszka has joined #lisp
aartaka_d has quit [Ping timeout: 252 seconds]
slyrus has quit [Ping timeout: 268 seconds]
GFP2242 has quit [Quit: Leaving]
pve has quit [Quit: leaving]
DHARMAKAYA has joined #lisp
hiroaki_ has quit [Ping timeout: 260 seconds]
kevingal has quit [Remote host closed the connection]
kevingal has joined #lisp
slyrus has joined #lisp
rjcks_ has quit [Quit: leaving]
sz0 has quit [Quit: Connection closed for inactivity]
frgo has quit [Remote host closed the connection]
slyrus has quit [Ping timeout: 240 seconds]
frgo has joined #lisp
countvajhula has joined #lisp
thinkpad has quit [Ping timeout: 240 seconds]
thinkpad has joined #lisp
Guest92373 has quit [Ping timeout: 252 seconds]
mrSpec has joined #lisp
mrSpec is now known as Guest72871
slyrus has joined #lisp
akoana has joined #lisp
Guest72871 has quit [Ping timeout: 240 seconds]
Krystof has quit [Ping timeout: 246 seconds]
antoszka has quit [Ping timeout: 245 seconds]
mrSpec` has joined #lisp
slyrus has quit [Read error: Connection reset by peer]
slyrus has joined #lisp
DHARMAKAYA has quit [Quit: Turning off a portion of this simulation.]
antoszka has joined #lisp
slyrus has quit [Ping timeout: 265 seconds]
antoszka has quit [Ping timeout: 248 seconds]
X-Scale` has joined #lisp
orivej has quit [Ping timeout: 240 seconds]
X-Scale has quit [Ping timeout: 252 seconds]
X-Scale` is now known as X-Scale
antoszka has joined #lisp
supercoven has quit [Read error: Connection reset by peer]
slyrus has joined #lisp
varjag has quit [Ping timeout: 252 seconds]
srhm has quit [Ping timeout: 252 seconds]
slyrus has quit [Ping timeout: 240 seconds]
slyrus has joined #lisp
karlosz has quit [Quit: karlosz]
srhm has joined #lisp
srhm has quit [Client Quit]
slyrus has quit [Ping timeout: 268 seconds]
antoszka has quit [Ping timeout: 260 seconds]
slyrus has joined #lisp
antoszka has joined #lisp
sjl has quit [Quit: WeeChat 2.2-dev]
kevingal has quit [Remote host closed the connection]