Hi all, Does anyone know a good windows client for sqlite 3? typical use is create and modify tables and export creation queries. Thanks, Nicolas -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/363834cf/attachment.html
Try SQLyog, it quite handy -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Nicolas Buet Sent: Tuesday, February 28, 2006 6:49 PM To: rails@lists.rubyonrails.org Subject: [rails] windows sqlite client? Hi all, Does anyone know a good windows client for sqlite 3? typical use is create and modify tables and export creation queries. Thanks, Nicolas -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/932e903a/attachment.html
sqlyog is for mysql isn''t it? I am looking for someting that suports sqlite3. On 2/28/06, GeekEntrepreneu <geekentrepreneur@gmail.com> wrote:> > Try SQLyog, it quite handy > > -----Original Message----- > *From:* rails-bounces@lists.rubyonrails.org [mailto: > rails-bounces@lists.rubyonrails.org] *On Behalf Of *Nicolas Buet > *Sent:* Tuesday, February 28, 2006 6:49 PM > *To:* rails@lists.rubyonrails.org > *Subject:* [rails] windows sqlite client? > > Hi all, > > Does anyone know a good windows client for sqlite 3? typical use is create > and modify tables and export creation queries. > > Thanks, > > Nicolas > > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/186fdc0d/attachment.html
I''ve found that Migrations handle all of that, plus they''re portable. That''s why I use sqlite for development.... so I can use the migrations to create my tables and I don''t have to worry about creating databases, creating user access, etc. -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Nicolas Buet Sent: Tuesday, February 28, 2006 7:19 AM To: rails@lists.rubyonrails.org Subject: [rails] windows sqlite client? Hi all, Does anyone know a good windows client for sqlite 3? typical use is create and modify tables and export creation queries. Thanks, Nicolas -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060228/50c8c154/attachment.html
Same here. I also use script/console if I need to do inspection. Was going to say that, but I didn''t want to appear unhelpful. I did do a search for you and found nothing. Sounds like an opportunity. How about something in Rails, a la PhpMyAdmin. Michael
Hey that actually would be a neat project! -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Michael Trier Sent: Tuesday, February 28, 2006 9:30 AM To: rails@lists.rubyonrails.org Subject: Re: [rails] windows sqlite client? Same here. I also use script/console if I need to do inspection. Was going to say that, but I didn''t want to appear unhelpful. I did do a search for you and found nothing. Sounds like an opportunity. How about something in Rails, a la PhpMyAdmin. Michael _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails
Nicolas Buet wrote:> Hi all, > > Does anyone know a good windows client for sqlite 3? typical use is > create and modify tables and export creation queries.I believe sqlitecc runs on Windows, but I haven''t tested it. It looks fairly complete. -- Alex