kkaneko.com 2024 著作権. ä¸è¨±è¤‡è£½ プライãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
Ruby ã«ã‚ˆã‚‹ Web/データベース・プãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
kkaneko.com 2024 著作権. ä¸è¨±è¤‡è£½ プライãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
SQLite入門
データベース㮠SQLite ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLite ã¯ã‚µãƒ¼ãƒã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã®ã§ã¯ãªãå˜ç‹¬ã®ã‚¢ãƒ—リケーションã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚インストールも簡å˜ãªä¸Šã«éžå¸¸ã«ã‚³ãƒ³ãƒ‘クトãªãŸã‚ã€ã‚¢ãƒ—リケーションã¨ä¸€ç·’ã«é…布ã™ã‚‹ã¨ã„ã£ãŸåˆ©ç”¨ã‚‚数多ãã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ 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}}