Sublime Text My Key Bindings
Erman Peremeci Overlay = Open Overlay = Goto Line = Cycle Keywords Basic Navigation = END = HOME = Line Home = Line End = PgUp = PgDwn , "command": "context_menu" Advanced…
How To Add Zemberek Turkish Analysis Components to Solr 9.4.0
Zemberek is a very useful Turkish NLP module. iorixxx made and manages a very useful Zemberek plugin for Apache Lucene and Solr. However i found installation instructions are somewhat confusing…
Understanding Solr Scheme -1
Solr supports two styles of schema: a managed schema and a manually maintained schema.xml file. When using a managed schema, features such as the Schema API and Schemaless Mode are…
MySQL Pagination with Cursor
https://www.youtube.com/watch?v=zwDIN04lIpc&ab_channel=PlanetScale
SQL Tabloya eklemeyi dene eklense de eklenmese de ID’sini al.
WITH s AS ( SELECT id FROM beta.kitaplar WHERE kitap = 'asdasd' ), i AS ( INSERT INTO beta.kitaplar ("kitap") SELECT 'asdasd' WHERE NOT exists (SELECT 1 FROM s) RETURNING…
PyCharm Kısayollarım
F1: StructureF2: Project ManagerF3: Database ManagerF4: ProblemsF5: DebugF6: ConsoleF7: Python ConsoleF8: Python PackagesF9: Version ControlF10: Find Cmd + R : RunCmd + D : Debug Cmd + Shft + 7:…
Create a Standart Table with PostgreS
https://www.postgresql.org/docs/current/datatype.html Tablo yaratma SQL’leri buraya gelecek. pip install psycopg2-binary
Python String Cheat Sheet
Method Description capitalize() Converts the first character to upper case Usage: x = txt.capitalize() casefold() Converts string into lower case center() Returns a centered string Usage: x = txt.center(15, "-").…
Python Regex Cheat Sheet
RegEx Functions Function Description findall Returns a list containing all matches. Usage: x = re.findall(“search”, txt) search Returns a Match object if there is a match anywhere in the string…
Python Operators and Conditionals Cheat Sheet
if condition: Do this…elif condition: Do Thatelse: Do That Shorthandif condition: do that For Loops While Loops