Aleternatvie

i'm trying learn mariadb (v5.2.4), i'm running issues. can download , install it, doesn't seem running or i'm missing something. i'm looking resource 1st timer running on windows. a few specific questions: does require mysql run? alot of installation out there seems geared around upgrading mysql, want start fresh. is there management tool database (like sql server management studio)? if not, people typically use? you not need mysql run mariadb. once you've installed mariadb should able type net start mysql at command prompt , start mariadb (yes type mysql) to answer second part of question, know company called navicat used offer administrative gui, can't seem find on site anymore.

i have python 2.6.6 , python 3.1.3 installed on machine (windows vista 64 bit) path variable includes directory of both versions. how can specify python want run program in. instance, if want run program in python 3, works if want run different program in python2 syntax error. how can run python 2 program in cmd? typing python in command line, python 3.1.3 1 shows up. you can specify version in executable name python2.6 , python3 .

i using rails 2.3.4 i looking less specific answer question, more general guidance in matter. in our (mysql) database, encrypt identifiable information (pii), such name, address, phone number, etc. requests dynamic queries time. for example, "can query db me entry values given date, users in list of area codes". so, selection criteria include of pii encrypted data, such area code of phone number. for discussion, user , entry tables have following fields of interest: user.id,user.phone entry.user_id,entry.value,entry.created_at because of encryption, can't connect sql client , query "easy" way entries on 11/21/2010 users in list of area codes (555,222,333), this: select e.value,substr(u.phone,2,3) users u inner join entries e on e.user_id = u.id date(e.sent_at) = '2010-11-21' , substr(u.phone,2,3) in ('555','222','333') i'd in console query might give me similar data. it appears encrypted f...

the code i'm using below doesn't seem find file want, can help? nsstring *path = [[nsbundle mainbundle] pathforresource:@"itunes music library" oftype:@".xml" indirectory:@"~/music/itunes/"]; nslog(@"%@", path); thanks, sami. this looking inside bundle, /applications/my app.app/contents/resources/~/music/itunes (if "~" there legal). you're not looking bundle resource here. why making call find path of file know path to?

i'm working saxparser parse xml. problem is, have few screens or activities coded. @ moment, every time transition new activity button press example, new activity needs parse xml on again, can populate screen specific content. is there way in parse xml once through life of program? thank you. sure, parse once , store want remember in variables. more completely, create class (or classes) classes represent properties same information in xml document. constructor of class take xml argument, parse it, , populate properties. hope helps.

does know how can find out text background color (rgb) of pdf file? thank you! there no background. pdf print media oriented, , background white. object (drawing, image etc.) beyond text , makes "background". have detect object , color of (this can not easy too, due different color spaces).

what best practice manage user permissions php/mysql? what have column in users table called 'permissions', string compared pages. if($_session['permissions'] == 'administrator' || $_session['permissions'] == 'moderator'){ // stuff } i'm sure there better way accomplished in simpler, easier way. recommendations? how managing 'mysql' permissions? mean controlling actions in website capable of performing database actions, or you're literally needing database access rights management? if via web, incorporate zend framework's acl if you're looking in depth, or other existing permissions system built in php.