blog.databasepatterns.com
Database PatternsA blog about databases
http://blog.databasepatterns.com/
A blog about databases
http://blog.databasepatterns.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
172.217.6.211
LOAD TIME
0.531 sec
SCORE
6.2
Database Patterns | blog.databasepatterns.com Reviews
https://blog.databasepatterns.com
A blog about databases
blog.databasepatterns.com
Database Patterns: December 2015
http://blog.databasepatterns.com/2015_12_01_archive.html
A little Postgres. A little Spring. Wednesday, December 30, 2015. UNIX-like row permissions in PostgreSQL. And mode group read() or owner =? And mode owner read(); delete from foo where mode world delete() or group in (? And mode group delete() or owner =? And mode owner delete();. Links to this post. Monday, December 14, 2015. Duplicity Backup on OpenBSD 5.8. The duplicity 0.6.26 package seems to be broken for OpenBSD 5.8 (i386). Here's how to make it work. Get the ports tree and unpack it:. See http:/ ...
Database Patterns: PL/V8 vs PL/pgSQL
http://blog.databasepatterns.com/2014/08/plv8-vs-plpgsql.html
A little Postgres. A little Spring. Wednesday, August 20, 2014. A not-so-scientific test comparing PL/V8 and PL/pgSQL. Actual database access seems about the same, but from everything I have seen, PL/V8 always beats PL/pgSQL in terms of performance for logic. Concatenation, eg,. Result = result Fizz;. Is very expensive in plpgsql. Allocation / deallocation is expensive, and no string buffer optimizations are taken. April 20, 2015 at 2:46 AM. Subscribe to: Post Comments (Atom). PostgreSQL 9.6 Wish List.
Database Patterns: Crush Tools convdate
http://blog.databasepatterns.com/2016/07/crush-tools-convdate.html
A little Postgres. A little Spring. Wednesday, July 27, 2016. Convert dates on the command line. Echo '7-25-2015-12:12:12' convdate - verbose 2016-07-25-12:12:12. Echo '7/25/16' convdate - verbose -i '%m/%d/%y' -o '%Y-%m-%d' 2016-07-25. I is the input format, as per http:/ pubs.opengroup.org/onlinepubs/009695399/functions/strptime.html. O is the output format, as per http:/ pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html. Subscribe to: Post Comments (Atom). TF-IDF Text Search in Postgres.
Database Patterns: Crush Tools dbstream with PostgreSQL
http://blog.databasepatterns.com/2016/07/crush-tools-dbstream-with-postgresql.html
A little Postgres. A little Spring. Monday, July 25, 2016. Crush Tools dbstream with PostgreSQL. There's a command line library from Google called Crush Tools. It hasn't been updated for a while, but a few commands look useful, like pivot and aggregate. There's also one called dbstream, which is a perl script to stream to/from a database. Here's how to run it (on OS X anyways):. Install it (crush-tools, Perl package manager, Perl PostgreSQL driver):. Or insert each record from a file:. See http:/ blog...
Database Patterns: Easy XPath against HTML
http://blog.databasepatterns.com/2016/07/easy-xpath-against-html.html
A little Postgres. A little Spring. Wednesday, July 27, 2016. Easy XPath against HTML. UPDATE. Even easier with xidel. Xidel 'http:/ example.com' - extract '/ title'. Curl -L example.com tidy -asxml -numeric -utf8 sed -e 's/ xmlns.*=".*"/ g' xml select -t -v "/ title" -n. Get the HTML content from http:/ example.com. Use HTML Tidy to tidy it up, covert it to XHTML, change &entities; to numeric ones, and set the encoding as UTF-8. Use sed to remove the XML namespace, for simpler XPaths. First, a huge cong...
TOTAL PAGES IN THIS WEBSITE
19
dataalgo - 全新的正體中文 WordPress 網誌！
DataAllure
DataArt Blog
CONTACT US 1 (212) 378-4108. TECHNOLOGY CONSULTING and SOLUTION DESIGN. Healthcare and Life Sciences. Cloud and Big Data. Healthcare and Life Sciences. Healthcare and Life Sciences. Microsoft Azure Message Exchange or Tips for Successful Cloud Communication. By Anastasia Belokurova, .NET Developer. DeviceHive Releases Version 2.0. We are proud to announce DeviceHive 2.0: faster, friendlier, more functional IoT Data Platform with a rich IoT Gateway framework. Get in touch. By Oleg Kapustin, Senior DBA.
無効なURLです
Repeatable Read - the blog of Chris Leonard, database guy
Database Patterns
A little Postgres. A little Spring. Wednesday, July 27, 2016. Convert dates on the command line. Echo '7-25-2015-12:12:12' convdate - verbose 2016-07-25-12:12:12. Echo '7/25/16' convdate - verbose -i '%m/%d/%y' -o '%Y-%m-%d' 2016-07-25. I is the input format, as per http:/ pubs.opengroup.org/onlinepubs/009695399/functions/strptime.html. O is the output format, as per http:/ pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html. Links to this post. Links to this post. Easy XPath against HTML.
DataBasic.io Blog | About Our Tools and Activities for Learning to Work with Data
About Our Tools and Activities for Learning to Work with Data. Skip to primary content. Skip to secondary content. Designing Tools for Learners (Not Users). We (Catherine and Rahul) just co-authored an article in the Journal of Community Informatics called Design Principles, Tools and Activities for Data Literacy Learners. We offer four qualities that a tool designed for learners should aspire to be: focused. And we go on to talk about DataBasic as a case study. Here are the four qualities:. Tool is intr...
DataBasics
HOW TO Set Up Crop Area for Predefined Sizes. In Cumulus 9.2 you can set up a crop area to default your requirements. For example, if you’re regularly using 1024 x 768 dimensions, the administrator can set up crop sizes for download to match your requirements. When the user selects “download”, a number of available download options are displayed, depending on what the administrator has set up. Wednesday, August 05, 2015. Flight for your Agency. Profit margins are important for creative agencies. Now busi...
Bathgate Flooring Complete Raised Access Flooring Solutions
Bathgate provide a full raised access flooring service from initial design assistance through to supply, installation, project management and maintenance. Complete Raised Access Flooring Solutions. Bathgate Flooring is one of Europes Leading suppliers of access fooring solutions. We provide a complete managed service including design support, supply, installation and project management. Find out more ». Find out more ». Find out more ».
Databazaar Blog
May 10, 2016. Canon imageCLASS MF4150 Multifunction Laser Printer- A Value for Money Printing Solution. Canon imageCLASS MF4150 Multifunction Laser Printer. The MF4150 Multifunction Laser Printer. Specifications at a Glance. Canon imageCLASS MF4150 Laser Printer. Has a printing speed of 21 ppm and can deliver the first print within 9.6 seconds, which is pretty fast for a Printer of this caliber. It offers print resolution of up to 600x600 dpi (enhanced to 1200x600 dpi by using the smoothing technology).
Data Big Bang Blog | Creativity and Problem Solving for Data Science (whatever it may mean…) | An experimental spin-off from Nektra Advanced Computing
Data Big Bang Blog. Creativity and Problem Solving for Data Science (whatever it may mean…) An experimental spin-off from Nektra Advanced Computing. Big Data and Data Science Blogs Ordered by Google PageRank. The Call of the Web Scraper. Astrid, our Data Big Bang and Nektra. Content editor, is heading to Nepal on a birding and trekking quest. She needs birds sounds from xeno-canto. And The Internet Bird Collection. Like most script developers. we want to do things our own way. Our code. November 18, 2013.
