Re: [sqlite] Can I get help with db design for SQLite use?
You might want to import everything into SQLite Studio or SQLite Suite I forget the exact name)--a freebie on the internet. I found it worked for me. In order to help others, I would appreciate it if you tell us on this usergroup how you made out. May it work for you. Peace! Alex -- Original Message -- From: Tom Browder To: SQLite mailing list Subject: Re: [sqlite] Can I get help with db design for SQLite use? Date: Tue, 2 Apr 2019 15:07:58 -0500 On Tue, Apr 2, 2019 at 10:26 Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > I need help with a db design to be modeled for use with SQLite. The design > > uses foreign keys and I am just now using the foreign pragmas and other > > parts of SQLite to help me make it all work together. > > > > Is this list appropriate for presenting my design and requesting advice? ... > Yes, you can post a schema here (paste it into your message, attachments are > stripped) ... > Do be aware that almost all of us are just users like you. We are not > professional > designers, we argue with one-another, and you can't sue us if we give you bad > advice. Thanks, Simon, I will try to be a courteous and objective participant! -Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Our Hearts Go Out To Denzel Washington go.dedicatedoffers.com http://thirdpartyoffers.juno.com/TGL3131/5ca3e2679432962674b79st04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] HELP!
November 10, 2018 Dear Good People: I work for a company that has a many locations with more than one person in every location. I want to share the databases I have built using SQLITE with some of the people in each location. Do any of you good people know is SQLITE on the cloud? lf so, I would be most appreciative if you would tell me how to access it. 2) If SQLITE is on the cloud, how do I restrict access--so that one information (not like spelling errors) is inputted, the information cannot be removed. 3) Is there a spell checker function on SQLITE? ?if so, please advise very specifically how to find and use it. If any of you good people can help me solve these dilemmas, I would be most appreciative. Thank you very much in advance for helping me solve these problems. Respectfully yours, Alex Stavis 1 Simple Trick Removes Lip Lines & Eye Bags in Seconds Fit Mom Daily http://thirdpartyoffers.juno.com/TGL3131/5be77c818908f7c813b2est01vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Help!
November 6, 2018 Dear Good People: I would be most appreciative if any of you how know how to take a database in database (not structure) form--and copy and paste it into an e-mail, please explain in extremely explicit detail. Thanks much in advance. Respectfully yours, Alex Stavis Judge Judy Steps Down After 23 Years Over This Controversy glancence-hality.com http://thirdpartyoffers.juno.com/TGL3131/5be1f0f4d2d2270f42c4est02vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!
10/27/18 Thanks so much Clements, Respectfully yours, Alex Stavis -- Original Message -- From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Help! Date: Sat, 27 Oct 2018 21:55:28 +0200 am...@juno.com wrote: > how do I make a field wrap the text. In other words, rather than having > the text in a field keep going from right to left, when I hit the right > hand margin, how do I make the text automatically go to the next line. The purpose of SQLite is to store data, and to give it back to you unchanged. How the data is formatted for displaying is not the database's concern. It is likely that the software that you're using to display fields has an option for automatic word wrapping, but nobody here knows what software that is. > how do I simultaneously nest two or more fields. For instance, if I have > four fields: name, department, clock number, department, how do I nest so > that I alphabetically, sort by the clock number, then last name within > each department, and ten clock number within in each name? Just put the column names in this order in the ORDER BY clause when doing the SQL query. (Assuming that whatever software you're using allows you to customize the query.) Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users No More Tinnitus: 1 Odd Trick Ends The Ringing Overnight fighttinnitusnow.com http://thirdpartyoffers.juno.com/TGL3131/5bd4e14437d6a61444dd4st04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!
10/27/18 Thanks so much Clements, Respectfully yours, Alex Stavis -- Original Message -- From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Help! Date: Sat, 27 Oct 2018 21:55:28 +0200 am...@juno.com wrote: > how do I make a field wrap the text. In other words, rather than having > the text in a field keep going from right to left, when I hit the right > hand margin, how do I make the text automatically go to the next line. The purpose of SQLite is to store data, and to give it back to you unchanged. How the data is formatted for displaying is not the database's concern. It is likely that the software that you're using to display fields has an option for automatic word wrapping, but nobody here knows what software that is. > how do I simultaneously nest two or more fields. For instance, if I have > four fields: name, department, clock number, department, how do I nest so > that I alphabetically, sort by the clock number, then last name within > each department, and ten clock number within in each name? Just put the column names in this order in the ORDER BY clause when doing the SQL query. (Assuming that whatever software you're using allows you to customize the query.) Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Study Reveals What Just A Single Diet Soda Does To Your... nucific.com http://thirdpartyoffers.juno.com/TGL3131/5bd4e08e9cb8608d3d62st04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Help!
October 22, 2018 Hello Good People: I need to import a large bunch of names (first and last), and id numbers into SQ Lite. How do I do en-mas--as opposed to copying and pasting each individual name, clock number, etc? I would be most appreciative if you would give me very explicit directions. Thanks very much in advance. Respectfully yours, Alex Stavis How To Remove Eye Bags & Lip Lines Fast (Watch) Fit Mom Daily http://thirdpartyoffers.juno.com/TGL3131/5bce42dea708f42de5ea5st03vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Help!
October 2, 2018 Dear Good People: While I have both SQLite DB and SQlite Studio on I my computer, I have not been able to export files from SQLite DB to SQLite Studio--so that I get all the database functions I need. This involves say putting a field in ascending order, filtering out information that I want via a search. As such, I would be most appreciative if someone would e-mail me incredibly explicit directions on how to import a file in SQLite DB to SQLite studio. Thank you very much in advance for helping me out on this dilemma without charging me. Respectfully yours, Alex Stavis P.S. If you can answer me within one hour that would be great--as sometimes I get an overflow message after one hour. 1 Simple Trick Removes Eye Bags & Lip Lines in Seconds ourhealthpros.com http://thirdpartyoffers.juno.com/TGL3131/5bb3eacc20cc96acc25c5st01vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] I Heed Help
August 18, 2018 I am stuck on the dilemmas below. If any of you have any free programming solutions for any/all of these dilemmas I am in--in a way that I can download what yo have so someone who has no programming experience and can just 'click and use' (i.e., turnkey solutions), please advise. Once I hear back that you have any/all solutions to my dilemmas below, I will give you an e-mail address to send them to. Thank you vern much in advance for helping me eliminate these dilemmas. 1) How Can I do a search--say for people trained on one task, or on a given date, or for people who know how to operate one specific piece of equipment? 2) How can I set up SQLite so some people can only read SQLite? 3) How can I sent up a table/report of my results? 4) How can I put in ascending or descending order all the information on one field, say by date I gave out safety glasses? Respectfully yours, Alex Stavis -- Original Message -- From: R Smith To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] questions Date: Sat, 18 Aug 2018 20:29:26 +0200 Hi Alex, I like the way you type, it's how I imagine text will look in the future when we have successfully completed chip implants in the brain that directly outputs the text of what we are thinking. :) So if I understand you correct, you have a database in SQLite which you have developed or somehow filled with some data (possibly using a DB manager of sorts) that is tailored to the needs at your place of work. Now you would like this data to be visible to some people in a useful way. It's hard to know what the specific needs or specification is from the description, but I assume you would like someone to assist and make the program(s) for you/with you. I'm sure everyone here is capable, but most people here already have a full-time job, so you'd probably have more luck at a site like freelancer.com (where you can hire expert people on the cheap). If you only say "I need help" the best we can answer is: "We can see that." Questions here have to be somewhat specific, even if you post some code in whatever programming platform you have, you will typically get some help with it here. To get best answers here, what you can do is post a query that you have made, along with your table schema / layout, and then ask how to make that query better, for instance how to order it ascending or filter it, or perhaps how to improve the schema itself, and for that you should get loads of results from here. Best of luck! Ryan On 2018/08/18 7:15 PM, am...@juno.com wrote: > August 18, 2018, Hello Roger, Thank you so much for your answer, and so fast > at that! Going forward, the programming I am looking for does not have to be > 'off-the-shelf' It could be programming done by someone the s/he is willing > to shine with me--as long as it solves my dilemmas. Also, this programming > does not have to be 'industry-specific'. As always, if you have any > questions, need more information and/or need any clarifications, ask away. > Respectfully yours, Alex Stavis > > -- Original Message -- > From: Roger Schlueter > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] questions > Date: Sat, 18 Aug 2018 09:42:38 -0700 > > Hi Alex, > > This functionality is certainly something that SQLite or even any > moderately capable database system can solve. However, for these > specific requirements there is very likely no off-the-shelf, ready-to-go > solution unless the requirement is very common or regulatory-required in > your industry. > > > On 8/18/2018 9:24, am...@juno.com wrote: >> August 18, 2018 Good Morning Good People: I am in the process of building a >> database for where I work. I can do a lot of tasks with SQLite. But I am >> stuck on the dilemmas below. If any of you have any programming solutions >> for any/all of these dilemmas I am in--in a way that I can download what yo >> have so someone who has no programming experience and can just 'click and >> use' (i.e., turnkey solutions, please advise. Once I hear back that you have >> any/all solutions to my dilemmas below, I will give you an e-mail address to >> send them to. Thank you vern much in advance for helping me eliminate these >> dilemmas. 1) How Can I do a search--say for people trained on one task, or >> on a given date, or for people who know how to operate one specific piece of >> equipment? 2) How can I set up SQLite so some people can only read SQLite? >> 3) How can I sent up a table/report of my results? 4) How can I put in >> ascending or descending order all the information on one field, say by date >> I gave out safety glasses? Respectfully yours, Alex Stavis ___ sqlite-users mailing list sql
Re: [sqlite] questions
August 18, 2018, Hello Roger, Thank you so much for your answer, and so fast at that! Going forward, the programming I am looking for does not have to be 'off-the-shelf' It could be programming done by someone the s/he is willing to shine with me--as long as it solves my dilemmas. Also, this programming does not have to be 'industry-specific'. As always, if you have any questions, need more information and/or need any clarifications, ask away. Respectfully yours, Alex Stavis -- Original Message -- From: Roger Schlueter To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] questions Date: Sat, 18 Aug 2018 09:42:38 -0700 Hi Alex, This functionality is certainly something that SQLite or even any moderately capable database system can solve. However, for these specific requirements there is very likely no off-the-shelf, ready-to-go solution unless the requirement is very common or regulatory-required in your industry. On 8/18/2018 9:24, am...@juno.com wrote: > August 18, 2018 Good Morning Good People: I am in the process of building a > database for where I work. I can do a lot of tasks with SQLite. But I am > stuck on the dilemmas below. If any of you have any programming solutions for > any/all of these dilemmas I am in--in a way that I can download what yo have > so someone who has no programming experience and can just 'click and use' > (i.e., turnkey solutions, please advise. Once I hear back that you have > any/all solutions to my dilemmas below, I will give you an e-mail address to > send them to. Thank you vern much in advance for helping me eliminate these > dilemmas. 1) How Can I do a search--say for people trained on one task, or on > a given date, or for people who know how to operate one specific piece of > equipment? 2) How can I set up SQLite so some people can only read SQLite? 3) > How can I sent up a table/report of my results? 4) How can I put in ascending > or descending order all the information on one field, say by date I gave out > safety glasses? Respectfully yours, Alex Stavis > > Oncologists Freak Out Over True Cause of Cancer > pro.naturalhealthresponse.com > http://thirdpartyoffers.juno.com/TGL3131/5b784864d59cb48641affst04vuc > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] questions
August 18, 2018 Good Morning Good People: I am in the process of building a database for where I work. I can do a lot of tasks with SQLite. But I am stuck on the dilemmas below. If any of you have any programming solutions for any/all of these dilemmas I am in--in a way that I can download what yo have so someone who has no programming experience and can just 'click and use' (i.e., turnkey solutions, please advise. Once I hear back that you have any/all solutions to my dilemmas below, I will give you an e-mail address to send them to. Thank you vern much in advance for helping me eliminate these dilemmas. 1) How Can I do a search--say for people trained on one task, or on a given date, or for people who know how to operate one specific piece of equipment? 2) How can I set up SQLite so some people can only read SQLite? 3) How can I sent up a table/report of my results? 4) How can I put in ascending or descending order all the information on one field, say by date I gave out safety glasses? Respectfully yours, Alex Stavis Oncologists Freak Out Over True Cause of Cancer pro.naturalhealthresponse.com http://thirdpartyoffers.juno.com/TGL3131/5b784864d59cb48641affst04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
