You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
previous() and upcoming() are window functions that retrieve the previous or the upcoming non-null value within a column in pgsql.
This file contains hidden or 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
`coalesce_equal(...)` is a PostgreSQL function that is similar to `coalesce`, but requires that all non-null arguments be equal for it to return the identical value, when not equal or all arguments are null, it returns null.
This file contains hidden or 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
Use Mermaid Diagrams in your IPython (i.e. Jupyter) Notebooks
You can do this either by using a public service like https://mermaid.ink or while hosting your own mermaid server. I find the latter option to be better in the long run, both in the individual and the collective sense. Below are recipes for both.
Using mermaid.ink
Use the following function defintion in your Jupyter notebook:
This file contains hidden or 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
Access iDRAC over a HTTPS (web UI) with Proxmox by installing the DELL OpenManage package on the Proxmox's Debian node system
This file contains hidden or 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
Fix workflows that used `svn export` to download a part of a repository from GitHub in 2024
This file contains hidden or 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
Ghana is a very peaceful but crazy place to live. Ghana is a country in the West Africa, where the people living in are black and are called Ghanaians. It was first named GOLD COST, because it was blessed with gold and was full of natural resources, Ghana gained her independence on 6th March 1957.
The first president to govern ghana was Osagyefo Dr Kwame Nkrumah.
The common language spoken in ghana is English but the traditional or local language in ghana is Twi, there are many dishes in ghana but the best and popular dish in ghana is Fufu, fufu is a dish made from cassava and yam or plantain together, the ghanaian dance is called "Adowa", and the ghana popular costume is "Kente". Ghana is a country ruled with written constitution and every four years election takes place to select a new president. Ghana has many political parties but the most popular parties which has ruled the country for the past 24 years are National Democratic Congress (NDC) and New Patriotic Party
Solution by Manisha/Sveta, modified for case-insensitive test cases
checks if a character is non-repeating by looking for the 2nd match in a string and ensuring that this 2nd match exists. Based on String.prototype.indexOf (check the second usage in the Syntax section on MDN).
This file contains hidden or 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
ganttdateFormatYYYY-MM-DDtitleExample of how to add a GANTT diagram to README.md using mermaid in GitHub-flavoured markdownexcludes weekdays 2014-01-10sectionA sectionCompleted task :done,des1,2014-01-06,2014-01-08Active task:active,des2,2014-01-09,3d