kkaneko.com 2025 著作権. ä¸è¨±è¤‡è£½ プライãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
Ruby ã«ã‚ˆã‚‹ Web/データベース・プãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
kkaneko.com 2025 著作権. ä¸è¨±è¤‡è£½ プライãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
SQLite入門
SQLite ã¯ã€è»½é‡ã§çµ„ã¿è¾¼ã¿åž‹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãã®ã‚·ãƒ³ãƒ—ルã•ã¨ä½¿ã„ã‚„ã™ã•ã‹ã‚‰ã€ãƒ¢ãƒã‚¤ãƒ«ã‚¢ãƒ—リã€ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—アプリã€IoT デãƒã‚¤ã‚¹ã€çµ„ã¿è¾¼ã¿ã‚·ã‚¹ãƒ†ãƒ ãªã©ã€ã•ã¾ã–ã¾ãªç’°å¢ƒã§åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLite ã®æœ€å¤§ã®ç‰¹å¾´ã¯ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹ã§ã‚ã‚‹ã“ã¨ã§ã™ã€‚ MySQL ã‚„ PostgreSQL ãªã©ã¯ã‚µãƒ¼ãƒãƒ¼åž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ãŒã€ SQLite ã¯å°‚用ã®ã‚µãƒ¼ãƒãƒ¼ã‚’å¿…è¦ã¨ã›ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’利用ã™ã‚‹ã‚¢ãƒ—リケーションã¨åŒã˜ãƒ—ãƒã‚»ã‚¹å†…ã§ãƒ‡ãƒ¼ã‚¿ã‚’æ“作ã§ãã¾ã™ã€‚ã¾ãŸ SQLite ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¨ä½“ã‚’ 1 ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ç®¡ç†ã—ã¾ã™ã€‚ãã®ãŸã‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—や別ã®ç’°å¢ƒã¸ã®ç§»è¡Œã‚‚ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’コピーã™ã‚‹ã ã‘ã§ç°¡å˜ã«è¡Œãˆã¾ã™ã€‚ SQLite ã¯æ‰‹è»½ã«åˆ©ç”¨ã§ãã€ãƒ¢ãƒã‚¤ãƒ«ç’°å¢ƒã‚’å«ã‚€å¤šãã®ãƒ—ラットフォームã§å‹•ä½œã™ã‚‹ãŸã‚ã€ã‚¢ãƒ—リや組ã¿è¾¼ã¿ã‚·ã‚¹ãƒ†ãƒ ã‚’å«ã‚€ã€å°è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ç®¡ç†ã§åºƒã利用ã•ã‚Œã¦ã„ã¾
inessential: On switching away from Core Data
A lot of the work I’ve been doing the last several months is optimizing performance for NetNewsWire for iPhone. The changes haven’t shipped yet, because I’m not quite finished. But one part of this might be interesting to other developers, so I figured I’d write it up. I optimized as much as I could, spent tons of time in Shark, went all multi-threaded with Core Data, switched away from my own que
iPhone Programming Tutorial – Creating a ToDo List Using SQLite Part 1 | iPhone Programming Tutorials
If you have been following my tutorials, you know that we have been working primarily with UITableViews. This is mostly because SO many applications can be developed using this simple control. This final UITableView tutorial will be taking all of the skills learned from previous tutorials, putting them all together, and adding SQLite to create a prioritized To-Do list. I will also be showing you h
SQL言語を触ã£ã¦å¦ã¹ã‚‹iPhoneアプリ「SqlSchool〠| パソコン | マイコミジャーナル
æ–°è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã«å¯¾å¿œã™ã‚‹ãªã©æ©Ÿèƒ½ãŒå‘上ã—ãŸã€ŒSqlSchool〠SQL言語ã®åŸºç¤Žã‚’実際ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“作ã—ã¦å¦ã¹ã‚‹iPhoneアプリ「SqlSchool 2.0ã€ãŒå…¬é–‹ã•ã‚ŒãŸã€‚対応デãƒã‚¤ã‚¹ã¯iPhoneã¨iPod touchã€å‹•ä½œç’°å¢ƒã¯iPhone OS 2.2.1以é™ã€‚ä¾¡æ ¼ã¯115円。 SqlSchoolã¯ã€iPhone OSã«åŽéŒ²ã•ã‚Œã¦ã„ã‚‹sqliteコマンドを利用ã—ãŸã€SQL言語ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚½ãƒ•ãƒˆã€‚インãƒãƒ¼ãƒˆã—ãŸã€Œé€£çµ¡å…ˆã€ãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’対象ã«ã€å†…蔵ã®ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚¨ãƒ‡ã‚£ãƒƒãƒˆæ©Ÿèƒ½ã‚’使ã„ã€SQLコマンドを実際ã«å…¥åŠ›ã—ã¦çµæžœã‚’ç”»é¢ã§ç¢ºèªã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚データベースã”ã¨ã«æœ€å¤§50ã®ã‚³ãƒžãƒ³ãƒ‰å±¥æ´ã‚’ä¿å˜ã™ã‚‹ã“ã¨ã‚‚ã§ãる。 今回ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€æ–°è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆæ©Ÿèƒ½ã‚’è¿½åŠ ã€‚å†…è”µã®Webサーãƒæ©Ÿèƒ½ãŒå¼·åŒ–ã•ã‚Œã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã«å¯¾å¿œã—ãŸã»ã‹ã€Webブラウザã‹ã‚‰ã‚¯ã‚¨ãƒªãƒ¼ã‚’
SQLiteを利用ã™ã‚‹æ–¹æ³• - プãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒŽãƒ¼ãƒˆ
下記サイトをå‚考ã«è‡ªåˆ†ã§ã‚‚試ã—ã¦ã¿ã¾ã—ãŸã€‚ 超簡å˜ã«Sqliteã‚’ã¤ã‹ã† iPhone Programming Tutorial - Creating a ToDo List Using SQLite Part 1 åˆ©ç”¨æ‰‹é † 1. DBファイルã¨ãƒ†ãƒ¼ãƒ–ルã®ä½œæˆ 2. å¿…è¦ãªãƒ©ã‚¤ãƒ–ラリ(FMDB for iPhone, libsqlite3.0.dylib)ã‚’è¿½åŠ 3. FMDBã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’利用ã—ã¦SQLiteを利用 DBファイルã¨ãƒ†ãƒ¼ãƒ–ルã®ä½œæˆ ã¾ãšã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ†ãƒ¼ãƒ–ルを作æˆã—ã¾ã™ã€‚ $ sqlite3 sample.db sqlite> CREATE TABLE TEST( ...> id INTEGER PRIMARY KEY, ...> name VARCHAR(255) ...> ); ã¨ã„ã†é¢¨ã«ã‚³ãƒžãƒ³ãƒ‰ã§ã‚„ã£ã¦ã‚‚ã„ã„ã§ã™ãŒã€ãƒ•ã‚¡ã‚¤ãƒ«ã ã‘作ã£ãŸã‚‰å¾Œã¯Litaã¨ã„ã†AIRã®SQL
1
ランã‚ング
ãŠçŸ¥ã‚‰ã›
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}