https://docs.timescale.com/v0.12/api#chunk_relation_size_pretty
SELECT chunk_table, table_size, index_size, total_size FROM chunk_relation_size_pretty('meas_time_data');
NagaSudhir Pulla nagasudhirpulla
🎯
nagasudhirpulla
/ Files.aspx
Last active
January 13, 2024 14:26
Directory Browsing with sorting and additional columns in IIS
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
| <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Files.aspx.cs" Inherits="Files.FilesPage" %> | |
| <%@ Import Namespace="System.Collections.Generic" %> | |
| <%@ Import Namespace="System.IO" %> | |
| <%@ Import Namespace="Files" %> | |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>Contents of <%= path %></title> | |
| <style type="text/css"> |
nagasudhirpulla
/ number_to_words.js
Last active
October 11, 2021 02:59
Javascript code to convert numbers to words in British system
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
| function inWords(numIn) { | |
| var inWordsSub = function(num) { | |
| var a = ['', 'One ', 'Two ', 'Three ', 'Four ', 'Five ', 'Six ', 'Seven ', 'Eight ', 'Nine ', 'Ten ', 'Eleven ', 'Twelve ', 'Thirteen ', 'Fourteen ', 'Fifteen ', 'Sixteen ', 'Seventeen ', 'Eighteen ', 'Nineteen ']; | |
| var b = ['', '', 'Twenty', 'Thirty', 'Forty', 'Fifty', 'Sixty', 'Seventy', 'Eighty', 'Ninety']; | |
| var n = ('0000000' + num).substr(-7).match(/^(\d{2})(\d{2})(\d{1})(\d{2})$/); | |
| if (!n) return; | |
| var str = ''; | |
| str += (n[1] != 0) ? (a[Number(n[1])] || b[n[1][0]] + ' ' + a[n[1][1]]) + 'Lakh ' : ''; | |
| str += (n[2] != 0) ? (a[Number(n[2])] || b[n[2][0]] + ' ' + a[n[2][1]]) + 'Thousand ' : ''; | |
| str += (n[3] != 0) ? (a[Number(n[3])] || b[n[3][0]] + ' ' + a[n[3][1]]) + 'Hundred ' : ''; |
https://wiki.postgresql.org/wiki/Disk_Usage
https://stackoverflow.com/questions/18907047/postgres-db-size-command
SELECT nspname || '.' || relname AS "relation",
pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
FROM pg_class C
- setting up tutorial
- Download Raspbian lite
- Flash Raspbian lite zip file into SD card using etcher software
- If SD card is showing wrong capacity or shown as 2 disks, goto device management and delete all partitions of sd card, create new simple volumn of type FAT32. Even then, if etcher could not flash raspbian, try using another laptop.
- save a file named
ssh(no extension) in the sd card - write the following in a file named
wpa_supplicant.confand save it in the sd card
country=in
nagasudhirpulla
/ psp_meas_api_notes.md
Last active
October 9, 2019 12:20
PSP measurements description
Each measurement is given an Id and queries are assigned to them Queries will have placeholders for time range Measurement Id will not have spaces
| id | name | query_string | date_type |
|---|---|---|---|
| 1 | WR_DAY_PEAK_DEMAND | select date_key, peak_demand_met from REPORTING_UAT.regional_availability_demand where date_key between {start_time} and {end_time} order by date_key | date_key |
| 2 | WR_DAY_PEAK_S |
oxyplot hover tooltip https://stackoverflow.com/questions/34867357/chart-plot-points-show-tool-tip-in-oxyplot
oxyplot official docs http://docs.oxyplot.org/en/latest/introduction/index.html
simple oxyplot example http://navjodh.com/general-programming/using-oxyplot-library-with-c/
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
| # -*- coding: utf-8 -*- | |
| """ | |
| Created on Sun Aug 12 19:22:37 2018 | |
| @author: Nagasudhir | |
| https://ashishpython.blogspot.com/2013/11/how-to-connect-one-computer-to-another_1.html?m=1 | |
| https://www.howtogeek.com/howto/16196/how-to-disconnect-non-mapped-unc-path-drives-in-windows/ |
Merge feature branch into master - https://stackoverflow.com/questions/14168677/merge-development-branch-with-master
git remove already added files of gitignore - https://stackoverflow.com/questions/1274057/how-to-make-git-forget-about-a-file-that-was-tracked-but-is-now-in-gitignore
Increase git postbuffer for large file sizes during push or clone - https://stackoverflow.com/questions/6842687/the-remote-end-hung-up-unexpectedly-while-git-cloning/19286776 , https://confluence.atlassian.com/stashkb/git-push-fails-fatal-the-remote-end-hung-up-unexpectedly-282988530.html git config --global http.postBuffer 524288000
Docs link -- https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity?tabs=visual-studio%2Caspnetcore2x
https://docs.microsoft.com/en-us/aspnet/core/security/app-secrets?tabs=visual-studio
We can create a secrets.json file in visual studio by right click on solution Manage User Secrets and then write the following in the secrets.json file
{
"ConnectionStrings": {NewerOlder