- Install Squirrel SQL.
- Download Microsoft JDBC Driver for SQL Server.
- Unpack JDBC Driver to a known location.
- Open Squirrel SQL
- From the menu bar, select Drivers > New Driver
:
import sys | |
import requests | |
from lxml import html | |
import time | |
if len(sys.argv) < 2: | |
print("Usage: {} URL [page jump limit]".format(sys.argv[0])) | |
exit() | |
link = sys.argv[1] |
அத்தனையு மீடுவேன் புன்கழலிணைகொடுத்துயர்ந்து | |
பொய்கைப்புனை மரடும் புதுவையாய் | |
மாலுழல் | |
ஈறுஞ்சத் திருப்பாதங்கள் கருருவாய் என் றரு ளாய கிழகூடுதீடுசித்தன்னைக்கொண்டு விளங்க உனைக்காக்கொண்டு | |
தீட்ட படுஞ் தென்னன் எம்பெருமை | |
இடிமுனிசெயில் இணைபொருதரும் | |
அறுசீர் நுவனையன் | |
வானே புகழுக்கும் அளுவாய் ஆண்டுட்டு போங்கேவந்து | |
தேவ புலாவரும் அறுத்தாற்பொழுங்காதே | |
உலகீண்டுறும் |
# --- install system dependencies (sudo apt-get install) | |
scrapyuser@8fb08da8f18b:/$ sudo apt-get install python3 python-dev python3-dev \ | |
> build-essential libssl-dev libffi-dev \ | |
> libxml2-dev libxslt-dev \ | |
> python-pip | |
[sudo] password for scrapyuser: | |
Reading package lists... Done | |
Building dependency tree | |
Reading state information... Done |
{ | |
"packages": [ | |
{ | |
"name": "auk", | |
"description": "eBird Data Extraction and Processing in R", | |
"details": "Extract and process bird sightings records from eBird \n (<http://ebird.org>), an online tool for recording bird observations. \n Public access to the full eBird database is via the eBird Basic Dataset \n (EBD; see <http://ebird.org/ebird/data/download> for access), a downloadable \n text file. This package is an interface to AWK for extracting data from the \n EBD based on taxonomic, spatial, or temporal filters, to produce a \n manageable file size that can be imported into R.", | |
"maintainer": "Matthew Strimas-Mackey", | |
"keywords": "dataset, ebird", | |
"github": "https://github.com/CornellLabofOrnithology/auk", | |
"status": { |
:
"""Print most frequent N-grams in given file. | |
Usage: python ngrams.py filename | |
Problem description: Build a tool which receives a corpus of text, | |
analyses it and reports the top 10 most frequent bigrams, trigrams, | |
four-grams (i.e. most frequently occurring two, three and four word | |
consecutive combinations). | |
NOTES |
Applicable for:
Steps to fix:
~/Library/Preferences/IdeaIC${IDEA_VERSION}/
~/Library/Preferences/IdeaIC2019.1/
../settingsRepository/repository/scala.xml
;object Schema2CaseClass { | |
import org.apache.spark.sql.types._ | |
case class RecFieldRes(fieldStr: String, additionalCc: Option[String] = None) | |
case class CcRes(cc: String, additional: List[String]) | |
def schema2Cc(schema: StructType, className: String): String = { | |
val res = CcRes(s"case class $className (\n", Nil) |
import sys | |
import os | |
import json | |
import argparse | |
PYTHON_MAJOR_VERSION = sys.version_info.major | |
DEFAULT_HOST = 'localhost' | |
DEFAULT_PORT = '8083' | |
BASE_PATH = '/connectors' |
This is a slightly stripped down version from our internal bug tracker. The point of posting this publicly is part FYI, part peer review. I'm hoping someone can look at this, disagree, and tell me all the downsides of using the C
locale or point out things I've misunderstood. The Recommendations
section in particular is contextualized by our database serving a SaaS product for users from many different locales, thus making locale a render level concern. YMMV, caveat emptor, etc.
Collation defines the character ordering for textual data. For Postgres, https://www.postgresql.org/docs/current/static/locale.html:
The locale settings influence the following SQL features:
- Sort order in queries using ORDER BY or the standard comparison operators on textual data
- The
upper
,lower
, andinitcap
functions