| Time |
Nick |
Message |
| 00:00 |
jberger |
ah, relative files |
| 00:00 |
Grinnz_ |
also, sqlite:///foo is technically relative, but there was a bug in URI::db with that form so I didn't include it |
| 00:00 |
Grinnz_ |
you can just use sqlite:foo anyway |
| 00:01 |
jberger |
actually it looks like Mojo::URL DTRT when not using // |
| 00:01 |
jberger |
perl -Mojo -E 'say Mojo::URL->new("file:my/path")->path' |
| 00:01 |
Grinnz_ |
yes, it should |
| 00:02 |
Grinnz_ |
but you're assuming already starting with a file: URL |
| 00:02 |
jberger |
it does the same thing with 'sqlite:' |
| 00:03 |
Grinnz_ |
with sqlite: everything would probably just work with Mojo::URL, but I didn't start with that scheme |
| 00:03 |
Grinnz_ |
also I like the abstraction of URI::db |
| 00:04 |
jberger |
thats fine |
| 00:04 |
jberger |
as I said I was just curious |
| 00:04 |
jberger |
happened to notice it |
| 00:04 |
jberger |
I have a work side-project that is likely to use SQLite |
| 00:04 |
jberger |
so I'm just brushing up |
| 00:04 |
bpmedley |
jberger: Have you used SQLite much? |
| 00:04 |
Grinnz_ |
https://metacpan.org/source/DBOOK/Mojo-SQLite-0.021/lib/Mojo/SQLite.pm#L72 one nice thing is it lets me canonicalize schemes like sqlite3: |
| 00:04 |
Grinnz_ |
automaticlaly |
| 00:05 |
jberger |
hmmm, is sqlite3 new/old/default? |
| 00:05 |
jberger |
what should I be using? |
| 00:05 |
jberger |
bpmedley: not really |
| 00:05 |
Grinnz_ |
3 is the current version |
| 00:05 |
jberger |
I usually have used DBM::Deep when I need a file-backed system |
| 00:06 |
Grinnz_ |
but I don't know if it's common to use that scheme for URIs |
| 00:06 |
jberger |
but this project is likely to need some querying that is more than would be pleasant with DBM::Deep |
| 00:06 |
bpmedley |
I think you will love the simple and elegant way it approaches SQL for an embeddable database. |
| 00:06 |
jberger |
I'm getting pretty fond of Postgres so I'm worried about missing features |
| 00:06 |
Grinnz_ |
SQLite is definitely a new way of thinking in some cases, in that columns are really typeless |
| 00:06 |
jberger |
but we'll see |
| 00:06 |
Grinnz_ |
or "suggested" |
| 00:07 |
Grinnz_ |
the docs are nice in some cases, lacking in others... |
| 00:07 |
jberger |
http://howfuckedismydatabase.com/sqlite/ |
| 00:07 |
Grinnz_ |
heh |
| 00:08 |
jberger |
actually it is seeing things like this that scare me (and yes this has made it to the real world, I've seen it): http://stackoverflow.com/a/26241151/468327 |
| 00:09 |
Grinnz_ |
where mysql tacks on random keywords to add features, sqlite makes abominations of perfectly sensible constructions |
| 00:09 |
jberger |
it was funny, I saw that type of query and after figuring out what it did I googled "sqlite generate sequence of numbers" and that is the first hit |
| 00:09 |
jberger |
clearly the author did the same thing |
| 00:09 |
Grinnz_ |
hehe |
| 00:41 |
vicash |
sqlite is great if your data is going to stay < 2GB... |
| 00:41 |
vicash |
sqlite is also great if you want to use in-memory databases and use sqlite's :memory: feature |
| 00:42 |
Grinnz |
as long as you don't fork :) |
| 00:43 |
vicash |
yes of course... i use it mostly in C/C++ world for quick solutions or use in phone apps |
| 00:58 |
jberger |
hmmm so I'm reading about sqlite and I see there is a magical rowid column |
| 00:58 |
vicash |
it is kind of like the oid column in postgres |
| 00:59 |
jberger |
should I use that rather than making my own ids or should I do as normal and create an INTEGER PRIMARY KEY column |
| 00:59 |
vicash |
if you want autoincrementing you need to create a primary key i think |
| 00:59 |
jberger |
I've never used the oid column in postgres |
| 00:59 |
jberger |
ok, best to stick with the standard usage |
| 00:59 |
vicash |
yes you never know when you want to migrate the sqlite into a server based db and best to stick to normal practice |
| 01:00 |
Grinnz |
In SQLite, a column with type INTEGER PRIMARY KEY is an alias for the ROWID (except in WITHOUT ROWID tables) which is always a 64-bit signed integer. |
| 01:01 |
Grinnz |
you can mostly count on that behavior. just don't ever do the "WITHOUT ROWID" thing. that's what I've gathered |
| 01:01 |
vicash |
Grinnz is right because somewhere in the docs it says that sqlite uses the rowid/primary key for automatic indexing |
| 01:01 |
Grinnz |
http://sqlite.org/autoinc.html |
| 01:01 |
Grinnz |
lots more details there |
| 01:11 |
jberger |
thanks |
| 01:46 |
|
Vitrifur joined #mojo |
| 02:10 |
|
noganex_ joined #mojo |
| 02:16 |
jberger |
INSERT ... ON CONFLICT in sqlite |
| 02:16 |
jberger |
has anyone else tried this? |
| 02:18 |
jberger |
oh nevermind, it is spelled INSERT OR IGNORE rather than INSERT ... ON CONFLICT IGNORE even though the feature is called ON CONFLICT |
| 02:18 |
jberger |
sigh |
| 02:39 |
|
leoj joined #mojo |
| 02:52 |
Grinnz |
"or the INSERT and UPDATE commands, the keywords "ON CONFLICT" are replaced by "OR" so that the syntax reads more naturally." |
| 02:52 |
Grinnz |
For* |
| 02:52 |
Grinnz |
look on the bright side, it's better than mysql's unreadable "INSERT IGNORE" |
| 02:55 |
nicomen |
win 31 |
| 02:55 |
nicomen |
oops |
| 02:59 |
|
disputin joined #mojo |
| 03:18 |
|
disputin joined #mojo |
| 03:30 |
|
ivi joined #mojo |
| 04:18 |
|
che-quest joined #mojo |
| 05:19 |
cpan_mojo |
Mojo-Weixin-1.1.5 by SJDY https://metacpan.org/release/SJDY/Mojo-Weixin-1.1.5 |
| 05:34 |
cpan_mojo |
Mojo-Webqq-1.8.2 by SJDY https://metacpan.org/release/SJDY/Mojo-Webqq-1.8.2 |
| 05:46 |
jberger |
Grinnz: that's true (re mysql) and yes that document about ON CONFLICT is how I figured it out |
| 05:46 |
jberger |
But gah! Give **A** usage example here and there and I wouldn't misunderstand simple things like that |
| 05:47 |
jberger |
Especially when the grammar diagram is right there at the top (and doesn't include OR) |
| 05:50 |
Grinnz |
well, to be fair, the INSERT page has the correct grammar diagram :P |
| 06:02 |
|
inokenty-w joined #mojo |
| 06:10 |
|
ivi joined #mojo |
| 06:15 |
|
ivi joined #mojo |
| 06:51 |
|
inokenty joined #mojo |
| 06:58 |
|
trone joined #mojo |
| 07:00 |
|
dod joined #mojo |
| 07:05 |
|
dod joined #mojo |
| 07:06 |
* sri |
yawns |
| 07:06 |
|
Vandal joined #mojo |
| 07:07 |
sri |
apple is taking its time to actually give me the refund :S |
| 07:08 |
|
AndrewIsh joined #mojo |
| 07:25 |
|
orev joined #mojo |
| 07:51 |
sri |
discovered something disappointing about dell too, you can only order windows laptops with the german keyboard from germany |
| 08:11 |
|
val40 joined #mojo |
| 08:16 |
nic |
I don't know when it started, but we have the equivalent now in the UK |
| 08:17 |
nic |
retailers used to be able to do good deals with grey imports, but the keyboard was always US |
| 08:17 |
nic |
now those deals are only via shady retailers. The 'reputable' ones are restricted to UK layout |
| 08:25 |
|
osfabibisi joined #mojo |
| 08:27 |
|
icjs joined #mojo |
| 08:33 |
|
leoj joined #mojo |
| 08:59 |
|
kes joined #mojo |
| 10:00 |
|
che-quest joined #mojo |
| 10:14 |
|
meshl joined #mojo |
| 10:22 |
|
leoj joined #mojo |
| 10:23 |
|
meshl joined #mojo |
| 10:34 |
|
kaare joined #mojo |
| 11:04 |
|
tchaves joined #mojo |
| 11:05 |
|
tchaves joined #mojo |
| 12:15 |
|
val40 joined #mojo |
| 12:22 |
|
zivester joined #mojo |
| 12:25 |
|
cuechan joined #mojo |
| 12:49 |
|
gizmomathboy joined #mojo |
| 13:02 |
|
ramortegui joined #mojo |
| 13:09 |
sri |
allright, macbook pro ordered, fingers crossed |
| 13:10 |
sri |
feels odd to order a broadwell laptop in 2016, but i really don't want another mac with the new keyboard |
| 13:18 |
bpmedley |
Did you get the 13"? |
| 13:22 |
sri |
yea |
| 13:22 |
sri |
the 15" is still haswell :o |
| 13:23 |
sri |
curious how apple is pretty much the only one putting 28w cpus in laptops |
| 13:33 |
|
cuechan joined #mojo |
| 13:56 |
|
ramortegui joined #mojo |
| 13:56 |
nic |
If you call $ua->build_tx, do you need to handle redirects yourself? |
| 13:56 |
sri |
no |
| 13:57 |
nic |
ta. I'll do some debugging then |
| 13:57 |
nic |
I've got max_redirects => 3 so I must be doing something bizarre |
| 14:00 |
|
leoj joined #mojo |
| 14:07 |
nic |
the test dir didn't have IO::Socket::SSL avail, so was ending on the transition redirect |
| 14:18 |
|
mrEriksson joined #mojo |
| 14:20 |
|
zivester joined #mojo |
| 14:31 |
|
ptolemarch joined #mojo |
| 14:35 |
|
disputin joined #mojo |
| 14:45 |
|
punter joined #mojo |
| 14:57 |
|
asarch joined #mojo |
| 15:09 |
|
leoj joined #mojo |
| 15:12 |
|
mcsnolte joined #mojo |
| 15:14 |
|
lluad joined #mojo |
| 15:26 |
|
dotan joined #mojo |
| 15:47 |
|
cuechan joined #mojo |
| 15:48 |
|
bwf joined #mojo |
| 15:57 |
|
disputin joined #mojo |
| 16:06 |
|
PryMar56 joined #mojo |
| 16:22 |
|
cuechan joined #mojo |
| 17:29 |
|
Bean joined #mojo |
| 17:29 |
jberger |
sri: re mojo pg #22 iirc the last thing that happened was that you were trying to decide the best course of action |
| 17:30 |
jberger |
If closing it means that you don't have any thoughts then can I at already request a clear cache method? |
| 17:31 |
jberger |
Grrr s/at already/at least/ |
| 17:31 |
|
val40 joined #mojo |
| 17:52 |
|
dod joined #mojo |
| 17:59 |
sri |
jberger: didn't like any of the proposals... and when avkhozov started to propose changes with serious performance penalties i thought it would be best to end it |
| 18:00 |
sri |
jberger: as it stands, doubt i would agree with a clear cache method |
| 18:01 |
sri |
i'm ok with the status quo |
| 18:01 |
sri |
so, any proposal for change would have to be really strong |
| 18:10 |
sri |
not even Mojo::UserAgent has a reset cache method |
| 18:20 |
jberger |
but Mojo::UserAgent doesn't have any settings that would affect connections in this way |
| 18:21 |
sri |
sure it does |
| 18:21 |
sri |
proxy |
| 18:21 |
jberger |
hmmm, I suppose |
| 18:21 |
jberger |
so the advice is "set the search_path immediately, just as you would set a proxy" |
| 18:23 |
jberger |
anyway one thing came of this discussion |
| 18:24 |
jberger |
the reason I was having troubles is that I was dropping the test schema before setting the search path because I assumed it would yell at you if you tried to drop your current schema |
| 18:24 |
jberger |
but it doesn't |
| 18:24 |
sri |
of course i'm in a very conservative mood right now... not being able to hack myself ;p |
| 18:24 |
jberger |
(like dropping the existing database isn't allowed) |
| 18:24 |
jberger |
yeah that sucks |
| 18:24 |
sri |
maybe bring it up again in a few weeks |
| 18:24 |
jberger |
k |
| 18:25 |
jberger |
I'm doing my 50/50% vacation anyway |
| 18:25 |
jberger |
I did work full days Mon-Weds |
| 18:25 |
sri |
(not saying my opinion will change though) |
| 18:26 |
jberger |
today I'm probably only going to do a half day, then long hawaiian weekend |
| 18:26 |
sri |
that's a strange vacation |
| 18:26 |
jberger |
its a very long one (by US standards) |
| 18:26 |
jberger |
I don't have this much vacation time |
| 18:28 |
|
itaipu joined #mojo |
| 18:28 |
sri |
props to servercentral, few employers are that flexible |
| 18:38 |
sri |
the cinematography of the last two game of thrones episodes was really something else |
| 18:38 |
jberger |
yeah they were really good |
| 18:39 |
jberger |
it was a point of discussion on the WhatTheFlick recap about the style of the opening of the last episode, getting ready for the "trial" |
| 18:40 |
jberger |
I'm a big cinematography nut though so I noticed before that |
| 18:44 |
jberger |
and yes, I do really like my employer |
| 18:55 |
sri |
i mean, that was way ahead of any other tv show |
| 18:57 |
|
marty joined #mojo |
| 19:02 |
|
dod joined #mojo |
| 19:07 |
|
itaipu joined #mojo |
| 19:14 |
|
val40 joined #mojo |
| 19:19 |
|
marty joined #mojo |
| 19:51 |
|
marty joined #mojo |
| 20:47 |
|
disputin joined #mojo |
| 21:19 |
|
disputin joined #mojo |
| 21:46 |
cpan_mojo |
Mojo-JSON-MaybeXS-0.012 by DBOOK https://metacpan.org/release/DBOOK/Mojo-JSON-MaybeXS-0.012 |
| 21:57 |
jberger |
West Wing had a few nice shots but of course that's a very different type of show |
| 21:57 |
jberger |
Mostly for great cinematography you have to go to movies |
| 21:57 |
jberger |
But that seems to be coming to the small screen slowly |
| 21:58 |
jberger |
There used to be stigma that tv couldn't be high quality |
| 21:58 |
jberger |
In all facets |
| 21:58 |
jberger |
A list movie stars wouldn't do TV until very recently |
| 22:12 |
|
val40 joined #mojo |
| 22:19 |
|
meshl joined #mojo |
| 22:44 |
|
leoj joined #mojo |
| 22:55 |
|
Vitrifur joined #mojo |
| 22:58 |
sri |
hmm, the rails 5 announcement on HN is full of "we've moved to elixir and phoenix" :o |
| 23:10 |
|
leoj joined #mojo |
| 23:16 |
|
meshl joined #mojo |
| 23:24 |
|
tchaves joined #mojo |
| 23:45 |
jberger |
Sucks to be the old hotness |
| 23:51 |
|
zivester joined #mojo |
