Posts

mysql - Its possible to generate a SQL Database from a JSON file? -

well have database in json format, generated exel file, want modernize database , export mysql database. json structure: [ { "nombre": "test", "especialidad": "test", "especialidad2": "test pediatrica", "especialidad3": "", "cel": "2222009374947478474777", etc..... }, { "nombre": "test", etc..... } ] if not possible or difficult, better option directly export exel file mysql? thanks. with mysql: have convert csv, use excel write sql, or write import procedure. mariadb skip entirely , use json column format: https://mariadb.com/kb/en/mariadb/column_json/ upgrading mysql mariadb easy , quick. gets little bit of performance increase + nice json column format (and few more).

c# - What could cause a 401 error in a git pull (via libgit2sharp)? -

this pull wrapper works on local network: internal mergestatus pull() { using (var repo = new repository(repositoryroot)) { var merger = new signature(username,emailaddress,datetimeoffset.utcnow); var options =new pulloptions { fetchoptions = new fetchoptions() { credentialsprovider = credentialshandler } }; mergeresult result = repo.network.pull(merger, options); return result.status; } } the following shows credentialshandler using along commented-out attempt use usernamepasswordcredentials gave me same result. public libgit2sharp.handlers.credentialshandler credentialshandler { { if (credentialshandler_ == null) { credentialshandler_ = (_url, _user, _cred) => new defaultcredentials(); //this not fix 401 error on jupiter box //credentialshandler_ = (_url, _user, _cred) => new usernamep...

vb.net - Opening a second-form more than once error -

Image
i have button in form1 opens form2. using frm2.show() . works totally fine first time open frm2, when close frm2 , click on button in frm1 open frm2 again, error: can tell me how solve it? edit: have module have database connection , declaration forms: public frmgame new game public frmplay new play public frmfinish new gamefinish public frmlogin new login public frmmanage new manage public frminsert new toevoegen where open form when click on button in form1. sounds me close()ing frm2. closing form should dispose , release resources, can't show() again. instead, need create new instance of object, this: frm2=new form2() frm2.show() if doesn't work (perhaps because don't want re-initialize form's data members), use hide(), rather close() temporarily hide form during program's execution. if need prevent form being closed x button, can few different methods: the best way go may hide or disable close button. read on this post better ide...

jquery - Manage tiny fonts visualization with CSS/Javascript in Firefox -

Image
i trying create website in navigation based on zoomable contents. for instance, here screenshot of can see after opening webpage: then, using zoom.js "zooming" page , able read text. however, after magnification got this: the font-size set 9.4%, , can see causes characters overlapped , not correctly positioned. i tried use jquery plugin fittext.js or jquery textfill , see if changed font-size in "magic" way solve issue; unfortunately had effect in solving visualization issue. so question is: how can make font looking "normal"? there jquery plugin or other js library manage problem? i using firefox, , prefer focus on using browser moment. as suggested nico o , ed plunkett in comments, solution problem start big page, in 20 times bigger desired page size. added following css scale 20 times smaller: body { transform: scale(0.05); transform-origin: 0 0; } when need zoom on point, add new transformation parameters in...

MySQL Fabric failover and Connection Pooling with Hibernate -

i'm attempting implement automatic failover via mysql fabric server group using jndi resource, hibernate, , connection pooling. our db farm setup mysql fabric , i'm attempting implement client/connector. i have jndi resource declared in server.xml file has mysql fabric-based url , driver, , uses connection pooling hibernate. <resource name="jdbc/myapp" type="javax.sql.datasource" driverclassname="com.mysql.fabric.jdbc.fabricmysqldriver" maxwait="1000" url="proper.fabric.url/fabricservergroup=myfabricgroup" maxactive="45" validationquery="select 1 dual" /> the problem i'm having connection pooling , fabric not play together. after taking down master db, fabric automatically promotes slave expected. however, when attempt make new connection db i'm getting old now-defunct connections back, notably i'm getting read-only connection when i'm requesting readwrite. additional info i...

ruby - task in Capistrano 3 cannot find RVM -

i have been using capistrano 3 deploy php app several months , works great. recently, decided start using sass stylesheets , trying deploy these changes. i trying write task runs after rest of deploy stuff finished converts scss file css using sass gem. namespace :deploy after :finished, :assets on roles(:app), in: :sequence, wait: 5 within release_path # process sass files css execute "sass #{release_path}/styles/test.scss #{release_path}/styles/test.css" end end end end i using rvm on server , have sass gem installed in specific gemset. there .rvmrc file in project root loads correct gemset when cd 'current' directory capistrano creates. when deploy, fails on new task saying cannot find sass. stderr: bash: sass: command not found i can log server same user used deploy capistrano , cd 'current' directory , run same command in task (substituting #{release_path} actual path) , works fine. things have t...

apiary.io - Apiary Proxy Request Timed Out -

i'm trying use apiary document api , test requests keep getting response 504 proxy request timed out. api running on machine under http://localhost:3000/ , specified under host metadata. when click compare under call, shows apiary added header "host" specifies user specific proxy. there missing or apiary not localhosts? because proxy remotely calls specified host, cannot directly call localhost. could use https://ngrok.com , set tunnel , use tunnel url host.