| 15:14 | agronholm_ | second, you have to enable strict mode |
| third, make utf-8 the default encoding | ||
| fourth, enable the file-per-table innodb setting (or was it file per db?) | ||
| 15:15 | flinz | i don't have root access, so are these settings i can do myself? |
| 15:15 | agronholm_ | no, it requires root access |
| 15:15 | flinz | fuck |
| 15:15 | agronholm_ | well, you can still limp on with it by giving the mysql_engine=innodb option to each table |
| 15:17 | flinz | hm, seems like the socket isnt even installed |
| i have the bin.. but thats all | ||
| ah shit | ||
| 15:18 | flinz | i might have to workaround then |
| would this isolation level thing fix anything? | ||
| 15:19 | agronholm_ | nope |
| socket not installed? you can connect via tcp to localhost, can't you? | ||
| 15:21 | flinz | well, what i meant is |
| MySQL server through socket '/var/lib/mysql/mysql.sock' | ||
| can't conect to localMySQL server through socket '/var/lib/mysql/mysql.sock' | ||
| 15:21 | agronholm_ | that's what I meant too |
| so why not just connect through tcp | ||
| 15:23 | flinz | sorry.. i feel like a friggin newb here, but.. how? |
| 15:27 | agronholm_ | mysql://user:pass@localhost/somedb |
| 15:27 | Sonderblade | |
| 15:30 | csgeek | #sqlalchemy |
| 15:30 | flinz | sorry, i think they dont have the server running on the machine after all |
| netstat gives me no sockets | ||
| 15:32 | septomin | #sqlalchemy |
| 15:33 | batok | #sqlalchemy |
| 15:35 | agronholm_ | netstat -lpn? |
| 15:37 | flinz | netstat -ln | grep mysql |
| 15:37 | agronholm_ | if you're not root, you may not see all listening sockets |
| 15:37 | flinz | yep true |
| just on a sidenote | ||
| 15:38 | flinz | i have quite a lot of control over how many commits are made to the db |
| and they wont be many | ||
| so i think i'll try to workaround | ||
| this is a very restricted system | ||
| 15:38 | agronholm_ | you could serialize access to sqlite |
| it destroys concurrency but at least it'll work | ||
| 15:39 | flinz | i dont need ANY concurrency |
| i just enter simulation results into a db for easy retrieval AFTER the sim | ||
| 15:40 | flinz | ok.. |
| 15:40 | DanielHolth | I'm using ?timeout=10.0 (spelling?) for sqlite, so it will wait a little longer to get at the db |
| 15:40 | flinz | how do you set that? |
| 15:40 | DanielHolth | in the connection URI |
| 15:40 | btami | #sqlalchemy |
| 15:40 | agronholm_ | <flinz> i just started out with sqlalchemy and have a short question: I have several connections coming in to a sqlite db, and just got a '(OperationalError) database is locked' error.. i did a little bit of readup and it seems setting the isolation_level to IMMEDIATE would solve this.. |
| this indicated that you have some concurrency there | ||
| 15:41 | flinz | well, im writing into the same db, from different threads.. but i dont rely on the order of writing or such.. |
| 15:42 | DanielHolth | you might be keeping transactions open unnecessarily. you should commit immediately. |
| 15:42 | agronholm_ | why did you then say that you don't need any concurrency? |
| 15:42 | DanielHolth | you might set up a queue and a single writer thread, you would probably make sqlite much happier that way. |
| 15:42 | agronholm_ | that's what I meant too by serialization |
| 15:43 | flinz | ah i get it |
| i am indeed keeping transactinos open | ||
| 15:43 | percious | |
| 15:44 | martinknyc | #sqlalchemy |
| 15:45 | flinz | @agronholm i might have misunderstood the concept of cocurrency then |
| 15:46 | agronholm_ | concurrency = accessing the same resource from multiple threads simultaneously |
| 15:46 | flinz | i just thought as i do not read anything from the db, just pile in data results i get |
| it doesnt matter when they are entered into it | ||
| 15:47 | flinz | i.e. i could implement a queue by hand |
| it wouldnt mess with what i'm doing | ||
| 15:48 | agronholm_ | the best tool for that is the standard library Queue class |
| 15:48 | martinknyc | |
| 15:48 | agronholm_ | it was meant specifically for this |
| 15:48 | flinz | ok.. one last thing (got to head out) ... |
| 15:48 | martinknyc | #sqlalchemy |
| 15:49 | flinz | the threads are run on several different machines |
| 15:49 | agronholm_ | well ok not necessarily but it's well suited |
| 15:49 | flinz | that could be a problem |
| 15:49 | agronholm_ | so umm |
| you are trying to access a single sqlite file from multiple machines at the same time? | ||
| 15:49 | flinz | si. *g* |
| 15:50 | agronholm_ | ok sqlite is definitely ill suited for that |
| 15:50 | flinz | what youre trying to say is: no way |
| hehe | ||
| 15:50 | agronholm_ | you have to send the results from all the machines to a central control node that writes to the sqlite database |
| 15:51 | flinz | hm, right.. |
| 15:51 | agronholm_ | it'd be a lot easier to use a real database though... |
| 15:51 | flinz | i might be able to set up a db of my choice at home and then just connecting via net |
| 15:52 | agronholm_ | dunno about your circumstances, I just wonder how you ended up with a cluster you have no control over |
| 15:52 | flinz | im at a huge university |
| cluster | ||
| they do restrict a lot of the software available | ||
| 15:52 | agronholm_ | and that cluster has no relational database? |
| that's unbelievable | ||
| 15:52 | flinz | there should indeed |
| 15:53 | flinz | hm.. |
| 15:53 | agronholm_ | are you a post-grad student or something |
| 15:53 | flinz | yep |
| th.physics | ||
| i gotta run agronholm, thanks a lot for your help | ||
| 15:54 | flinz | ill be back these days |
| tell you what happened | ||
| afaik there is a sql and an oracle db set up somewhere in the same network.. | ||
| 15:54 | agronholm_ | sql? |
| 15:54 | flinz | i'll have to hit the sysadmins for access |
| mysql | ||
| 15:55 | agronholm_ | yeah that'd be easier |
| 15:56 | flinz | thanks a LOT for your time |
| i really appreciate it | ||
| 15:57 | percious | #sqlalchemy |
| 15:57 | empty | |
| 15:57 | flinz | |
| 15:57 | agronholm_ | np |
| 15:58 | agronholm_ | I'm writing my MSc here |
| 16:01 | Matjong1 | #sqlalchemy |
| 16:03 | westmaas | |
| 16:05 | Matjong | |
| 16:07 | empty | #sqlalchemy |
| empty | ||
| 16:12 | mrrech | #sqlalchemy |
| 16:12 | elemoine | |
| 16:18 | plaes | onox: /win 2 |
| duh.. | ||
| 16:20 | atomekk | |
| 16:23 | empty | #sqlalchemy |
| 16:23 | dialtone | |
| 16:26 | trw | #sqlalchemy |
| 16:28 | percious | |
| 16:30 | lelit | |
| 16:33 | mpederse` | #sqlalchemy |
| 16:34 | mpedersen | |
| 16:34 | atomekk | #sqlalchemy |
| 16:34 | westmaas | #sqlalchemy |
| 16:46 | bag | |
| 16:49 | tholo | |
| 16:52 | kral | |
| 16:52 | mvt | |
| 16:54 | empty | |
| 16:58 | mpederse` | #sqlalchemy |
| 16:59 | empty | #sqlalchemy |
| 17:00 | woodworks | #sqlalchemy |
| 17:03 | westmaas | |
| 17:04 | martinknyc | |
| 17:06 | thepix | |
| 17:08 | mrrech | |
| 17:10 | zvart | #sqlalchemy |
| 17:13 | nphilipp | |
| 17:14 | ToadP | |
| 17:14 | Thorn | #sqlalchemy |
| 17:16 | my_haz | how do i set the default charset and engine in mysql? |
| 17:17 | damag | #sqlalchemy |
| 17:18 | Shyde | #sqlalchemy |
| 17:18 | Kaelten | |
| 17:18 | gozerbot | SA: Ticket #1731 (bug in internal annotations of an "IN" clause, i.e. single table ...) closed - <http://www.sqlalchemy.org/trac/ticket/1731#comment:1> || Ticket #1731 (bug in internal annotations of an "IN" clause, i.e. single table ...) created - <http://www.sqlalchemy.org/trac/ticket/1731> |
| 17:19 | agronholm_ | my_haz, in the ini file in /etc/mysql |
| 17:19 | Kaelten | #sqlalchemy |
| Kaelten | ||
| Kaelten | #sqlalchemy | |
| 17:21 | jezier | #sqlalchemy |
| 17:21 | my_haz | agronholm_: thanks |
| 17:22 | EnTeQuAk | |
| 17:25 | lebouquetin | |
| 17:26 | empty | |
| 17:26 | EnTeQuAk | #sqlalchemy |
| 17:29 | damag | Hey I'm just learning SQLAlchemy, but does anyone else find it confusing that it mixes up relations with table relationships? |
| 17:30 | woodworks | |
| 17:30 | bag | #sqlalchemy |
| 17:31 | agronholm_ | what's the difference? |
| 17:32 | damag | In the relational model, a relation is nearly what most people would also call a table |
| 17:33 | agronholm_ | tables are tables, relations are relations |
| I don't know why you find that confusing | ||
| 17:33 | my_haz | damag: i thought a relation in relational model was a row (a relationship of columns) |
| 17:35 | damag | hmm don't believe so, you mean a specific tuple? |
| 17:36 | damag | either way it's generally assumed in most rdbms terminology that a relation is the collection of attributes that are related, i.e. a table. |
| 17:36 | koki_baretta | #sqlalchemy |
| 17:37 | damag | at least from how I had always learned and used that... it just seems weird to use that terminology for a table reference. |
| 17:40 | bja | |
| 17:41 | damag | Although most people stick to the table/column/row terminology rather than the relation/attribute/tuple one. But it still makes it confusing I think to introduce "relation" as something other than how the relational model defines it. |
| 17:41 | btami | #sqlalchemy |
| 17:42 | bja | #sqlalchemy |
| 17:43 | agronholm_ | they're object relations really |
| 17:44 | agronholm_ | as in Object Relational Mapping |
| 17:45 | tholo | #sqlalchemy |
| 17:46 | damag | Hmm ya I always thought orm was mapping objects to relations not object relations. :) |
| 17:50 | empty | #sqlalchemy |
| 17:53 | thepix | #sqlalchemy |
| 17:54 | damag | It's just a naming thing and in English relation and relationship are nearly synonymous, but I think for a tool that's meant for working with relational databases where a relation has a specific meaning, it's a bit confusing. |
| 17:55 | ToadP | #sqlalchemy |
| 17:57 | Matjong1 | |
| 17:57 | Shyde | |
| 17:58 | Matjong | #sqlalchemy |
| 17:59 | empty | |
| 18:00 | empty | #sqlalchemy |
| 18:04 | bja | |
| 18:07 | Matjong1 | #sqlalchemy |
| 18:09 | damag | |
| 18:11 | Matjong | |
| 18:26 | dialtone | #sqlalchemy |
| dialtone | #sqlalchemy | |
| 18:28 | Kzahel | some days sqlalchemy just hates me :( |
| 18:29 | THC4k | #sqlalchemy |
| 18:29 | Gedd | #sqlalchemy |
| 18:29 | THC4k | |
| 18:31 | Kzahel | but as it turns out i wasted the last 30 minutes chasing a problem caused by a stupid trivial mistake :) |
| 18:32 | tholo | Yay for wasting time? :-p |
| 18:35 | my_haz | Kzahel: thats a waste of wasted time, you should waste time reading coding blogs or playing flash games |
| or you know, chatting on irc | ||
| 18:37 | my_haz | in elixir if you inherit from a class that inherits from Entity, can you have the class that inherits from Enitity NOT create a table on metadata.setup_all() ? |
| 18:38 | westmaas | #sqlalchemy |
| 18:38 | my_haz | it seems like it would be autosetup, but thats deprecated |
| 18:38 | Kzahel | are coding blogs entertaining? |
| 18:39 | my_haz | Kzahel: sometimes, but mostly it just gives you illusion of not wasteing time, which is handy when wasting time |
| 18:40 | Kzahel | do you blog about your coding? |
| 18:40 | percious | #sqlalchemy |
| 18:42 | my_haz | writing in natural langue makes me want to cut myself |
| 18:43 | my_haz | Python == Fun, English != Fun |
| 18:43 | Kzahel | haha |
| yeah complete sentences with capitalization etc is hard | ||
| 18:44 | my_haz | yeah it makes no sense, all inconsistent, its like coding PHP |
| 18:45 | Matjong1 | |
| 18:46 | Matjong | #sqlalchemy |
| 18:56 | Kzahel | i wouldn't mind php if it had closures and scoping and list comprehensions and namespaces |
| 18:59 | inklesspen | and a sane syntax |
| 18:59 | ronny | php is the most impreessive collection of what you can do wrong in a programming language ever |
| 19:04 | nosk1o | #sqlalchemy |
| 19:05 | Gedd | my_haz: I think you are looking for abstract=True |
| 19:06 | THC4k | #sqlalchemy |
| 19:13 | aconrad_ | |
| 19:13 | THC4k | |
| 19:14 | my_haz | Gedd: using_options(abstract=True) ? |
| 19:21 | Gedd | yep |
| 19:24 | my_haz | hmm that seems to work, except for one class that gives me AttributeError: 'EntityDescriptor' object has no attribute 'builders' |
| 19:25 | my_haz | that abstract class has a "has_many()" relation, could that be messing things up? |
| 19:27 | my_haz | it also has a propert() but i don't know why that would mess thign up |
| *property() | ||
| 19:27 | Gedd | |
| 19:29 | empty | |
| 19:30 | empty | #sqlalchemy |
| 19:34 | koki_baretta | |
| 19:41 | lelit | #sqlalchemy |
| 19:43 | gbel | #sqlalchemy |
| 19:45 | TML | #sqlalchemy |
| 19:48 | gozerbot | SA: Ticket #1733 (identify possible cx_oracle issue oracle RETURNING with varchars) created - <http://www.sqlalchemy.org/trac/ticket/1733> || Ticket #1732 (detect column conflicts in declarative single table inh) created - <http://www.sqlalchemy.org/trac/ticket/1732> |
| 19:52 | percious | |
| 19:57 | Matjong | |
| 19:58 | percious | #sqlalchemy |
| 20:06 | lelit | |
| 20:13 | thepix | |
| 20:14 | iElectric | |
| 20:16 | agronholm_ | agronholm |
| 20:20 | Kzahel | if i am creating two tables that reference each other, do i have to create the tables without the foreign keys and then alter the tables to add the foreign keys after they're already created? |
| 20:22 | Thorn | |
| 20:34 | koki_baretta | #sqlalchemy |
| 20:44 | OramahMaalhur | #sqlalchemy |
| 20:54 | percious | |
| 20:59 | drobbins | |
| 21:09 | drobbins | #sqlalchemy |
| 21:18 | percious | #sqlalchemy |