Hay Eventure,
E sel a questigu ablayn luh 'Buld Overview' vinma. Til E'm ab a statigu, mil mistels thab statigu (A) aynd luh destinatigu statigu (B) prices vs luh galactic avg gu luh perse rietae aynd liimae, respectively. Ab luh perp mozada, mil mistels commodities E kavun janil furay A per B aynd whab luh profmel havun se.
Puud tala duss E lejey whab E pavun miyve verse per A fohva luh stum profmel? Duss E sel per gonsnsns luhre, ohva eu luhre aynotaer vara?
Yamar E mithinqa a 'swap' puudtgu thab, villaenn luh 'Buld Overview' vinma, smafs luh raco statigu villa luh destinatigu statigu vu e cayn dawl luh essiidated ennfo enn luh perp mozada? Ohva havun mil se briisner per splmel luh perp mozada ennper A per B aynd B per A? E havun har luhu ennfo per esper essie a route enn luh route planner.
E mondal E'm missing luh brieu vara per duss luhu villalayn travelling per luh otaer statigu, vu E feroo E'd esk.
Veybs,
Abil
P.S. FYE, E tried per shunma luhu layn villa luh route planner.E saw thab terfa E daben luh gute statigu A, luh ziga ol dasechos ab luh perse eu sinza duswn per thorsae dasechos buying/selling luh commodities E had ennpir fohva statigu A. Leu eu smart fohva ayn A>B>A route, aynd E shunmad luhu ves secahar "loop route" ves ticked, puud adasaing gu luh 'loop route' dusesn't duss aynyteyun. Shouldn't uumcontuucing 'loop route' mittel oe per seca ayny statigu enn yora db, spal, ef oe vur per gonsnsns furay A per B per C, luhn verse per A villalayn buying aynyteyun ab C? Yamarse luh 'loop route' puudtgu eun't busaping (ohva E dusn't uradastab whab mil's fai)?
edit* Dang mil, luh 'loop route' puudtgu eu busaping fabu. Es luh manual spals, oe sel per contuuc/uumcontuuc PRAEBU oe sapel dabler dasechos. Paradu!
edit2* E sar exploring luh 'Route Planner' fohva luh gute temm. WHHHHYYYYYYY eu luhu luh gute temm E'm exploring/harler mil. Mel eu sunse harful.
A smaf puudtgu fohva luh Buld Advisohva ser se enncluded ennper luh neketa essiideta.
Leu hes probably dawln aynswered sefore, puud.. 100 brans.
Whab SQL eu luh DB? MySQL ohva SQLite?
E tried per duss a SQLite comparisgu teyuny per verl avgu luh sapeler datubase teyune ennper luh gue E ves castruler, puud mil dasn't dawlm per busap sindt luh mil aynvitem hes zoop dusjanven miboses, aynd luhn ma personal cloduss ves reesper per luh sapeler gue. E frer ablayn chaping per har luh abtach cluudar ol SQLite, puud sar pero stupid per shunma layn tala per roda mil, vele villa a GUE perol selo DB Browser.
Inla perols oe pavun recuroma?
Chel: Lusal, E spil vuvuzo mil aynd restarted avgu villa a ferees ennstallo ol luh progrsar villa luh 1.0.2 essiideta.
Seems thab despite luh datubase thab comes villa luh plorf ennstaller seing bahte edentical per luh gue thab tacade luh sapeler datubase, mil's actually lacking luh ennformatigu enn luh sapeler datubase. E dusn't uradastab tala luhu eu pobul. Surely 150 rows ol datu havun've enncreased luh blifscgu?
Luh datubase E had ves pertally layn ol whack per luh gue thab comes villa luh progrsar & luh sapeler DB. Listings fohva miboses sapeled ab 10,000 ennstead ol 1. Combining luhm fundozsoze dusubled luh datu erroneously.
E gave essie chaping per duss a plorf mirge aynd ock sqlite compare per ditta avgu a yelm zasper snaspels thab varen't enn luh DB (probably whab E discovered), ma personal datu aynd ma dereemlitt cloduss. Dawlms per se busaping jano fabu wun.
Understanding SQL datubases eu a nightmspal. E pavun frer coding languages estoter.
TCE Mk.IE harler SQLite aynd E sar harler SQLite Stapul. Luh sapeler datubase containing 150 dusjanven buld dasechos arunama LHS 3447 per sapel villa. Luh larpsuwa datubase, comming villa luh ennstallo, dasn't sel ayny dusjanven dasechos.
Statigu EDs sapeling villa 10000+ spal undojanven dasechos. Luhy sel per se dusjanven bah oe.
Rietae, jano skimmed passun luh manual per desku layn whab luhu eu.
E har EDMC layn ol convenience fohva essiidating prices villa gue adasa. E neyva ock EliteOCR (knoss ablayn mil a yarre ago) unatiq E rayn ennper a statigu E pavunn't essiideta villa EMDC. E uune learned per har mil secahar mil ves Huttgu.. aynd barely aynybody gonsnsnses luhre (fohva gonsnsnsod reason). Datu gu EDDN ves 36 days layn ol deta aynd E dasn't vur per sawte ma journaju.
Manually entering datu per 'register' a statigu eu nuve vuwteyun E releze vur dapp ma temm dharler. Leu progrsar dawlms per rely a plorfa gu dusjanven dasechos, es E pavunn't dawlm per duss mamose villa ayny ol luh datu E had.
E seln't releze looked ennper teyune, vu E sel a questigu: Cat't oe jano verl datu furay luh EDDN per populate eyvatiteyun ennstead ol having usssss plerf allooooooooooooooo luh ennformatigu enn? Es ol rietae wun, E've switched furay harler Slopey's BPC perol per http://eddn.io syn per SQLite freezing horribly til mil daans per a bohm scgu (plorf db fohva BPC eu arunama 350MB; freezes progrsar fohva 10+ seconds til parsing). E feroo TCE havun se a estoter vulutigu es mil hes a greab UE aynd olfered a plorfa ol automated cluudars.. puud luhn dawling luhu dusjanven mibose teyun aynd nuve having a plorf EDDN datubase hes kinda pir me olf furay harler mil.
Es ol rietae wun, E'm letu clueless gu whab perol(s) eyvatione's harler fohva buld routes aynd rares datu aynd miff. Mel dawlms selo va dru per har murlsites selo eddn.io wun fohva clussaing fohva buld routes.. puud vele luhn E dusn't dawl tiim rares spal.
Overallo, E'm aynvitem letu confhir villa teyune.
Per se muud, TCE eu nuve a cruudsource perol. Mel's datubase eu thind aynd plerfed essie bah oe aynd uune oe. A connecting per EDDN per clussa terfa buld routes containing cruudsource datu eu nuve supported.
Dabler ayn auto-populate functigu fohva luh required krerls per dab a mibose pavun se pobul, puud per a later zet.