PostgreSQL, PowerShell and Software Development
PostgreSQL is something else. It's enjoyable, I'm not worried about licensing, and I find everything about PGSQL 16 to be pretty easy to learn, given my background. Their documentation is stellar, and specific questions I might have typically have a presence on the web (usually in a Stack Exchange site).
Over the past few weeks, I migrated a bunch of data from JSON and CSV files I was manipulating via ConvertFrom cmdlets in PowerShell. Moving the data was no problem. PG's COPY command is useful and so is pgAdmin 4. UTF8 versus Windows 1252 text encoding for CLI work was annoying, but only a minor delay. Adapting some of the programmatic features from PowerShell, such as regex replacements, proved more arduous but nothing was spectacularly difficult.
To render some of the data (more than 30,000 rows) into readable text, I made a PS script that rendered the SQL that then rendered single-column CSV results I could then finalize. For that finalization, I ran WSL2 dos2unix and a few sed commands. It was vastly easier to do that than to operate purely in PowerShell or PostgreSQL.
In BeyondCompare 4, I was able to see that my previous text results matched what I was getting from PowerShell, and as a bonus, PG did it in 25% of the time (4 times faster).
My efforts have been lovely exercises in finding and using resources while also finding and NOT utilizing resources. Each step has taken effort and involved a lot of small proof-of-concept and pseudo code before actual development or processing. PowerShell's Select-Object has become my favorite tool to limit data for testing. The smallest effective step is almost always the best step. It's a software development and/or engineering version of Occam's razor.
My next steps are up in the air somewhat. I have an idea of what I want to do with my data and content, but making it happen means thinking about it until the right path reveals itself. This part is most Zen and a bunch of RTFM.
Chances are good that I'll end up with an Express.js app, some client rendering framework (e.g. Angular), and a number of stored procedures or functions in PGSQL that do what I want. Chances are also good that I'm going to index what I'm working against in such a way that text replacement can be as fast as Big-O log(n). That's the goal, operatively, but the real goal is to master what I want to know of Postgres and to expand my knowledge of Node.js and client-side JavaScript (or ECMA).
0 notes
π πππππ-πππππ
Escape the ordinary. Elevate your stay, create memories beyond compare at Hotel Royal Inn.
Visit us : π SCO 180, Sec 17 Huda, Near Usha Rathi Hospital, Jagadhri
More Info Call us : π 96711-23410,Β 70151-29378
#hotelroyalinn #luxurystay #unforgettablememories #escapetheordinary #indulgeinluxury #luxuryhotel #hotellife #luxurytravel #travelgoals #wanderlust #staycation #vacationvibes #α΄Κα΄α΄ α΄ΚΙ’Κα΄α΄ #exploremore #memorablemoments #luxuryliving #travelinstyle #elevateyourstay #beyondcompare #travelinspiration #luxuryaccommodation
1 note
Β·
View note
Congratulations, interns!
shardesword β Blade
nyawanderer β Wanderer
SchwizSatoru β Furina
slasrh β Stelle
DompetKaveh β Lyney
abmateur β Screwllum
sweetcaeke β Ruan Mei
Iotossomno β March 7th
fayahwoku β Yoimiya
Kogareshi β Cyno
woypaket β Thoma
pigxtail β Black Swan
omniavitta β Fu Xuan
beyondcompares β Marius von Hagen
LouvreHannah β Childe
bcebies β Undecided
inhumane333 β Dan Heng
CH1SORIA β Robin
fuubutsus β Kaedehara Kazuha
sbqnwd0qb5oe5 β Ganyu
iktoshirin β Kamisato Ayato
cherrystmast β Aether
icythaticy β Silver Wolf
mzanchae β Bennett
Mirtyhs β Chongyun
nilotpaia β Tighnari
KuiHANJIN β Caelus
dunkifn β Aventurine
4685km β Diluc Ragnvindr
kakavazha β Huohuo
VIPFuXuann β Sparkle
kabukirono β Pompom
VIPAstaa β Albedo
SeiMafuyu β Cryo abyss mage
Menuasa β Clara
likewwwise β Collei
MSNAiku β Kaeya Alberich
CELESTIALESE β Lumine
deliveryscribe β Alhaitham
nousbless β Dr. Ratio
WistfulDdablue β Shikanoin Heizou
RS004DUT β Arataki Itto
0 notes
ITβS JUST BLACK AND WHITE - Some names need no introduction. To anyone who ever genuinely considered acquiring a luxury super yacht, hearing the name βRoyal Huismanβ as the builder of those finest and most distinctive yachts in the regatta or marina will be a familiar experience.
.
When admiring the build quality and attention to design detail on a particular yacht, the reply from her owner or crew βItβs a Royal Huisman!β is virtually regarded as self-explanatory. Royal Huisman yachts are deemed unique in conception, quality and execution. Yachts that are rare, beyond compare.
.
Discover about the exclusivity, quality and individuality at www.RoyalHuisman.com
.
ROYAL HUISMAN - THE SPIRIT OF INDIVIDUALITY
.
Photos of PHI, Aquarius, Sea Eagle II and Ngoni by Tom van Ooossanen, Michael Kurtz / Panteanius and Breedmedia #BlackAndWhite #NoIntroduction #Finest #MostDistinctive #SelfExplanatory #AttentionToDetail #RareSuperyachts #BeyondCompare #RoyalHuisman
5 notes
Β·
View notes
hereβs a complete list of what the dykwya website will give out (notably, theΒ βyou are busy on december 12β² is no longer there):
"A Legend", "A Beautiful Soul", "A Bit Needy But It's Okay", "A Bright and Shining Star", "A Sweet Creature", "A Unicorn", "A Whole Snack", "A Work in Progress", "Ace", "Adored", "Adventurous", "Alright", "Ambitious", "Amusing", "Awesome", "BeyondCompare", "Boisterous", "Bold", "Brave", "Bright", "Brilliant", "Charming", "Cheeky", "Compassionate", "Considerate", "Courageous", "Courteous", "Creative", "Curious", "Dependable", "Determined", "Different", "Empathetic", "Enough", "Enthusiastic", "Exceptional", "Extra", "Extraordinary", "Fantastic", "Fearless", "Figuring It Out", "Free", "Friendly", "Funny", "Generous", "Giving", "Hardworking", "Helpful", "Honest", "Humorous", "Important", "Impressively Loud", "Incredible", "Independent", "Inspirational", "Intellectual", "Intelligent", "Intuitive", "Inventive", "Loved By Your Mother", "Lovely", "Loving", "Loyal", "Marvelous", "Memorable", "Needed", "Not Alone", "Off Your Rocker", "On Your Way", "One of a kind", "Optimistic", "Out of this World", "Outstanding", "Passionate", "Patient", "Powerful", "Rare", "Real", "Reliable", "Remarkable", "Sassy", "Savage", "Sincere", "Smart", "Special", "Sympathetic", "The Bee's Knees", "Thoughtful", "Trying Your Best", "Trustworthy", "Up To No Good", "Valued", "Warmhearted", "Wonderful", "Watermelon Sugar", "Like That Summer Feeling", "A beacon of hope", "A good sharer", "A kind soul", "A quality friend", "A smart cookie", "A special human", "A stunner", "A style icon", "Angelic", "Bubbly", "Cooler than the rest", "Doing great", "Eccentric", "Effervescent", "Genuine", "High-spirited", "Influential", "Kindhearted", "Lively", "My world", "On fire", "Out of your beautiful mind", "Remarkable", "Sweet like sugar", "A Sweetie pie", "The apple of my eye", "The avocado to my toast", "The pea to my pod", "The peanut butter to my jelly", "Upbeat", "Watermelon sugar", "A Fine Line", Β "Golden", "Mushy", "Lovey-dovey", "Warm", "Forever", "A bright burning fire", "Enchantment", "Captivating", "Ravishing", "Chill", "Calm, Β cool, Β & collected", "On top of the world", "Tender", "Delicate like a flower", "Sugar pie", "Yummy", "A sweetie Pie", "A Cuddle Muffin", "Cordially invited", "On my guest list", "Front row", "Hungry for more", "Happy to be here", "Going places", "Headed somewhere special", "Live From New York", "Waiting for more", "Ready for what's to come", "Excited for December 13th", "Counting down the days", "Hartarbeitend", "GroΓΕΈartig", Β "EntzΓΌckend", Β "Travailleuse", Β "Incroyable", Β "PrΓ© cieuse"
6 notes
Β·
View notes