Pokemon data native in DuckDB
Maintainer(s):
Ian-Fogelman
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL psyduck FROM community;
LOAD psyduck;
Example
-- Create a table of pokémon and return... A duck
CREATE TABLE pokemon AS SELECT * FROM list_pokemon();
SELECT name FROM pokemon WHERE is_duck = 1 AND name LIKE '%Psyduck%';
-- Select the top 10 pokémon
SELECT * FROM list_pokemon() WHERE number <= 10;
-- Select legendary pokémon
SELECT * FROM list_pokemon() WHERE is_legendary = 1;
-- Select the best pokémon
SELECT number, name, type1, "height(m)", "weight(kg)", base_total FROM list_pokemon() WHERE name = 'Charizard';
-- Select pokemon moves
SELECT * FROM list_pokemon_moves();
-- Select gen1 items
SELECT * FROM list_pokemon_items();
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| list_pokemon | table | NULL | NULL | |
| list_pokemon_items | table | NULL | NULL | |
| list_pokemon_moves | table | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.