logs archiveIRC Archive / Freenode / #emacs / 2015 / June / 30 / 1
ijp
so, suppose I want to read from a sqlite database from elisp. what are my options?
bremner
ijp: shell out to the sqlite3 binary?
ijp
sql-mode can probably be bent to my will, and I can use call-process, but anything better?
bremner
(Action) looks goatish
ijp
I see an edbi, but that has a perl dependency
avshalom
ijp: i've toyed with edbi... it's a little weird. i think its broken on emacs 25
also, sql-mode. there is a new mode called sql-indent which i've installed just today, hopefully that helps in the indentation department
edbi has a lot of cpan stuff
my best luck with emacs and sql has been to run it through R and print results in org-mode
ijp
that's not really an option
turbofail
i don't think you can do much better
than shelling out
there's no "protocol" to speak because there's no server
unless you want to write enough elisp to read sqlite3 files directly
benaiah
(Action) is seriously considering writing an editor
I think I might need to be stopped
         

turbofail
stahp
stoppage done, ,,next
fsbot
Another satisfied customer. NEXT!
benaiah
I finally got a chance to type on the Macbook. It pretty much convinced me to rule it out.
avshalom
yeah, those are some stiff chiclets.
hand-wreckers
benaiah
my fingertips would get sore on my old Air keyboard. I can't imagine how bad that one would get
turbofail
huh. i never had that problem
maybe i'm just used to bashing my fingers against things all the time
benaiah
turbofail: you probably don't type like a coked-up gorilla who's missing a couple fingers
avshalom
benaiah: i have an 11inch air -- forced me to start carrying an external keyboard
my 15-inch mac book pro is somewhat better
benaiah
avshalom: mine was a 13-inch, and I didn't have too much trouble with it. for coding the small screen was usually a bigger issue than the keyboard
I reeeeally want to back the keyboardio guys' model 01, but I promised myself I'd stop paying for things now that won't be delivered for two years
avshalom
that looks pretty cool
ijp
huh, firefox includes pocket now
turbofail
re: sqlite3 one step up from shelling out to the sqlite binary might be shelling out to some program that uses the client library and outputs s-expressions instead of whatever bullsh*t format the CLI client puts out
ijp
I was considering that
avshalom
benaiah: i've come to appreciate the Truly Ergonomic keyboard, with the tab, delete, and enter in the center
good for emacs web wowsing
benaiah
avshalom: that's another one that's high on my list. the model01's ability to split and change the angles of the keyboard is really attractive though
I should probably just get a TE now and then see if I want the model01 when I actually know what the real final product will look like
avshalom
yeah
benaiah
I should also learn to type properly on a regular keyboard
people who get wrist pain from typing: do wrist braces help much?
avshalom
my wrist pain used to come from a) splayed hands on regular keyboard and b) no wrist-rest
ijp
the pocket thing is kinda annoying since it's a third party service, not mozilla
avshalom
change to TE, and wrist problems went away
benaiah: now i have emacs pinky and fingertip sensitivity, but only when typing on laptop keyboard. again, problem solved on the TE.
         

benaiah
avshalom: that's good. my wrist pain started in college and always flares up in about a month-2 months whenever I start typing heavily
I know the ten-key+mouse makes it worse, since switching to an tenkeyless keyboard helped a bit previously
avshalom
,sauron
fsbot
sauron: a notification center for emacs. https://github.com/djcb/sauron
bananabas
hi guys
bit of a general question here
you know how to extract all the external links out of a wikipedia page?
elation
A single page?
ijp
if I remembered my xpath, it could probably be a one liner
well, except that html isn't generally xml
avshalom
i wonder if eww and/or w3m have ways to list links on a page
elation
lynx -dump -listonly $WIKISITE | grep -v "wikipedia.org"
I set WIKISITE to a wikipedia page first
ryouma
xml2
html2*
avshalom
elation: that's awesome
elation
It's ugly, its rough, but throw some sed in there and you got a solid parser... in fact I would use sed over grep if your making anything real anyway.
Gotta love lynx. When you don't need the ammount of power that scrapy or beautifulsoup gives you it is a beauty.
ryouma
benaiah: the same company is making a split keyboard? is it the kind where two halves are connected at the top?
benaiah
ryouma: not the same company as the TE, but here's pics/video: https://www.kickstarter.com/projects/keyboardio/the-model-01-an-heirloom-grade-keyboard-for-seriou
rudybot
http://teensy.info/RKKQjzppg6
ryouma
"heirloom grade"? is this, like, a grandfather clock with rhinestones in it?
benaiah
it's mounted in wood and split in two, so you can position and angle each side seperately
ryouma: it means "we bought some fancy looking wood"
despite the marketdroid speak, it does look like a fantastic keyboard
ryouma
do they serve it with broccoli florets?
they did not even bother to put modifiers on both sides
alt that is
i like the any key though
well, it is good to have people experimenting with new keyboards and getting into the business. as for me, however, i would be satisfied with a non-staggered, low-force, mechanical version of goldtouch with more splay.
(or kinesis, similar)
benaiah
ryouma: it's completely open, so I expect there will be plenty of alternate firmware if it gets any traction. there's plenty of keys, especially with the fn modifier
they're coming to portland to demonstrate it on the 11th. I might go check it out then
felipedvorak
Hi. I'm fairly new to Emacs and Org-mode is the thing that glued me to Emacs. I'm wondering if I can link between files, so I could have an index.org to organize all my other org files. Someone?
The only thing I found was this part of the documentation and, well, I couldn't understand http://orgmode.org/manual/Handling-links.html
elation
First: Here you go http://orgmode.org/guide/Hyperlinks.html#Hyperlinks
Second: You should head over to #org-mode (less activity, but a good place to double post because I lose questions on this thread).
gnudon
I need help with using emacs for searching the web
felipedvorak
elation: thanks!
elation
benaiah
ttfn, #emacs
ryouma
felipedvorak: just do, say, capture on a header and you will get the link. but it is better to use org-id and then get the link with store link. but it's even better to just use agenda to get an index of your files. done. there are no more levels.
felipedvorak
ryouma: I still don't know how to use agenda well. I've been mostly using it as an outliner :D thanks, I'll study this part
ryouma
felipedvorak: some people use org for a really long time before they start using agenda
felipedvorak
ryouma: My life is already dependant on it and I don't know how to use agenda hehehe
ryouma
bite off a small piece, master it. no need to swallow the whole thing at once.
ijp
I still mostly use org mode as an outliner, and I've been using it for 5 years
ryouma
felipedvorak: there is nothing wrong with using links. just use org-id links.
felipedvorak
thats something I must read about as well ryouma hehe
had never heard about it
gnudon
How do I use emacs for searching the web
duko
i'm using (shell-command (concat "tail -f " logfile "&") to tail a file using emacs
ryouma
gnudon: emacs-w3m, eww, url.el, other stuff
duko
but my emacs session has strange behaviour after I do that
felipedvorak
gnudon: I guess there is a surfraw emacs plugin that should do what you want
« prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 next »