This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version='1.0' encoding='UTF-8'?> | |
<gexf xmlns="http://gexf.net/1.3" version="1.3" xmlns:viz="http://gexf.net/1.3/viz" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://gexf.net/1.3 http://gexf.net/1.3/gexf.xsd"> | |
<meta lastmodifieddate="2024-03-14"> | |
<creator>Gephi 0.10.1</creator> | |
<title></title> | |
<description></description> | |
</meta> | |
<graph defaultedgetype="directed" mode="static"> | |
<nodes> | |
<node id="Uncle Vernon"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version='1.0' encoding='UTF-8'?> | |
<gexf xmlns="http://gexf.net/1.3" version="1.3" xmlns:viz="http://gexf.net/1.3/viz" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://gexf.net/1.3 http://gexf.net/1.3/gexf.xsd"> | |
<meta lastmodifieddate="2024-03-14"> | |
<creator>Gephi 0.10.1</creator> | |
<title></title> | |
<description></description> | |
</meta> | |
<graph defaultedgetype="directed" mode="static"> | |
<nodes> | |
<node id="Uncle Vernon"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
10-19 business | |
11 projects | |
11.01 current | |
11.02 arhived | |
12 company_1 | |
13 volunteering | |
14 resume | |
15 youtube | |
16 activism | |
17 manufacturing |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- name: DO | |
hosts: localhost | |
vars: | |
project_name: "PUT A NAME FOR YOUR PROJECT HERE" | |
do_token: "PUT YOUR DIGITAL OCEAN API KEY HERE ==> https://cloud.digitalocean.com/settings/api/tokens" | |
repository: "PUT YOUR REPOSITORY URL HERE" | |
- name: NODE | Clone/Pull repo | |
git: | |
repo: "{{repository}}" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
U UNITY SOFTWARE INC COM 22.0 3038.76 | |
RY ROYAL BK CDA COM 15.0 1074.94 | |
SNE SONY CORP SPONSORED ADR 11.0 954.31 | |
ABT ABBOTT LABS COM 9.0 948.43 | |
AL AIR LEASE CORP CL A 20.8 724.21 | |
VIACA VIACOMCBS INC CL A 20.0 638.22 | |
ABBV ABBVIE INC COM 6.0 544.41 | |
TFC TRUIST FINL CORP COM 13.0 513.86 | |
MMM 3M CO COM 3.0 504.77 | |
UMC UNITED MICROELECTRONICS CORP SPON ADR NEW 75.0 483.6 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Definition of Structure: | |
Level: Level Name: Code Format: Number of Items: | |
Level 1 Major Group 1 10 items | |
Level 2 Sub-major Group 12 43 items | |
Level 3 MInor Group 121 130 items | |
Level 4 Unit Group 1211 436 items |
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"user_username","article_url","image_count","post_tags","recommends","reading_time","title","text","link_count" | |
"neuroecology","https://medium.com/@neuroecology/punctuation-in-novels-8f316d542ec4","22","{Writing,Literature,""Data Visualization""}","2670","3.67641509433962","Punctuation in novels","","1" | |
"eklimcz","https://medium.com/truth-labs/designing-data-driven-interfaces-a75d62997631","14","{""Data Visualization"",""Design Thinking"",UX}","2660","7.83867924528302","Designing Data-Driven Interfaces","","2" | |
"quincylarson","https://medium.com/free-code-camp/the-economics-of-working-remotely-28d4173e16e2","5","{Tech,""Life Lessons"",""Data Science"",Travel,Startup}","2068","3.95786163522013","Fitter. Happier. More productive. Working remotely.","Travel the world as a digital nomad. Surf a new beach every morning. Eat a different local cuisine each night. | |
Or just stay home all day in your pajamas. | |
It doesn’t really matter. You can get your work done either way. | |
More than 10% of Americans now work remotely. | |
I’ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
fileA="$1" | |
shift | |
for fileB in "$@"; do | |
( | |
# diff once grep twice with the help of tee and stderr | |
diff $fileA $fileB | \ | |
tee >(grep -cE '^< ' >&2) | \ | |
grep -cE '^> ' >&2 |
NewerOlder