Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
We are still busy preparing this batch of data. Please come back in a few minutes.
Seems like this data source was never ran before...
Changes are only available only when you have ran at least a second time.
Nope... guess no Martians around... Maybe set the webhook URL before pressing this button again...
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
---|---|---|---|---|---|---|---|---|---|
Collect statistics about data in tables, Hints to the query optimizer, Parallel q... | 7. Other Optimization Techniques | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | |||
From declarative SQL to a procedural execution plan, Scanning tables and indexes,... | 1. How SQL Executes a Query | How SQL executes queries, Working with PostgreSQL tools for tuning, Bitmap and ha... | Course Goal | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | |
Horizontal vs. vertical partitioning, Partition by range, Partition by range exam... | 5. Partitioning Data | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | |||
Indexing, B-tree indexes, B-tree index example plan, Bitmap indexes, Bitmap index... | 3. Types of Indexes | Trainers | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | ||
Installing PostgreSQL, Overview of pgAdmin, Explain and analyze, Example plan: Se... | 2. PostgreSQL Tools for Tuning | Agenda | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | ||
Materialized views, Creating materialized views, Refreshing materialized views | 6. Materialized Views | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | |||
Next steps | Conclusion | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | |||
Reduce query reponse time with query tuning, What you should know | Introduction | Description | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | ||
What affects joins performance?, Nested loops, Nested loop example plan, Hash joi... | 4. Tuning Joins | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | https://learn.epam.com/detailsPage?id=cf3d74d6-e934-4398-a971-334f29fd728b | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC | 2022-07-30 22:07:47 UTC |
Sample code snippets to quickly import data set into your application
For more information on how to automatically trigger an import please reference our WebHook API guide
Integrating with Java
import java.io.BufferedReader; import java.io.InputStreamReader; import java.net.URL; import java.net.URLConnection; import java.util.Arrays; public class HelloWorld { public static void main(String[] args) { try { URL urlCSV = new URL( "https://cache.getdata.io/n109708_197b1adbbf78aa4e4d496ee6bbd9e34eeses/latest_all.csv" ); URLConnection urlConn = urlCSV.openConnection(); InputStreamReader inputCSV = new InputStreamReader( ((URLConnection) urlConn).getInputStream() ); BufferedReader br = new BufferedReader(inputCSV); String line; String[] fields; while ((line = br.readLine()) != null) { // Each row fields = line.split(","); System.out.println(Arrays.toString(fields)); } // clean up buffered reader br.close(); } catch (Exception e) { System.out.println(e.getMessage()); } } }
Integrating with NodeJs
const csv = require('csv-parser'); const https = require('https'); const fs = require('fs'); const file = fs.createWriteStream("temp_download.csv"); const request = https.get( "https://cache.getdata.io/n109708_197b1adbbf78aa4e4d496ee6bbd9e34eeses/latest_all.csv", function(response) { response.pipe(file); } ); file.on('finish', function() { file.close(); fs.createReadStream('temp_download.csv').pipe(csv()).on('data', (row) => { // Each row console.log(row); }).on('end', () => { console.log('CSV file successfully processed'); }); });
Integrating with PHP
$data = file_get_contents("https://cache.getdata.io/n109708_197b1adbbf78aa4e4d496ee6bbd9e34eeses/latest_all.csv"); $rows = explode("\n",$data); $s = array(); foreach($rows as $row) { # Each row var_dump( $row); }
Integrating with Python
import csv import urllib2 url = 'https://cache.getdata.io/n109708_197b1adbbf78aa4e4d496ee6bbd9e34eeses/latest_all.csv' response = urllib2.urlopen(url) cr = csv.reader(response) for row in cr: # Each row print row
Integrating with Ruby
require 'open-uri' require 'tempfile' require 'csv' temp_file = Tempfile.new( "getdata", :encoding => 'ascii-8bit') temp_file << open("https://cache.getdata.io/n109708_197b1adbbf78aa4e4d496ee6bbd9e34eeses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
created on 2024-12-28